OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » import fails

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

import fails [message #268409]

Tue, 18 September 2007 08:26

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

Report message to a moderator

Re: import fails [message #268411 is a reply to message #268409]

Tue, 18 September 2007 08:31

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: import fails [message #268416 is a reply to message #268411]

Tue, 18 September 2007 08:47

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.

Report message to a moderator

Re: import fails [message #268419 is a reply to message #268416]

Tue, 18 September 2007 09:14

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use a user that has the necessary privileges.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 14:25:35 CST 2025