| IMPDP ERROR ORA-31693: on ORACLE VIRTUAL COLUMN with Not null [message #588137] |
Fri, 21 June 2013 04:42  |
 |
arulsaran
Messages: 26
Registered: May 2013
Location: bangalore
|
Junior Member |
|
|
Hi Team,
I am having issue with IMPDP on ORACLE VIRTUAL COLUMNS.
I am having following table with Virtual column defined with Not null. Expdp is fine without any issue.
DDL :
------
CREATE TABLE alert_hist
(
alertky INTEGER NOT NULL,
alertcreatedttm TIMESTAMP(6) DEFAULT systimestamp NOT NULL,
alertcreatedt DATE GENERATED ALWAYS AS (To_date(Trunc("alertcreatedttm"))) VIRTUAL NOT NULL
)
/
When I do the import (IMPDP) it got failed with the following error.
. . imported "TESTSCHEMA"."VALART" 359.1 KB 4536 rows
ORA-31693: Table data object "TESTSCHEMA"."ALERT_HIST" failed to load/unload and is being skipped due to error:
ORA-39097: Data Pump job encountered unexpected error -1
After that I dropped the Virtual Not null column and recreated that column with Nullable.
DDL :
-----
alter table alert_hist drop column alertcreatedt;
alter table alert_hist add alertcreatedt DATE GENERATED ALWAYS AS (To_date(Trunc("alertcreatedttm"))) VIRTUAL;
After that I took the expdp and impdp , it went fine with out any issue.
Need help on this , why the import is failing with the virtual not null columns.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
