Home » RDBMS Server » Server Utilities » Export without triggers (v8.0.6)
Export without triggers (v8.0.6) [message #72016] Sun, 23 February 2003 23:22 Go to next message
Jeffrey Roffe
Messages: 1
Registered: February 2003
Junior Member
Hi All,

Is it possible to export tables with exporting their trigger(s) in v8.0.6 ??

If so, how ??

There is an option in 8.1.7 but I don't seem to be able to find one in 8.0.6.
Re: Export without triggers (v8.0.6) [message #72018 is a reply to message #72016] Mon, 24 February 2003 05:45 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you can write a small script that will disable all the triggers.
do the export
import it whereever you want.
enable all the triggers in source database.

[Updated on: Fri, 17 March 2006 08:04]

Report message to a moderator

Previous Topic: dbca java exception 9i/er2 solaris
Next Topic: Re: Field in data file exceeds maximum length
Goto Forum:
  


Current Time: Tue Dec 24 08:07:53 CST 2024