Importing transportable tablespace metadata into your DB instance
Use the procedure rdsadmin.rdsadmin_transport_util.import_xtts_metadata
to
import transportable tablespace metadata into your RDS for Oracle DB instance. During the operation, the
status of the metadata import is shown in the table
rdsadmin.rds_xtts_operation_info
. For more information, see Step 5: Import
tablespace metadata on your target DB instance.
Syntax
PROCEDURE import_xtts_metadata( p_datapump_metadata_file IN SYS.DBA_DATA_FILES.FILE_NAME%TYPE, p_directory_name IN VARCHAR2, p_exclude_stats IN BOOLEAN DEFAULT FALSE, p_remap_tablespace_list IN CLOB DEFAULT NULL, p_remap_user_list IN CLOB DEFAULT NULL);
Parameters
Parameter name | Data type | Default | Required | Description |
---|---|---|---|---|
|
|
— |
Yes |
The name of the Oracle Data Pump file that contains the metadata for your transportable tablespaces. |
|
|
— |
Yes |
The directory that contains the Data Pump file. |
|
|
|
No |
Flag that indicates whether to exclude statistics. |
|
|
NULL |
No |
A list of tablespaces to be remapped during the metadata import.
Use the format
|
|
|
NULL |
No |
A list of user schemas to be remapped during the metadata import.
Use the format
|
Examples
The example imports the tablespace metadata from the file
xttdump.dmp
, which is located in directory
DATA_PUMP_DIR
.
BEGIN rdsadmin.rdsadmin_transport_util.import_xtts_metadata('
xttdump.dmp
','DATA_PUMP_DIR
'); END; /