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
|
|
|
|
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?
|
|
|
|
|
|
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.
|
|
|