Showing posts with label Constraints. Show all posts
Showing posts with label Constraints. Show all posts
Saturday, August 25, 2012

CONSTRAINT ERROR Find What data creating problem

›
d:\app\Administrator\product\11.2.0\dbhome_1\RDBMS\admin\utlexcpt.sql create table exceptions(row_id rowid,                owner varch...
Friday, August 10, 2012

Check Constraint on SYSDATE

›
create table table1 (startdate date,CloseDate date); ALTER TABLE Table1 ADD (CONSTRAINT GT_Table1_CloseDate CHECK (CloseDate > SYSDA...
Tuesday, August 7, 2012

ORA-02290 check constraint violated

›
Select 'SELECT * FROM ' || Table_Name || ' MINUS SELECT * FROM ' || Table_Name || ' WHERE ' || Search_Condition ||...
Monday, August 6, 2012

ORA-02291: integrity constraint (string.string) violated - parent key not found

›
ORA-02291: integrity constraint (string.string) violated - parent key not found Cause: A foreign key value has no matching primary key v...
Wednesday, April 11, 2012

Find Duplicate records (Unique Index columns) in all Tables

›
SELECT 'SELECT COUNT(*),' || wm_concat(column_name) || ' from ' ||table_name || ' group by ' || wm_concat(column_nam...
Thursday, December 22, 2011

Find and Delete duplicate check Constraints

›
-------------------------------------------------------------------------------- -----------------------------------------------------------...
Friday, April 8, 2011

Primary key Constraints Enable

›
SQL> alter table CLJOBB disable constraint CLJOBB; associated index (CLJOBB) will be dropped automatically. SQL> alter table CLJOBB en...
Wednesday, April 6, 2011

Constraint Check

›
SPOOL C:\CONS.TXT select 'select '||cc.column_name- ||' from '||c.owner||'.'||c.table_name- ||'...

Constraint stats ORA-02298

›
Alter table CEXIST DISABLE constraint CEXISTBROKBOOK; alter table CEXIST disable constraint CEXISTBOOK; alter table CEXIST ENABLE constraint...