Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Exporting no triggers?

Exporting no triggers?

From: AleX <korrozia_at_my-deja.com>
Date: Sat, 11 Sep 1999 19:43:02 GMT
Message-ID: <7rebc5$jmt$1@nnrp1.deja.com>

Hi all,

is it possible to export just the tables from one's schema with the rows but without the triggers defined for these tables? I've got this parfile which would imply that only the table data would end up in the export dump. Yet when I run import on it, it tries to create the triggers.

FILE=export1.dmp
COMPRESS=N
INDEXES=N
GRANTS=N
ROWS=Y
CONSTRAINTS=N
DIRECT=Y
tables=(table1
, table_TYPES)

Thanx!

--

                 Alex Shterenberg


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Sep 11 1999 - 14:43:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US