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

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,607 other followers

%d bloggers like this: