Skip to Main Content

SQL & PL/SQL

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!

ORA-38172: No SQL management object satisfies specified filters

grapes12Sep 11 2012 — edited Sep 11 2012
hi,

I am trying to export SQL profiles from my database into dev database, received the above error.
exec DBMS_SQLTUNE.CREATE_STGTAB_SQLPROF('STGTAB_SQLPROF','MAC');
then pack sql profiles into created table
exec DBMS_SQLTUNE.PACK_STGTAB_SQLPROF('SQL_PROFILES','%','STGTAB_SQLPROF','MAC');
ERROR at line 1:
ORA-38172: No SQL management object satisfies specified filters
ORA-06512: at "SYS.DBMS_SMB", line 663
ORA-06512: at "SYS.DBMS_SQLTUNE", line 6325
ORA-06512: at line 1
Any assistance will be highly appreciated
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 9 2012
Added on Sep 11 2012
1 comment
3,411 views