Re: Import Question

amerar_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

> So, if User#2 must have their objects imported
> before User #1 because of some constraints or something, will Oracle
> do that???
>
> We are exporting an 8.1.7.4 database into a 10g database.......

What is preventing you from running a test and finding out?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org