Export Users

[jeyaseelan]

Hi Gurus,

How to take export/import user's information.I would like to create some users in a new database which are available in old database.

Thankx
Jeyaseelan.M

[hrishy]

Hi

Try this

exp system/manager parfile=params.dat


The params.dat file contains the following information:

FILE=expdat.dmp
TABLES=(scott.emp,blake.dept)
GRANTS=y
INDEXES=y

regards
Hrishy

then use the import utility.

[sambavan]

Since you want to do a logical move on the user schema, you would want to take a USER level export


exp system/passwd@servicename parfile=parms.dat


Where parms dat would contain:

FILE=user_export.dmp
OWNER=(scott, henry, peter,...)
GRANTS=Y
INDEXES=Y
DIRECT=Y
LOG=user_export.log



To import you would use

imp system/passwd@servicename parfile=parms.dat

where the parms.dat would contain


FILE=user_export.dmp
GRANTS=Y
ROWS=Y
FROMUSER=(scott,henry, peter, ...)
TOUSER=(scott, henry, peter, ...)
RECALCULATE_STATISTICS=Y
LOG=scott_imp.log


Note: On the case of the import, you would have to create the user and assign the tablespaces in advance, before the import


Sam

[jeyaseelan]

Thankx for your suggestion.But still my problem is not solved.

I want to create the users as it is in old database,Not tables.

I need to create a script using the following tables
dba_users
dba_sys_privs
dba_role_privs
dba_tab_privs

any other option is there?

Kindly suggest me

--
Jeyaseelan.M

[pipo]

create your own script.
what you need is to :
which roles and privs are granted to your user
which tab privs are granted to the user
which are his default and temporary tablespaces
which quotas he has on these tablespaces
which profile, password, etc ... your user has

you can generate a script which will then create your user and grant everything he needs ...