Expdp from source and impdp in target database with only one step.
Oracle DB = 11.2.0.3 (both - source and target)RAC = 3 nodes(target)
RAC = 2 nodes(source)
OS= RH LINUX 6
1. Is it possible to export most of the database from source database and import it straight into target database? Meaning, can i combine export/import steps and copy data/schemas from one database source(remote) into another(target) database?
2. is it possilble to replace all objects during import, i.e. roles, profiles, etc. in target database?
Presently, I am running
Step 1.
EXPORT PAR:
userid=test1/test21
DUMPFILE=exp_QAP_ExtngDB_12082013_%U.dmp
DIRECTORY=remote_datapump_dir
LOGFILE=exp_QAP_ExtngDB_12082013.log
FULL=Y
FILESIZE=20g
RAC = 2 nodes(source)
OS= RH LINUX 6
1. Is it possible to export most of the database from source database and import it straight into target database? Meaning, can i combine export/import steps and copy data/schemas from one database source(remote) into another(target) database?
2. is it possilble to replace all objects during import, i.e. roles, profiles, etc. in target database?
Presently, I am running
Step 1.
EXPORT PAR:
userid=test1/test21
DUMPFILE=exp_QAP_ExtngDB_12082013_%U.dmp
DIRECTORY=remote_datapump_dir
LOGFILE=exp_QAP_ExtngDB_12082013.log
FULL=Y
FILESIZE=20g
0