Search This Blog

Monday, January 16, 2012

schema refresh using conventional export/import (schemas and tablespaces are different)

In source database
exp system/password owner=ownername file=dumpfilename.dmp compress=n statistics=none consistent=y buffer=1024000 log=logfilename

transfer the dump file from source to destination

In the destination database,

create the structure of tablespace and schema

imp system/password fromuser= touser= file=dumpfile statistics=none buffer=1024000
log=logfilename ignore=y

No comments:

Post a Comment