Home » RDBMS Server » Server Utilities » import fails
import fails [message #268409] Tue, 18 September 2007 08:26 Go to next message
risy_s
Messages: 44
Registered: September 2005
Location: Mumbai
Member

hi this is the part of import log could u plz tell me what does it mean
and how do i resolve this to import data

IMP-00017: following statement failed with ORACLE error 20000:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(); SREC.BKVALS := DBMS_STATS.NUMARRAY(); SREC.EPC := 0; DBMS_STATS.SET_"
"COLUMN_STATS(NULL,'"DCPM"','"COMM_AMOUNT_30"', NULL ,NULL,NULL,0,0,0,srec,0"
",0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: Unable to set values for column COMM_AMOUNT_30: does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 3365
ORA-06512: at "SYS.DBMS_STATS", line 3523
ORA-06512: at line 1


Re: import fails [message #268411 is a reply to message #268409] Tue, 18 September 2007 08:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You could:
1/ read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
2/ post your Oracle version (4 decimals).
3/ Post in the appropiate forum that is Server Utilities

Now, it seems your import user does not have the rights to recalculate the statistics for the objects it imports. Try "statistics=none"

Regards
Michel
Re: import fails [message #268416 is a reply to message #268411] Tue, 18 September 2007 08:47 Go to previous messageGo to next message
risy_s
Messages: 44
Registered: September 2005
Location: Mumbai
Member

if i m using statistics=none these erros are comming

IMP-00017: following statement failed with ORACLE error 942:
"BEGIN SYS.DBMS_SNAPSHOT_UTL.SYNC_UP_LOG('FNSONLP','FXDT'); END;"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 1589
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 942:
"BEGIN SYS.DBMS_SNAPSHOT_UTL.SYNC_UP_LOG('FNSONLP','NOPV'); END;"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 1589
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 942:
"CREATE SNAPSHOT LOG ON "FNSONLP"."FXDT" WITH ROWID USING ("MLOG$_FXDT", (3,"
" 'P012BAND', 33, '2007-08-30:09:00:01', '4000-01-01:00:00:00', '2006-09-23:"
"14:51:14', 0, 2, 1, '2006-10-20:06:01:50', 3, '2007-08-30:09:00:01'))"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
"CREATE SNAPSHOT LOG ON "FNSONLP"."NOPV" WITH ROWID USING ("MLOG$_NOPV", (3,"
" 'P012BAND', 33, '2007-08-30:09:50:21', '4000-01-01:00:00:00', '2007-04-28:"
"12:46:45', 0, 1, 5, '2007-08-30:09:50:21'))"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
About to enable constraints...
Import terminated successfully with warnings.
Re: import fails [message #268419 is a reply to message #268416] Tue, 18 September 2007 09:14 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use a user that has the necessary privileges.

Regards
Michel
Previous Topic: Exporting data error in oracle 9i
Next Topic: sqlldr files in the directory from windows client
Goto Forum:
  


Current Time: Thu Dec 08 18:30:12 CST 2016

Total time taken to generate the page: 0.10910 seconds