OraFAQ Forum: Server Administration » Import with statistics

Home » RDBMS Server » Server Administration » Import with statistics

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

Import with statistics [message #149123]

Wed, 30 November 2005 03:30

Zakkhalid
Messages: 47
Registered: April 2005

Member

Hi All,

I'm trying to do an import of a schema where the tables have statistics, but I'm getting an error ...

IMP-00017: following statement failed with ORACLE error 4068:
"BEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"CTRELATEDLINKS"',NULL,NULL,NULL,34"
"4,2,25,0); END;"
IMP-00003: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "SYS.DBMS_STATS" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1

Not sure how to progress, because the package DBMS_STATS is valid...,

so how can I do an import with and without statistics....

thanking you all inadvance...

Report message to a moderator

Re: Import with statistics [message #149149 is a reply to message #149123]

Wed, 30 November 2005 06:22

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

did you try importing as a DBA user?

Report message to a moderator

Re: Import with statistics [message #149150 is a reply to message #149123]

Wed, 30 November 2005 06:25

Zakkhalid
Messages: 47
Registered: April 2005

Member

Hi,

I didn't try that, I'll give it ago, but ideally I want to import as the user.

Report message to a moderator

Re: Import with statistics [message #149152 is a reply to message #149150]

Wed, 30 November 2005 06:39

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Or is the target database a new one ( or manually built?)
if the above does not help,
in target database, login as sys and run dbmsstat.sql
try again.
And, just a dumb question. Are you sure you did export with STATISTICS ?

Report message to a moderator