How to clone a schema using different name at destination
Recently I had to make a clone of a schema and to move it from production to development using a different name at destination. First grab all the information you need: select username,default_tablespace from dba_users where username like ‘&USERNAME’; # Now get the tablespace name from the previous statement and get the datafiles below: select…