copy - Copying ALL tables from one user to another Oracle11g -

i have user name user1 password user1 want create user 2 identified user 2 , copy tables data user 1 user 2.

can copy tables @ once, or need copy table table new user? how can that?

you can use datapump. first of all, create directory object maps directory in file system:

create or replace directory dir_temp 'c:\temp';

then export schema (associated user1) in dump file:

c:\app\...\dbhome_1\bin\expdp.exe system/pwd schemas=user_1 directory=dir_temp dumpfile=file.dmp logfile=file_exp.log

and re-import dump file:

c:\app\...\dbhome_1\bin\impdp.exe system/pwd remap_schema=user_1:user_2 directory=dir_temp dumpfile=file.dmp logfile=file_imp.log

KBPS