| oracle 10g Data pump [message #436522] |
Wed, 23 December 2009 23:31  |
Mohsin_Tm
Messages: 15
Registered: December 2009
Location: Pune
|
Junior Member |
|
|
Hi All,
We have Oracle 10g database and we are using data pump to import data from other server (Oracle 10g one).
We are using this commands.
impdp abc/abc@XYZ
PARFILE=K:\newtest\Log_imp.par
exit
PARALLEL=2
LOGFILE=PUMP:Log_LIVE.log
DIRECTORY=DATA_PUMP
NETWORK_LINK=Lk_Prod
REMAP_SCHEMA=ABC123:ABCREMAP_TABLESPACE=OMS_LARGE_INDEX:OMS_DATA
REMAP_TABLESPACE=OMS_LARGE_DATA:OMS_DATA
REMAP_TABLESPACE=OMS_INDEX:OMS_DATA
TABLE_EXISTS_ACTION=TRUNCATE
ESTIMATE=STATISTICS
EXCLUDE=TABLE_STATISTICS
EXCLUDE=INDEX_STATISTICS
EXCLUDE=GRANT
EXCLUDE=OBJECT_GRANT
EXCLUDE=CONSTRAINT
EXCLUDE=REF_CONSTRAINT
EXCLUDE=SEQUENCE
EXCLUDE=FUNCTION
EXCLUDE=PROCEDURE
EXCLUDE=PACKAGE
EXCLUDE=JOB
EXCLUDE=TRIGGER
EXCLUDE=TYPE
I just have dought that what REMAP_SCHEMA=ABC123:ABC does
does it fetches record from ABC123 and puts in ABC without any dump file ?? Or what else it is doing. I am too confuse
Please help.
Thanks in advance
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
