Home » RDBMS Server » Server Utilities » does oracle 8 support export to multiple files ?
does oracle 8 support export to multiple files ? [message #142558] Sat, 15 October 2005 16:08 Go to next message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member
Guys,

I need to know if Oracle 8 support writitng to multiple files using export utility (exp command) ?

I used the following exp command on a oracle 8 database. I am getting syntax error.

exp scott/tiger FILE = exp1.dmp, exp2.dmp exp3.dmp TABLES=scott.table1 FILESIZE= 2048 LOG=-exp.log

I am getting syntax error.

Please help.

Thanks
Ravi
Re: does oracle 8 support export to multiple files ? [message #142562 is a reply to message #142558] Sat, 15 October 2005 17:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.orafaq.com/faq/import_export
Re: does oracle 8 support export to multiple files ? [message #142795 is a reply to message #142558] Mon, 17 October 2005 13:43 Go to previous message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member
Thanks so much Mahesh. Your answer really helped me to take an export on earlier version of Oracle.

Regards
Ravi
Previous Topic: Loader question
Next Topic: Query Result to a Text File
Goto Forum:
  


Current Time: Mon Jul 01 12:59:36 CDT 2024