OraFAQ Forum: Server Utilities » IMPDP oracle8 dmp

Home » RDBMS Server » Server Utilities » IMPDP oracle8 dmp (AIX 10G)

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

IMPDP oracle8 dmp [message #334394]

Wed, 16 July 2008 06:34

lioracle
Messages: 68
Registered: February 2008
Location: Israel

Member

hello
i have dmp file from oracle8
i want to import it to oracle 10

can i do it with impdp?

thanks

Report message to a moderator

Re: IMPDP oracle8 dmp [message #334398 is a reply to message #334394]

Wed, 16 July 2008 06:38

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No, you have to do it with imp.

Regards
Michel

Report message to a moderator

Re: IMPDP oracle8 dmp [message #334401 is a reply to message #334394]

Wed, 16 July 2008 06:40

lioracle
Messages: 68
Registered: February 2008
Location: Israel

Member

thanks but i dont know what do to

the imp stuck and work slowly

the system is new with 5 giga SGA 10G

i run analyze=n ignore=y indexes=n
but its stuck

why?

Report message to a moderator

Re: IMPDP oracle8 dmp [message #334407 is a reply to message #334401]

Wed, 16 July 2008 06:59

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Stuck? Maybe it is just working, doesn't it?

Regards
Michel

Report message to a moderator

Re: IMPDP oracle8 dmp [message #334408 is a reply to message #334394]

Wed, 16 July 2008 07:02

lioracle
Messages: 68
Registered: February 2008
Location: Israel

Member

this is 10 giga of dmp file
its start 2 tables
and in the logfile - i see nothing the filesize = oK (zero)

Report message to a moderator

Re: IMPDP oracle8 dmp [message #334411 is a reply to message #334408]

Wed, 16 July 2008 07:06

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Use feedback option, you can then see it working.
Depending on your OS, file size may not change until file is closed.

Regards
Michel

Report message to a moderator

Re: IMPDP oracle8 dmp [message #334435 is a reply to message #334394]

Wed, 16 July 2008 08:11

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Also note that if the table has a LONG column, the import will be painfully slow. I had a database import that took 6 hours and 95% of the time was on a single table with a LONG column. And that table was well less than 1% of the entire database.

Report message to a moderator

Previous Topic:	SELECT INTO OUTFILE ERROR
Next Topic:	Taking a backup in batches

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 11 10:30:55 CDT 2024