Wednesday, May 13, 2009

Quick and Easy ways to copy Oracle Schema method 1

exp/imp can be used to export/import data to or from schema

the syntax is 
to export:
$exp username/password inctype=[complete||incremental] file=file.dmp

to import:
imp username/password inctype= RECTORE FULL=Y FILE=file.dmp

please note. to import, you need to create enough room for rollback.

next time, I will take about to use new tool called datapump to export/import schema. data pump only available for oracle 10+.

1 comment:

Anonymous said...

thanks