Oracle Import Example

July 24, 2008 by cryan.com

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