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