Home » RDBMS Server » Server Utilities » multiple export/import dump files (AIX, oracle 10.2.0.3.0)
multiple export/import dump files [message #504458] Mon, 25 April 2011 10:50 Go to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
I am trying to export/import of a schema who's size is around 60 GB.

Export parfile goes like this..
file=expdmp1.dmp, expdmp2.dmp, expdmp3.dmp, expdmp4.dmp, expdmp5.dmp, expdmp6.dmp, expdmp7.dmp
filesize=10240M
log=explog.log
owner=owner1

Import parfile goes like this..
file=impdmp1.dmp, impdmp2.dmp, impdmp3.dmp, impdmp4.dmp, impdmp5.dmp, impdmp6.dmp, impdmp7.dmp
filesize=10240M
log=implog.log
fromuser=owner1
touser=owner2
ignore=y

I am going to run this on production. So want to check it. Please let me know whether I have properly used the parameters.
Re: multiple export/import dump files [message #504460 is a reply to message #504458] Mon, 25 April 2011 11:08 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B14117_01/server.101/b10750/chapter1.htm#sthref251

"The Data Pump Export and Import utilities provide very high-speed bulk movement of data and metadata from database to another. These utilities offer several significant advantages over the original Export and Import utilities, including: the ability to completely restart export and import jobs; the ability to detach from and reattach to long-running jobs; the ability to estimate how much space an export job would consume; support for export and import operations over the network; and support for fine-grained object selection, based upon objects and objects types."
Re: multiple export/import dump files [message #504461 is a reply to message #504460] Mon, 25 April 2011 11:20 Go to previous message
lg123
Messages: 225
Registered: August 2008
Senior Member
I am in a situation where I can use only conventional export/import and not datapump.
Previous Topic: Data Pump
Next Topic: Validation steps
Goto Forum:
  


Current Time: Fri Mar 29 05:33:43 CDT 2024