By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Oracle datapump import error - AWS RDS for Oracle SE2 with S3 integration

0

Hi, I am trying to import the Oracle data dump file using S3 integration. We received the Dump file via SFTP from other customer and I could successfully copy it to DATA_PUMP_DIR, but when I try to import it using DBMS_DATAPUMP operation, I am getting the below error saying ORA-31694 : XXXX table "DBNAME.SYS_IMPORT_SCHEMA_02" failed to load/unload, ORA-02369: internal number in header in file <**.dmp> is not valid. did anyone face this issue before? if yes, can you plz provide some insights? I want to rule out RDS side of issues before asking the customer to check the file on their side

Topics
Migration & ModernizationStorageAnalyticsDatabase
Tags
Migration & ModernizationAmazon Simple Storage ServiceAmazon Relational Database ServiceOracle
Language
English
rbodap
asked 3 years ago571 views
1 Answer
1

I do not think its a RDS issue. Below are the possible reasons for this error:

  1. The transfer of the dump files from source environment to target environment has been interrupted.
  2. The dump file are truncated by disk space of file system size limitations.
  3. The export job has not been completed successfully.
AWS
D-Rao
answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content