Database Reference
In-Depth Information
If you don't have any violations, you should see this:
no rows selected
If you do have violations, such as an index that is built on a table that exists in a tablespace not being transported,
then you'll have to rebuild the index in a tablespace that is being transported.
2.
Make the tablespaces being transported read-only:
SQL> alter tablespace inv_data read only;
SQL> alter tablespace inv_index read only;
3.
Use Data Pump to export the metadata for the tablespaces being transported:
$ expdp mv_maint/foo directory=dp_dir dumpfile=trans.dmp \
transport_tablespaces=INV_DATA,INV_INDEX
4.
Copy the Data Pump export dump file to the destination server.
5.
Copy the data file(s) to the destination database. Place the files in the directory where
you want them in the destination database server. The file name and directory path must
match the import command used in the next step.
6.
Import the metadata into the destination database. Use the following parameter file to
import the metadata for the data files being transported:
userid=mv_maint/foo
directory=dp_dir
dumpfile=trans.dmp
transport_datafiles=/ora01/dbfile/rcat/inv_data01.dbf,
/ora01/dbfile/rcat/inv_index01.dbf
If everything goes well, you should see some output indicating success:
Job "MV_MAINT"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed...
If the data files that are being transported have a block size different from that of the destination database, then
you must modify your initialization file (or use an
ALTER SYSTEM
command) and add a buffer pool that contains the
block size of the source database. For example, to add a 16KB buffer cache, place this in the initialization file:
db_16k_cache_size=200M
You can check a tablespace's block size via this query:
SQL> select tablespace_name, block_size from dba_tablespaces;
The transportable tablespace mechanism allows you to quickly move data files between databases, even if
the databases use different block sizes or have different endian formats. This section doesn't discuss all the details
involved with transportable tablespaces; the focus of this chapter is to show how to use Data Pump to transport data.
See the
Oracle Database Administrator's Guide
, which can be freely downloaded from the Technology Network area of
