Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: import user
<rock_cogar_at_my-deja.com> wrote in message
news:8ogldc$f6b$1_at_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.
>
That's odd, because if you open a full database export dump file in the text editor of your choice, you will discover that the first lines contain statements such as "Create tablespace X....", followed rapidly by "Create User xxx" statements, and rounded off by a bunch of 'grant privilege to user' statements.
Plus, I just did an entire database export, dropped a user with cascade option, and then did a full import (with ignore=Y), and Lo! The dropped User is back, together with his objects.
I think the thing is that import *Does* create Users, grants and tablespaces provided that your prior export was done in 'full database' mode.
Regards
HJR
> 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 Sat Sep 02 2000 - 03:14:49 CDT