Powered By Blogger

Wednesday, January 26, 2011

Transport Tablespace Reference

For Oracle transport tablespace refer this:

1. Make the tablespace read only.
2.export tablespace using TRANSPORT_TABLESPACE option
3. copy the datafile to the destination database server.
4.transfer the dumpfile to the destination server.
5. import tablespace using TRANSPORT_TABLESPACE option.
6. Make the tablespace read write

Eg:
Transport Tablespace:
exp TRANSPORT_TABLESPACE=y TABLESPACES=(history) FILE=/disk2/backup/hs.dmp

No comments:

Post a Comment