Transportable Tablespaces Feature - Oracle 8i

The transportable tablespace feature enables you to move a set of tablespaces from one Oracle database to another.

To do this, you must make the tablespaces read-only, copy the datafiles of these tablespaces, and use Export/Import to move the database information (metadata) stored in the data dictionary. Both the datafiles and the metadata export file must be copied to the target database. The transport of these files can be done using any facility for copying flat, binary files, such as the operating system copying facility, binary-mode FTP, or publishing on CD-ROMs.

After copying the datafiles and importing the metadata, you can optionally put the tablespaces in read/write mode.

Import provides the following parameter keywords to enable import of transportable tablespaces metadata.

  • TRANSPORT_TABLESPACE
  • TABLESPACES
  • DATAFILES
  • TTS_OWNERS

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Oracle 8i Topics