Home » RDBMS Server » Server Utilities » oracle 10g Data pump (Oracle 10g)
oracle 10g Data pump [message #436522] Wed, 23 December 2009 23:31 Go to next message
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
Re: oracle 10g Data pump [message #436523 is a reply to message #436522] Wed, 23 December 2009 23:36 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
When all else fails, Read The Fine Manual

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_import.htm#sthref339

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: oracle 10g Data pump [message #436525 is a reply to message #436523] Wed, 23 December 2009 23:41 Go to previous message
Mohsin_Tm
Messages: 15
Registered: December 2009
Location: Pune
Junior Member
Thanks BlackSwan Smile
Previous Topic: Directory problem
Next Topic: How to create dbms_reputil package in the database?
Goto Forum:
  


Current Time: Wed Sep 28 07:31:04 CDT 2016

Total time taken to generate the page: 0.11937 seconds