Home » Remote Recipes Reviews » Table Importation Fails with Error Code Ora-31693

Table Importation Fails with Error Code Ora-31693

Maya Lin-Takahashi • • 2 min read
Table Importation Fails with Error Code Ora-31693

I've been receiving backups from an Oracle database into my Oracle database for 2 years now. My company is running version 10.2.0.1.0 and we are receiving the exports from version 12.1.0.2.0. They are using expdp and I'm using impdp. I added a new column into my database, using this script 

ALTER TABLE CONTAINERS 
ADD ("SHELL" NUMBER(14, 6) DEFAULT 0 );

After running the above on both databases now when they send an export to me the table in question will not import. I receive the following error.

ORA-31693: Table data object "PAS"."CONTAINERS" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-02373: Error parsing insert statement for table "PAS"."CONTAINERS".
ORA-00904: "SYS_NC00067$": invalid identifier

This error has been going on for a about two weeks, I have tried to resolve the problem multiple ways, this is my last resort as it were.

Any help is greatly appreciated.

1 Answer

Did you try to track down SYS_NC00067? It looks like a system-assigned column name. This sometimes happens when you add a function-based index. Did you create a function-based index on Shell?

3

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Maya Lin-Takahashi
Author

Maya Lin-Takahashi

Maya is a hardware enthusiast who tests and reviews smart home devices, smartphones, wearables, and audio gear. She focuses on practical consumer value and build quality.