Deleting orphaned data files after a tablespace import - Amazon Relational Database Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Deleting orphaned data files after a tablespace import

Use the rdsadmin.rdsadmin_transport_util.list_xtts_orphan_files procedure to delete data files that were orphaned after a tablespace import. Running this command generates a log file that uses the name format rds-xtts-delete_xtts_orphaned_files-YYYY-MM-DD.HH24-MI-SS.FF.log in the BDUMP directory. Use the procedure rdsadmin.rdsadmin_transport_util.cleanup_incomplete_xtts_import to find the orphaned files. You can read the log file by calling the procedure rdsadmin.rds_file_util.read_text_file. For more information, see Phase 6: Clean up leftover files.

Syntax

PROCEDURE cleanup_incomplete_xtts_import( p_directory_name IN VARCHAR2);

Parameters

Parameter name Data type Default Required Description

p_directory_name

VARCHAR2

Yes

The directory that contains the orphaned data files.

Examples

The following example deletes the orphaned data files in DATA_PUMP_DIR.

BEGIN rdsadmin.rdsadmin_transport_util.cleanup_incomplete_xtts_import('DATA_PUMP_DIR'); END; /

The following example reads the log file generated by the previous command.

SELECT * FROM TABLE(rdsadmin.rds_file_util.read_text_file( p_directory => 'BDUMP', p_filename => 'rds-xtts-delete_xtts_orphaned_files-2023-06-01.09-33-11.868894000.log')); TEXT -------------------------------------------------------------------------------- orphan transported datafile datafile_7.dbf deleted. orphan transported datafile datafile_8.dbf deleted.