Re: import user

In article <8ogldc$f6b$1_at_nnrp1.deja.com>,   rock_cogar_at_my-deja.com wrote:
> Import does not create users, grants or tablespaces.
>

It most certainly does create users, grants and 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.
> >

The most likely cause of this error is a grant to a user account not yet created. As a table is imported the table is created (unless the table already exists and 'ignore=y' is specified on the command line to imp), the data loaded, the indexes created (again if they do not already exist), triggers created and grants executed. It is very likely that the user or users giving errors have yet to be created by imp and grants to tables are being executed for these 'missing' users. After the import is complete it is a simple task to re-run the import with all of the parameters set to 'N' except for grants:

imp <user/pass> file=... full=y rows=n indexes=n ignore=y grants=y

This will establish the grants that 'missed' the first time due to the user having not yet been created.

> > 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.
>

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.