Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export/Import Data Only
You can export CONSTRAINTS=N, GRANTS=N.
You can import INDEXES=N, GRANTS=N, IGNORE=Y
If the export contains CONSTRAINTS, then your import will always import them.
If the export contains TRIGGERS, then your import will always import them. There is no way to export without TRIGGERS.
Don Mark wrote in message <35200BBE.1927_at_telis.org>...
>What is the SQL syntax to 1) export and 2) import just the **data** of a
>table?
>
>Thanks, Don
Received on Thu Apr 02 1998 - 00:00:00 CST