Index Usage – 1
-
In 12.2 Oracle introduced Index Usage Tracking to replace the previous
option for “alter index xxx monitoring usage”. A recent post on the Oracle
database ...
Acum 3 zile
You've got to have a dream. When you lose your dreams, you die.
$sqlplus / as sysdba sqlplus> alter user APEX_030200 grant connect through scott; User altered.
exec dbms_stats.set_table_prefs(ownname=>user, tabname=>
'BOWIE'
,
pname=>
'TABLE_CACHED_BLOCKS'
, pvalue=>
42
);
ALTER TABLE
statement with the EXCEPTIONS
option in the ENABLE
clause. The EXCEPTIONS
option places the rowid, table owner, table name, and constraint name of all exception rows into a specified table.EXCEPTIONS
option of the ENABLE
clause before enabling the constraint. You can create an exception table by executing the UTLEXCPT.SQL
script or the UTLEXPT1.SQL
script.EXCEPTIONS
. You can create additional exceptions tables with different names by modifying and resubmitting the script.PRIMARY KEY
of the dept
table, and if exceptions exist, information is inserted into a table namedEXCEPTIONS
:ALTER TABLE dept ENABLE PRIMARY KEY EXCEPTIONS INTO EXCEPTIONS;
dept
table and the name of the PRIMARY KEY
constraint on dept
is sys_c00610
, then the following query will display those exceptions:SELECT * FROM EXCEPTIONS;