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