|July 24, 2008|
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
Feel free to leave a comment about this post.