OraFAQ Forum: Server Utilities » Export without triggers (v8.0.6)

Home » RDBMS Server » Server Utilities » Export without triggers (v8.0.6)

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

Export without triggers (v8.0.6) [message #72016]

Sun, 23 February 2003 23:22

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.

Report message to a moderator

Re: Export without triggers (v8.0.6) [message #72018 is a reply to message #72016]

Mon, 24 February 2003 05:45

Mahesh Rajendran
Messages: 10707
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 16:09:09 CDT 2024