Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_sqltune - table does not exist

lesakJun 9 2010 — edited Jun 9 2010
I've executed this Oracle packages:
exec DBMS_SQLTUNE.CREATE_STGTAB_SQLPROF(table_name=>'test_prof', schema_name=>'USER');

exec dbms_sqltune.pack_stgtab_sqlprof(staging_table_name=>'test_prof',profile_name=>'SYS_SQLPROF_TEMP');
and both of them are successfully completed. But when I try execute some query on this table or just describe columns from this table I've got ORA-04043: object test_prof does not exist. Could anyone explain me where this table is stored?
This post has been answered by Nicolas Gasparotto on Jun 9 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2010
Added on Jun 9 2010
6 comments
1,130 views