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.net