9.2.0.5 Ent Ed AIX5L
I am trying to import statistics using the
dbms_stats.import_schema_stats procedure from one db/schema to
another. The procedure died with an 'ORA-20000 Schema TRDTA does not
exist or insufficient privileges' the schema does exist and I'm logged
in as sysdba. In trying to find what would cause this, the only thing
I see ( and fairly certain this is the cause ) is that some of the
indexes are not named the same between prod and test environments.
Would that cause my issue? In other words the _PK indexes are called
_0 on some of my tables and vice versa. I'm not sure how this happened
as it has been that way since I took over this database and I haven't
researched renaming them yet.
Would the best ( and simplest ) thing to do be 'ALTER INDEX ...
RENAME ...' ?
Thanks
Received on Mon Jan 29 2007 - 10:35:42 CST
