Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: import user

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US