Home » RDBMS Server » Server Utilities » Export without triggers for Oracle 8.1.6
Export without triggers for Oracle 8.1.6 [message #70591] Wed, 03 July 2002 22:00 Go to next message
Laert
Messages: 20
Registered: January 2000
Junior Member
Hi,
I'm using Oracle 8i v 8.1.6 Enterprise edition on Windows 2000 AS.
I'm trying to export some table from database without triggers, but unsuccessful.
The command string is following:

EXP SCOTT/TIGER TRIGGERS=N TABLES=(EMP)

Is there any ideas how I can solve this problem.

Thanx in advance
Laert
Re: Export without triggers for Oracle 8.1.6 [message #70592 is a reply to message #70591] Thu, 04 July 2002 02:14 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Actually TRIGGERS=N is available only from 8.1.7.
This functionality is not present in the 8.1.5 and 8.1.6 versions.
There is a documentation error for the 8.1.5 version of the database Export
utility.
So, if you are still looking for solution for the same,
There is a workaround available.
let me know, I can mail you that.
Regards
Previous Topic: How to load a text file into table?
Next Topic: Database Configuration Assistant
Goto Forum:
  


Current Time: Tue May 07 21:40:47 CDT 2024