Database Utilities (MOSC)

MOSC Banner

IMPDP error ORA-31693 ORA-01403

edited May 16, 2018 5:01AM in Database Utilities (MOSC) 7 commentsAnswered

Hi all,

I do export from my database with the command EXPDP without any problem and error, every three hours.

I also do import on a second database with these different export files, several times per day, to prepare a disaster plan.

But strangely, sometimes, the import doesn't work well, returning errors, each time on the same TABLE:

ORA-31693: Echec du chargement/déchargement de l'objet de données de table "SYSADM"."REQCONTROLE" ; l'objet est ignoré en raison de l'erreur :

ORA-01403: aucune donnée trouvée

ORA-01403: aucune donnée trouvée

No data found ???

On the source database, this table seems to contain some records, even if in the export, it's indicated there is only one line:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center