Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: import user
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
![]() |
![]() |