Another Oracle blog

  • Home
  • About
  • About

Tag Archives: different

Home / Posts Tagged: different

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…

Read More

November 10, 2015mardaffImport&Exportclone, different, expdp, impdp
ora-base.com