On the source machine: Set the tablespace(s) into read only mode SQL> Alter tablespace <tablespace> read only Export the tablespace meta data using export % expdp system/<password> DUMPFILE=expdat.dmp DIRECTORY = dpump_dir TRANSPORT_TABLESPACES = <list of tablespaces separated by commas> TRANSPORT_FULL_CHECK=Y If the dumpdir is not set up, you will get an ‘invalid’ directory error: SQL> [...]
How to: How to copy an Oracle tablespace across platforms – quick and dirty ;-)
by Jason L Froebe on April 5, 2010, no comments
