Databases Reference
In-Depth Information
2.
Execute the following SQL commands to create a database directory named
dmpdir:
SQL> CREATE DIRECTORY dmpdir AS '<DIR>';
SQL> GRANT read, write ON DIRECTORY dmpdir TO <BAM_SCHEMA_NAME>;
When using these commands, replace the following variables:
•
<DIR>:
The directory location on the file system of the database
server, for example,
/home/oracle/migration
•
<BAM_SCHEMA_NAME>:
The database schema name for Oracle
BAM, for example,
dev_orabam
Shut down the administration server and all the managed servers.
3.
Execute the following Oracle database command to export the database
schema of Oracle BAM.
ORACLE_HOME/bin/expdp <BAM_SCHEMA_NAME> DIRECTORY=dmpdir SCHEMAS=<BAM_SCHEMA_NAME> DUMPFILE=orabam.dmp
4.
Replace the
<BAM_SCHEMA_NAME>
with the Oracle BAM schema name.
5.
Copy the
dump
file to the target node.
6.
Create a target schema on the target node, and then repeat
steps 1
and
2
to
create the database directory named
dmpdir
on the target node.
7.
Import the database schema for Oracle BAM that you exported earlier using
the following command:
ORACLE_HOME/bin/impdp system/<PASSWORD> DIRECTORY=dmpdir REMAP_SCHEMA=<SOURCE_SCHEMA>:<TARGET_SCHEMA> DUMPFILE=orabam.dmp
In this command, replace the following variables with the actual values:
•
<PASSWORD>:
The password for the system user