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:\oracle\ora92\bin

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