Burak Topcu 		 
 
Oracle All Foreign Key Reference Disable-23.07.2012
CREATE OR REPLACE Procedure "SP_FK_DISABLE_ENABLE" is
    Cursor Cur Is
      Select * From All_Constraints C WHERE C.R_CONSTRAINT_NAME like '@PK_IK';
Begin
    For IX in Cur Loop
      Exit When Cur%NOTFOUND;
         dbms_output.put_line('ALTER TABLE '||IX.TABLE_NAME||' ENABLE CONSTRAINT '||IX.CONSTRAINT_NAME||';');
    End Loop;
  
End  SP_FK_DISABLE_ENABLE ;
--@PK_IK : Primary Key i referans olarak gösterdiğiniz tabloları çekmek için tanımlamış olduğunuz primary key name i yazıyoruz.
--ENABLE : Primary Key e bağlı Foreign Key ler ENABLE veya DISABLE yapılıyor

sahip olduğumuz PK_ 'i kullandığımız tüm tablolardaki FK_'lerini disable veya enable yapmaya yarayan procedure


ORACLE PL/SQL  , ALL Foreign Key Disable , ALL Foreign Key Enable , PL/SQL Procedure , ORACLE Procedure , Primary Key Foreign Key Referance Disable Enable 

Oracle PL/SQL All Indexes Rebuild-18.07.2012
CREATE OR REPLACE Procedure "SP_RE_BUILD_INDEX" Is
    Cursor Cur Is
      Select * From All_Indexes A where A.OWNER='@Current User Name';
Begin
    For IX in Cur Loop
      Exit When Cur%NOTFOUND;
         dbms_output.put_line('ALTER INDEX '||IX.INDEX_NAME ||' REBUILD ;');
    End Loop;
End SP_RE_BUILD_INDEX;


Oracle PL/SQL All Indexes Rebuild , The procedure out put dbms , you can change it 
EXECUTE IMMEDIATE 'ALTER INDEX '||IX.INDEX_NAME ||' REBUILD ;'
ORACLE , PL/SQL , PROCEDURE , REBUILD INDEX , ALL INDEX