Oracle Database Schema Clone


If the user is using Oracle as the meta data repository, then follow these instructions:


  1. Login as oracle OS level user to Source instance.
  2. Use the exp utility and follow the screen to take the backup of xxsplash schema.


.


  1. Copy the xxsplash.dmp file to target instance.
  2. Login as Oracle OS level user to target instance.
  3. To restore the xxsplash database schema oracle database should be installed with xxsplash database user.
  4. Use imp utility to restore the database and follow the screen.