Oracle Error 1400 Import
error: ORACLE error 1400 encountered If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 17 Thread: Imp error: ORACLE error 1400 encountered Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 05-12-2010,12:26 PM #1 mahajanakhil198 View Profile View Forum Posts Senior Member Join Date Oct 2008 Location Chandigarh, India Posts 322 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 Reply With Quote 05-12-2010,12:29 PM #2 davey23uk View Profile View Forum Posts Senior Advisor Join Date Sep 2002 Location England Posts 7,334 the error is perfectly clear cannot insert NULL into ("QUARKDMS".
ago by user9104898 I am performing a schema level import and I am getting this error. From half an hour, this error is coming without any stoppage. could you please tell me how to ignore this error while performing the import? IMP-00019: row rejected due to ORACLE error 1400 IMP-00003: ORACLE error 1400 encountered ORA-01400: cannot insert NULL into ("LWARE_ADMIN"."SAMPLE_... Top contributing authors: Name Posts Rakesh jayappa 1 user's latest post: http://www.dbasupport.com/forums/showthread.php?61067-Imp-error-ORACLE-error-1400-encountered Import error: ORA-01400: cannot... Published (2010-09-21 03:16:00) Hi, Please refer this article ORA-1400 During Import of Export Dump Written in Direct Path Mode [ID 826746.1] Kind Regards, Rakesh jayappa rajeysh 1 user's latest post: Import error: ORA-01400: cannot... Published (2010-09-21 03:22:00) user9104898 wrote: I am performing a schema level import and I am getting this http://boardreader.com/thread/Import_error_ORA_01400_cannot_insert_NUL_lfa9Xo9ea.html error. From half an hour, this error is coming without any stoppage. could you please tell me how to ignore this error while performing the import? IMP-00019: row rejected due to ORACLE error 1400 IMP-00003: ORACLE error 1400 encountered ORA-01400: cannot insert NULL into ("LWARE_ADMIN"."SAMPLE_AUDIT_LOG"."COUNTER") The db version is... user9104898 1 user's latest post: Import error: ORA-01400: cannot... Published (2010-09-21 02:51:00) I am performing a schema level import and I am getting this error. From half an hour, this error is coming without any stoppage. could you please tell me how to ignore this error while performing the import? IMP-00019: row rejected due to ORACLE error 1400 IMP-00003: ORACLE error 1400 encountered ORA-01400: cannot insert NULL into ("LWARE_ADMIN"."SAMPLE_AUDIT_LOG"."COUNTER") The db version is 10.2.0.4 and the... Tippu 1 user's latest post: Import error: ORA-01400: cannot... Published (2010-09-21 03:01:00) Hi , Disable the constriant in the Source DB , then export for new dump. Import with new dump . Thanks, Tippu Serverprocess 1 us
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 http://www.solveerrors.com/forums/20/oracle/imp-error-oracle-error-1400-encountered-190548 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 oracle error 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 oracle error 1400 else can be done Posted On:Friday 19th of October 2012 04:30:42 AM Total Views: 121 View Complete with Replies Related Messages: ⇒ How to import records based on a condition ⇒ How do I calculate the impact/system requirements for when we increase load by 1/3rd? ⇒ Help in a simple procedure ⇒ Getting error in Oracle data pump import 10.1.0.3 ⇒ Exporting a table with indexes and importing ⇒ export/import question ⇒ export/import from windows to solaris ⇒ export/import ⇒ export/import ⇒ export import... ⇒ export import ⇒ export and import ⇒ exp8 imp9 ⇒ exp/imp of a partitioned table ⇒ exp/imp ⇒ exp 8/imp 9 ⇒ error while doing import ⇒ Disabling all checks during import? ⇒ datapump import errors, please help now, thanks ⇒ CREATE USER from within a trigger: get ORA-03001: unimplemented feature How to import records based on a condition  (18Views) Hi , One of my colleague is facing a problem like this: He's taking the export dump of a set of tables with all the record's in it. When he wants to do an import he want's to import only specific record's into the table's based on some condition. I gave him the following solution: 1. a. Create the structure of the table. b. Create some constraint temporarily on the conditional column. c. Import th