| Error trying to import stats [message #123237] |
Fri, 10 June 2005 13:25  |
Whitelock
Messages: 2
Registered: June 2005
|
Junior Member |
|
|
I am trying to import stats from an export file into another database. I have exported the stats from the data dictionary using dbms_stats.export_schema_stats procedure as the sys user. Then I export the table that is stored in the schema named John. Now I am trying to import the table into a new database to test the stats, but I am getting insufficient privileges errors.
I am issuing this command:
EXEC dbms_stats.import_schema_stats('John', 'Stats_table') as the sys user.
The error that I am getting is:
BEGIN dbms_stats.import_schema_stats('JOHN', 'STATS_TABLE'); END;
*
ERROR at line 1:
ORA-20000: Schema JOHN does not exist or insufficient privileges to analyze an
object within it
ORA-06512: at "SYS.DBMS_STATS", line 4844
ORA-06512: at "SYS.DBMS_STATS", line 4867
ORA-06512: at "SYS.DBMS_STATS", line 5383
ORA-06512: at line 1
Does anyone have any idea on this problem?
|
|
|
|
| Re: Error trying to import stats [message #123246 is a reply to message #123237] |
Fri, 10 June 2005 15:00  |
Whitelock
Messages: 2
Registered: June 2005
|
Junior Member |
|
|
To find a work-around for my problem, I had to import each individual table that did not succeed the first time using DBMS_STATS.IMPORT_TABLE_STATS. This seemed to work.
I still have no idea why the procedure errored out half way through.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
