EXP help?- resume and incrementally ? [message #303679] |
Sat, 01 March 2008 23:08 |
oraclewannabe
Messages: 26 Registered: January 2008
|
Junior Member |
|
|
Hi i am doing an exp as an user from a 10g database recently.
I have encounter difficulty doing an export as it usually stop responding after exporting a large table in the schema , i am not sure whether is it my COMPANY VPN's fault or something to do with the RDBMS. I have to do a reconnect to the company VPN, before the network flows again.
So several thoughts has pop up while i was exporting the database
Q1) can i use a 9i exp to export a 10g database ?
Q2) is there such thing as resume for exporting, for e.g if i stop or hang at this particular point, the next time i do a exp on the same schema again, it will resume at where i stop
Q3) can someone explain to me what is inctype? can i use it for Q2 ?
THANKS YOU GUYS. any help deeply appreciated.
|
|
|
|
Re: EXP help?- resume and incrementally ? [message #303681 is a reply to message #303679] |
Sat, 01 March 2008 23:21 |
Mohammad Taj
Messages: 2412 Registered: September 2006 Location: Dubai, UAE
|
Senior Member |
|
|
You should use "DATAPUMP" expdp/impdp utiliity.
1. It is faster
...is there such thing as resume for exporting, for e.g if i stop or hang at this particular point, the next time i do a exp on the same schema again, it will resume at where i stop...
you can do it with EXPDP DATAPUMP utility.
|
|
|