Home » RDBMS Server » Server Utilities » Oracle 8i 8.1.6 Export on Linux
Oracle 8i 8.1.6 Export on Linux [message #72306] Fri, 09 May 2003 05:14 Go to next message
Harshad Savot
Messages: 1
Registered: May 2003
Junior Member
hi,
I am trying to export 2 tables from a user like.

$exp user/password tables=tab1,tab2 triggers=no file=DMPFILE.DMP

When I am importing data in another user. Triggers also imported.
I am using Oracle 8.1.6 On Redhat Linux.

Harshad Savot
Re: Oracle 8i 8.1.6 Export on Linux [message #72308 is a reply to message #72306] Fri, 09 May 2003 06:15 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
trigger=n syntax is ACUTALLY NOT SUPPORTED IN 8.1.6.
But the documentation says so~.
There was a seperate note released by oracle, stating the errors in documentaion.

You can manually drop the triggers later after the import (in target).
else
disable all / selective trigger before the export (in source, just disable them dont drop them. so after the export is done, you can enable them. when u import now,the triggers wont be created in target.)

Previous Topic: ORA -26095
Next Topic: SQL*Loader not giving error but no data is inserted
Goto Forum:
  


Current Time: Tue Dec 24 06:40:02 CST 2024