948024 wrote:No it won't create tablespace , You use remap option for your tablespace like the following :
thanks but it says
Here are the steps to do the * schema copy from one database to another*. You need to be admin user for performing some tasks.
also what about the tablespaces do i need to create them, there is a clause mentioned
how to use the above for multiple tablespaces
and if the tablespaces are not there will it create new?
if you don't want to use remap then you should create your tablespace .
948024 wrote:Generate Spool File like the following on Source :
Thanks alot guys
just one more thing what about user accounts im gettin invalid password errors for each user
what can be done to get the same passwords of them?
Spool User.sql Select ' Create ' || ' ' ||username || ' ' || 'identified by' || ' '|| password from dba_users ; Spool off ;