Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

Fixing ORA-19384 from DBMS_SQLTUNE.PACK_STGTAB_SQLSET on SQLT

leave a comment »

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;
/
Advertisement

Written by Carlos Sierra

April 2, 2013 at 1:04 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: