Database Administration (MOSC)

MOSC Banner

impdp ORA-01449: column contains NULL values; cannot alter to NOT NULL

edited Jul 12, 2017 9:02AM in Database Administration (MOSC) 5 commentsAnswered ✓

Hello,

I have strange problem.

I'm importing schema by impdp statament, and following error occurs:

ORA-39083: Object type CONSTRAINT:"SCHEMA"."PK_TABLE" failed to create with error:

ORA-01449: column contains NULL values; cannot alter to NOT NULL

but this table does not contains any nulls in column which are included into PK...

any idea why it happen?


Thanks.

Best regards,

Mateusz

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