Home » RDBMS Server » Server Utilities » Data Pump / Exp (Windows)
Data Pump / Exp [message #544534] Wed, 22 February 2012 05:38 Go to next message
revshail
Messages: 4
Registered: February 2012
Junior Member
Hi,

I have a requirement to copy a schema from one db to another. The source db has data pump installed but the target db does not have a data pump. I tried to take a normal export of the source database but it is much time consuming. Is there any other easier way to have the data copy done ?


Thanks,
rs.
Re: Data Pump / Exp [message #544535 is a reply to message #544534] Wed, 22 February 2012 05:40 Go to previous messageGo to next message
cookiemonster
Messages: 13663
Registered: September 2008
Location: Rainy Manchester
Senior Member
Probably not. What version of oracle are the DB's?
Re: Data Pump / Exp [message #544536 is a reply to message #544535] Wed, 22 February 2012 05:42 Go to previous messageGo to next message
revshail
Messages: 4
Registered: February 2012
Junior Member
Hi,

It is 10g.

Thanks,
rs.
Re: Data Pump / Exp [message #544541 is a reply to message #544536] Wed, 22 February 2012 05:54 Go to previous messageGo to next message
cookiemonster
Messages: 13663
Registered: September 2008
Location: Rainy Manchester
Senior Member
10g has datapump, always, it's part of the DB.
Re: Data Pump / Exp [message #544542 is a reply to message #544536] Wed, 22 February 2012 05:54 Go to previous messageGo to next message
Michel Cadot
Messages: 66562
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If both are 10g then data pump exists in target one unless someone deleted it.

Regards
Michel
Re: Data Pump / Exp [message #544545 is a reply to message #544542] Wed, 22 February 2012 05:58 Go to previous messageGo to next message
revshail
Messages: 4
Registered: February 2012
Junior Member
I tried to do an IMPDP but then the command prompt just exited without giving any errors. This happened 2-3 times. Then i checked with the DBA and was told that data pump instalation ran into some errors and so it was not done.
Re: Data Pump / Exp [message #544547 is a reply to message #544545] Wed, 22 February 2012 06:01 Go to previous messageGo to next message
Michel Cadot
Messages: 66562
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

SHOW US!

Use DOS box, post result of "SET", copy and paste it here in text mode (no image, no attached file).

Regards
Michel
Re: Data Pump / Exp [message #544548 is a reply to message #544547] Wed, 22 February 2012 06:19 Go to previous messageGo to next message
revshail
Messages: 4
Registered: February 2012
Junior Member
I tried an expdp from the target database - the expdp hung. So I gave a ctrl +c and this is the error message that I got :

UDE-00008: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2745
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3712
ORA-06512: at line 1
Re: Data Pump / Exp [message #544549 is a reply to message #544548] Wed, 22 February 2012 06:25 Go to previous message
Michel Cadot
Messages: 66562
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Wed, 22 February 2012 13:01
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

SHOW US!

Use DOS box, post result of "SET", copy and paste it [and the whole DOS session] here in text mode (no image, no attached file).

Regards
Michel

Previous Topic: Privs on logical backup
Next Topic: Version of exp and imp utilities
Goto Forum:
  


Current Time: Sat Sep 21 12:24:38 CDT 2019