Home » RDBMS Server » Server Utilities » Scripts for export and import
Scripts for export and import [message #229313] Fri, 06 April 2007 10:45 Go to next message
syang
Messages: 30
Registered: February 2007
Member
Deal All,

Can someone share their import and export scripts with us? We are trying to automate the import and export process as a nightly process. Anyone has done so?

Thanks for your help!
Re: Scripts for export and import [message #229316 is a reply to message #229313] Fri, 06 April 2007 10:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
export/import scripts are one-liners.
All the wrapping depends on the OS you use, your customizations etc.
Post the relevant information.
Re: Scripts for export and import [message #229318 is a reply to message #229313] Fri, 06 April 2007 10:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

And there are many examples in the documentation.

Regards
Michel
Re: Scripts for export and import [message #229319 is a reply to message #229316] Fri, 06 April 2007 11:02 Go to previous messageGo to next message
syang
Messages: 30
Registered: February 2007
Member
Mahesh,

Sorry that I forgot the details...

Oracle 10g2R running on Sun Solaris.

UNIX>uname -a
SunOS **** 5.9 Generic_118558-30 sun4u sparc SUNW,Sun-Fire-V240

Thank you!
Re: Scripts for export and import [message #229320 is a reply to message #229319] Fri, 06 April 2007 11:13 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Still not answering the question.Smile
What exactly you want to do? Customizations?
export ORACLE_HOME=..
export PATH=$PATH:$ORACLE_HOME/bin
exp user/pass your export parameters

Save the above as a file, grant execute rights and that your script!
Re: Scripts for export and import [message #229321 is a reply to message #229320] Fri, 06 April 2007 11:14 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Again,
you can get any fancy with many more options.
It all depends on how you want to do it. But the core part dealing with exp/imp is just a single liner~
Like here

http://www.orafaq.com/scripts/unix/exportdb.txt

[Updated on: Fri, 06 April 2007 11:15]

Report message to a moderator

Previous Topic: Importing file with column header
Next Topic: QUERY about DB Solo 2.1
Goto Forum:
  


Current Time: Tue Dec 03 05:40:31 CST 2024