Usando AWS re:Post, accetti AWS re:Post Termini di utilizzo
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

Argomenti
Migrazione e modernizzazioneArchiviazioneAnalisiDatabase
Tag
Migrazione e modernizzazioneServizio di archiviazione semplice di AmazonAmazon Relational Database ServiceOracle
Lingua
English
rbodap
posta 2 anni fa436 visualizzazioni
1 Risposta
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
con risposta 2 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande

Contenuto pertinente