Home » RDBMS Server » Server Utilities » Create batch file for import/export
Create batch file for import/export [message #355359] Thu, 23 October 2008 17:16 Go to next message
ruchimca
Messages: 2
Registered: April 2006
Location: India
Junior Member
Hi

I have following steps to be done in sequence

--------
schemaA
--------
exp parfile =exp_from_4r1.par (A.dmp)


-------
schemaB
-------
imp parfile=imp_from_4r1.par (using A.dmp)
@Refresh.sql
exp parfile=exp_conv_tables.par (B.dmp)

--------
schemaC
--------
take backup
@disable_constraints.sql
@delete_tables.sql
imp parfile=imp_conv_tables.par (using B.dmp)
@enable_constraints.sql

Is their a way all these can be executed as a batch file?

Regards
Re: Create batch file for import/export [message #355403 is a reply to message #355359] Thu, 23 October 2008 23:20 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, there is way, just write them in a batch file as you'd type it interactively.

Regards
Michel
Previous Topic: Max length error while using SQL*Loader
Next Topic: ORA 7445
Goto Forum:
  


Current Time: Sun Dec 04 22:44:40 CST 2016

Total time taken to generate the page: 0.12580 seconds