OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Data Pump / Exp (Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Data Pump / Exp [message #544534]

Wed, 22 February 2012 05:38

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.

Report message to a moderator

Re: Data Pump / Exp [message #544535 is a reply to message #544534]

Wed, 22 February 2012 05:40

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

Probably not. What version of oracle are the DB's?

Report message to a moderator

Re: Data Pump / Exp [message #544536 is a reply to message #544535]

Wed, 22 February 2012 05:42

revshail
Messages: 4
Registered: February 2012

Junior Member

Hi,

It is 10g.

Thanks,
rs.

Report message to a moderator

Re: Data Pump / Exp [message #544541 is a reply to message #544536]

Wed, 22 February 2012 05:54

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

10g has datapump, always, it's part of the DB.

Report message to a moderator

Re: Data Pump / Exp [message #544542 is a reply to message #544536]

Wed, 22 February 2012 05:54

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If both are 10g then data pump exists in target one unless someone deleted it.

Regards
Michel

Report message to a moderator

Re: Data Pump / Exp [message #544545 is a reply to message #544542]

Wed, 22 February 2012 05:58

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.

Report message to a moderator

Re: Data Pump / Exp [message #544547 is a reply to message #544545]

Wed, 22 February 2012 06:01

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Data Pump / Exp [message #544548 is a reply to message #544547]

Wed, 22 February 2012 06:19

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

Report message to a moderator

Re: Data Pump / Exp [message #544549 is a reply to message #544548]

Wed, 22 February 2012 06:25

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 16:56:00 CST 2025