Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Export question.
On Mon, 30 Mar 1998 00:29:08 GMT, peter.schneider_at_okay.net (Peter Schneider) wrote:
>On Sun, 29 Mar 1998 16:17:49 -0600, hpdba <hpdba_at_yahoo.com> wrote:
[...]
>>If I perform the export, drop table, and import as planned will the
>>integrity constraint in table-B be lost because I dropped table-A during
>>the process? If so, will the constraint in table-B be restored when I do
>>the import for table-A?
>>
>>I have not found much discussion on this in the DBA admin books I have.
>>
>>Thanks in advance.
>
[...]
>recompilation later on. Furthermore you should plan on how to restore
>grants after reimporting.
Please ignore my statement about restoring grants. That's nonsense, I wasn't awake. Of course, the proper grants are included in the export file, and thus restored automatically on importing.
Sorry,
Peter
-- Peter Schneider peter.schneider_at_okay.netReceived on Mon Mar 30 1998 - 00:00:00 CST