OraFAQ Forum: Server Utilities » Scripts for export and import

Home » RDBMS Server » Server Utilities » Scripts for export and import

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Scripts for export and import [message #229313]

Fri, 06 April 2007 10:45

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!

Report message to a moderator

Re: Scripts for export and import [message #229316 is a reply to message #229313]

Fri, 06 April 2007 10:47

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.

Report message to a moderator

Re: Scripts for export and import [message #229318 is a reply to message #229313]

Fri, 06 April 2007 10:51

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And there are many examples in the documentation.

Regards
Michel

Report message to a moderator

Re: Scripts for export and import [message #229319 is a reply to message #229316]

Fri, 06 April 2007 11:02

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!

Report message to a moderator

Re: Scripts for export and import [message #229320 is a reply to message #229319]

Fri, 06 April 2007 11:13

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!

Report message to a moderator

Re: Scripts for export and import [message #229321 is a reply to message #229320]

Fri, 06 April 2007 11:14

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 21:11:20 CST 2024