How you can create plan table if plan table already not exists?

Saturday, 19 December 2009 15:48 |

Written by Administrator |

UTLXPLAN.SQL script if plan table not already exists and creates table Named PLAN_TABLE

SQL> CONN sys/password AS SYSDBA 
SQL> @$ORACLE_HOME/rdbms/admin/utlxplan.sql
SQL> GRANT ALL ON sys.plan_table TO public;
SQL> CREATE PUBLIC SYNONYM plan_table FOR sys.plan_table;

Tags:

Explain Plan

Last Updated (Wednesday, 23 December 2009 18:58)