...
All
...
database
...
tables
...
used
...
by
...
Moves
...
are
...
being
...
migrated
...
to
...
their
...
own
...
schema
...
(MOVESMGR).
...
The
...
tables
...
are
...
in
...
two
...
groups:
...
- Tables
...
- specific
...
- to
...
- Moves
...
- (e.g.
...
- stack
...
- definitions)
...
- Tables
...
- used
...
- by
...
- OS
...
- Workflow
...
- (e.g.
...
- Moves
...
- workflow
...
- history)
...
[Note
...
that
...
OS
...
Workflow
...
tables
...
also
...
exist
...
in
...
INFRAMGR
...
-
...
those
...
tables
...
are
...
for
...
use
...
by
...
all
...
other
...
...
(i.e.
...
not
...
Moves)
...
apps
...
using
...
OS
...
Workflow.
...
]
...
Because
...
the
...
OS
...
Workflow
...
tables
...
now
...
exist
...
in
...
two
...
separate
...
schemas
...
(INFRAMGR
...
and
...
MOVESMGR),
...
we
...
must
...
take
...
care
...
to
...
use
...
the
...
correct
...
database
...
synonyms
...
to
...
point
...
to
...
the
...
right
...
set
...
of
...
tables.
...
- All
...
- non-Moves
...
- apps
...
- will
...
- use
...
- the
...
- default
...
- PUBLIC
...
- SYNONYMs
...
- for
...
- OS
...
- Workflow
...
- tables
...
- -
...
- these
...
- synonyms
...
- point
...
- to
...
- the
...
- INFRAMGR
...
- schema.
...
- The
...
- Moves
...
- app,
...
- as
...
- deployed
...
- on
...
- the
...
- servers
...
- (dev,
...
- test,
...
- prod,
...
- etc)
...
- will
...
- each
...
- have
...
- their
...
- data
...
- source's
...
- Oracle
...
- user
...
- account
...
- set
...
- up
...
- with
...
- PRIVATE
...
- synonyms
...
- for
...
- OS
...
- Workflow
...
- tables
...
- -
...
- these
...
- synonyms
...
- point
...
- to
...
- the
...
- MOVESMGR
...
- schema.
...
- Developers
...
- who
...
- are
...
- running
...
- Moves
...
- on
...
- their
...
- own
...
- workstations
...
- (and
...
- connecting
...
- to
...
- the
...
- database
...
- through
...
- their
...
- personal
...
- Oracle
...
- accounts)
...
- will
...
- need
...
- to
...
- create
...
- their
...
- own
...
- PRIVATE
...
- synonyms
...
- for
...
- OS
...
- Workflow
...
- tables
...
- -
...
- these
...
- synonyms
...
- will
...
- point
...
- to
...
- the
...
- MOVESMGR
...
- schema.
...
- It's
...
- important
...
- to
...
- be
...
- aware
...
- that
...
- if
...
- you
...
- are
...
- running
...
- a
...
- non-Moves
...
- app
...
- that
...
- uses
...
- OS
...
- Workflow
...
- (e.g.
...
- IAP
...
- or
...
- ETP),
...
- you
...
- must
...
- make
...
- sure
...
- that
...
- private
...
- synonyms
...
- for
...
- OS
...
- Workflow
...
- tables
...
- pointing
...
- to
...
- MOVESMGR
...
- are
...
- removed
...
- -
...
- you
...
- will
...
- then
...
- pick
...
- up
...
- the
...
- public
...
- synonyms
...
- and
...
- be
...
- correctly
...
- pointed
...
- to
...
- the
...
- INFRAMGR
...
- schema
...
- OSA
...
- Workflow
...
- tables.
...
Creating
...
and
...
Removing
...
Private
...
Synonyms
...
for
...
OS
...
Workflow
...
tables
...
Just
...
to
...
clarify:
...
if
...
you
...
are
...
running
...
Moves
...
locally
...
(on
...
your
...
workstation),
...
you
...
need
...
private
...
synonyms
...
created
...
under
...
your
...
database
...
account
...
for
...
the
...
OS
...
workflow
...
tables.
...
The
...
SQL
...
statements
...
to
...
create
...
the
...
synonyms
...
are:
| Code Block |
|---|
} – Sequence CREATE SYNONYM HIBERNATE_SEQUENCE for MOVESMGR.HIBERNATE_SEQUENCE; – Tables CREATE SYNONYM OS_CURRENTSTEP for MOVESMGR.OS_CURRENTSTEP; CREATE SYNONYM OS_HISTORYSTEP for MOVESMGR.OS_HISTORYSTEP; CREATE SYNONYM OS_PROPERTYENTRY for MOVESMGR.OS_PROPERTYENTRY; CREATE SYNONYM OS_WFDEFINITION for MOVESMGR.OS_WFDEFINITION; CREATE SYNONYM OS_WFENTRY for MOVESMGR.OS_WFENTRY; {code} |
A
...
downloadable
...
script
...
for
...
creating
...
the
...
synonyms
...
is
...
also
...
provided
...
...
.
Similarly,
...
if
...
you
...
are
...
running
...
an
...
OS
...
Workflow
...
app
...
that
...
is
...
not
...
Moves
...
(e.g.
...
IAP,
...
ETP),
...
you
...
should
...
make
...
sure
...
you
...
do
...
NOT
...
have
...
these
...
private
...
synonyms
...
defined
...
for
...
your
...
database
...
account.
...
To
...
remove
...
the
...
synonyms,
...
this
...
is
...
the
...
SQL:
| Code Block |
|---|
} – SequenceDROP SYNONYM HIBERNATE_SEQUENCE; -- Tables DROP SYNONYM OS_CURRENTSTEP ; DROP SYNONYM OS_HISTORYSTEP ; DROP SYNONYM OS_PROPERTYENTRY ; DROP SYNONYM OS_WFDEFINITION ; DROP SYNONYM OS_WFENTRY ; {code} |
A
...
downloadable
...
script
...
for
...
removing
...
the
...
synonyms
...
is
...
also
...
provided
...
...
.