Fixing ORA-19384 from DBMS_SQLTUNE.PACK_STGTAB_SQLSET on SQLT
If you see in the main html SQLTXPLAIN (SQLT) the following error you can execute the commands below connected as SYS:
sqlt$a: *** d:ORA-19384: cannot pack into staging table from previous version
sqlt$a: *** d:DBMS_SQLTUNE.PACK_STGTAB_SQLSET
DROP TABLE sqltxplain.sqli$_stgtab_sqlset; BEGIN SYS.DBMS_SQLTUNE.CREATE_STGTAB_SQLSET ( table_name => 'SQLI$_STGTAB_SQLSET', schema_name => 'SQLTXPLAIN'); END; / DROP TABLE sqltxplain.sqlt$_stgtab_sqlset; BEGIN SYS.DBMS_SQLTUNE.CREATE_STGTAB_SQLSET ( table_name => 'SQLT$_STGTAB_SQLSET', schema_name => 'SQLTXPLAIN'); END; /
Leave a Reply