Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Exporting no triggers?
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
![]() |
![]() |