July 24, 2008

Oracle Import Example

The following is an example of duplicating an Orcle database from one schema to another schema. You may want to do this when you don't want to touch production DB during development.

This task is export the database contents of the SCHEMAA and importing them to SCHEMAB

exp and imp are Oracle command line Utilities. On some Oracle installations they are found in: D:oracleora92bin

MYDATABASE is a DBA:

## - Export SCHEMAA Data:
exp MYDATABASE/MYDATABASE@o6 file=schemaa.dmp log=schemaa.log rows=yes indexes=no OWNER=SCHEMAA

## - Import SCHEMAA to SCHEMAB
imp MYDATABASE/MYDATABASE@o6 FROMUSER=SCHEMAA TOUSER=SCHEMAB  file=schemaa.dmp

Comments

Add your Comments

Feel free to leave a comment about this post.

- Feel Free to add HTML to your comment!