Re: Import Question

On Sep 24, 3:05 am, DA Morgan <damor..._at_psoug.org> wrote:
> ame..._at_iwc.net wrote:
> > Hi All,
>
> > How many database imports have you done? Well, once in a while you
> > forget some things and need some reminders.
>
> > First, if you do a full database export, and then import into another
> > database, do the users have to pre-exist?
>
> And the permissions must be granted.
>
> > Second, is Oracle smart enough to import things in an order that will
> > not produce errors?
>
> Depends on the version

Really? And in which version of Oracle did import enable constraints so early on in the piece that a whole heap of constraint violations would be produced?

The actual answer is, of course, that import has, since at least version 7, always enabled constraints at the end of the table-loading process, thereby making the order of table creation and loading irrelevant. Received on Mon Sep 24 2007 - 20:48:09 CDT