Re: import user

From: <rock_cogar_at_my-deja.com>
Date: Tue, 29 Aug 2000 15:38:23 GMT
Message-ID: <8ogldc$f6b$1@nnrp1.deja.com>

Import does not create users, grants or tablespaces.

I would suggest that you use the data dictionary views (connect as "system") dba_users, dba_sys_privs, dba_tablespaces to create the scripts to create the required users, grants and tablespaces. Next, I suggest that you import your data to the new instance on a schema by schema basis (rather than FULL DB).

HTH.
Rock.

In article <8ogg0m$694$1_at_SOLAIR2.EUnet.yu>, "Rexx" <nebacar_at_eunet.yu> wrote:
> Hi,
>
> db is Oracle 7.3
> I did full DB export and I try full DB import on other new Oracle
db.
> If I didn't previously create same users on new DB when I try full
import I
> got error that user not exist.
>
> Can I from export/import create users in new db?
> Where can I found script for easy create users same as users in old
db.
>
> Thanks!
>
> --
>
> *****************************************
> Remove nospam from address
> My address: nebacar_at_eunet.yu
> ******************************************
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Aug 29 2000 - 10:38:23 CDT