Imp error: ORACLE error 1400 encountered
I am facing the following error repeatedly while doing import using imp:
. . importing table "MAM_ASSETS"
IMP-00019: row rejected due to ORACLE error 1400
IMP-00003: ORACLE error 1400 encountered
ORA-01400: cannot insert NULL into ("QUARKDMS"."MAM_ASSETS"."INDEX_SOURCE")
Column 1 413212
Column 2 65678
Column 3 65780
Column 4 21
Column 5
Column 6 2
Column 7 0
Column 8 1
Column 9 1
Column 10 1
Column 11 0
Column 12 412553
Column 13 4
Column 14
Column 15 7 5 E 20 19
Column 16 7 5 e 20 19
Column 17
Column 18
Column 19 25902
Column 20 2
Column 21 30-AUG-2002:13:26:54
Column 22
Column 23 30-AUG-2002:13:26:54
Column 24
Column 25 10-SEP-2002:10:14:13
Column 26 JPEG
Column 27 14-OCT-2005:14:49:58
Column 28 jpeg
Column 29 8BIM
Column 30
Column 31 8bim
Column 32 65780
Column 33 65715
Column 34 65874
Column 35 65617
Column 36 005400010108000000010000000100000009158700000A3C00...
Column 37
Column 38 14-OCT-2005:14:49:58
Column 39 1
Column 40 65874
Column 41 02-SEP-2002:13:28:51
Column 42
Column 43
Column 44 005400010208000000010000000100000025B2330008AA8200...
Column 45 US
IMP-00019: row rejected due to ORACLE error 1400
I searched google, it's of no help in my case. I also disabled constraints import. Though constraints get enabled after importing rows, still I cleared my doubt. What else can be done?
lucky
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width
Bookmarks