Video on Client Side Failover in RAC
-
I've posted a new video demonstrating Client Side Failover defined by the
tnsnames.ora file
Acum o săptămână
You've got to have a dream. When you lose your dreams, you die.
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;