Home » RDBMS Server » Server Utilities » Problem in Import
Problem in Import [message #244392] Tue, 12 June 2007 10:32 Go to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Hello,
i have dump file from previous oracle versions not sure
while importing it into 10.2.0.3.0 on os solaris 10 64 bit it thrwoing this error

 "DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '20'; SREC.MAXVAL :="
 " '57494C54454C'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_S"
 "TATS.NUMARRAY(166153499473115000000000000000000000,453216490014463000000000"
 "000000000000); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS"
 "_STATS.SET_COLUMN_STATS(NULL,'"FIBRTKTARCH"','"KEYWORD"','"Q1_2004"',NULL,N"
 "ULL,44,.0227272727272727,652732,srec,1,0); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: Q1_2004 invalid partition name
ORA-06512: at "SYS.DBMS_STATS", line 1675
ORA-06512: at "SYS.DBMS_STATS", line 4932
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20000:
 "DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '20'; SREC.MAXVAL :="
 " '504D'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUM"
 "ARRAY(166153499473115000000000000000000000,41694549422226700000000000000000"
 "0000); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.S"
 "ET_COLUMN_STATS(NULL,'"FIBRTKTARCH"','"TKTRESOURCE"','"Q1_2004"',NULL,NULL,"
 "7,.142857142857143,496366,srec,1,0); END;"


any one have ides why?

Thanks.

[Updated on: Tue, 12 June 2007 10:33]

Report message to a moderator

Re: Problem in Import [message #244399 is a reply to message #244392] Tue, 12 June 2007 11:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
20000, 00000, "%s"
// *Cause:  The stored procedure 'raise_application_error'
//          was called which causes this error to be generated.
// *Action: Correct the problem as described in the error message or contact
//          the application administrator or DBA for more information.
Re: Problem in Import [message #244402 is a reply to message #244392] Tue, 12 June 2007 11:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
ORA-20000: Q1_2004 invalid partition name

Import tried to set statistics on an inexistent partition.

Try import with "statistics=none".
If this does not work, reexport with this parameter and retry the import.

Regards
Michel
Re: Problem in Import [message #244405 is a reply to message #244402] Tue, 12 June 2007 12:14 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Thanks michel;)
Previous Topic: how could I export in excel (Client Machine) from sql query
Next Topic: How to populate one column based on another columns data?
Goto Forum:
  


Current Time: Wed Jul 03 17:36:20 CDT 2024