Home » RDBMS Server » Server Utilities » IMPDP oracle8 dmp (AIX 10G)
IMPDP oracle8 dmp [message #334394] Wed, 16 July 2008 06:34 Go to next message
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
Re: IMPDP oracle8 dmp [message #334398 is a reply to message #334394] Wed, 16 July 2008 06:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, you have to do it with imp.

Regards
Michel
Re: IMPDP oracle8 dmp [message #334401 is a reply to message #334394] Wed, 16 July 2008 06:40 Go to previous messageGo to next message
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?

Re: IMPDP oracle8 dmp [message #334407 is a reply to message #334401] Wed, 16 July 2008 06:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Stuck? Maybe it is just working, doesn't it?

Regards
Michel
Re: IMPDP oracle8 dmp [message #334408 is a reply to message #334394] Wed, 16 July 2008 07:02 Go to previous messageGo to next message
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)



Re: IMPDP oracle8 dmp [message #334411 is a reply to message #334408] Wed, 16 July 2008 07:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: IMPDP oracle8 dmp [message #334435 is a reply to message #334394] Wed, 16 July 2008 08:11 Go to previous message
joy_division
Messages: 4640
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.
Previous Topic: SELECT INTO OUTFILE ERROR
Next Topic: Taking a backup in batches
Goto Forum:
  


Current Time: Sun Dec 04 06:41:02 CST 2016

Total time taken to generate the page: 0.05039 seconds