Oracle Adventures

  • Home
  • About
  • Privacy Policy
  • About
  • Privacy Policy

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

10/11/2015mardaffImport&Exportclone, different, expdp, impdp
ora-base.com
Cleantalk Pixel