Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
REWRITE_TABLE is being created in database when doing an optimization
설명
Toad creates a table “REWRITE_TABLE” table in the login’s schema when doing query tuning. Why is this table being created? Is there a way to have it created in a different schema?
원인
The REWRITE_TABLE is created by Oracle, when DBMS_MVIEW.EXPLAIN_REWRITE is run, which our SQL Tuning functionality uses. The table is created in the current schema when Oracle's utlxrw.sql script is run.
해결 방안
Since this is an Oracle object, and not a Toad object, contact Oracle for questions regarding REWRITE_TABLE.