#
# ORACLE Performance Tuning Appendix A p. 455
# Multiplexed Redo Logs
    CREATE DATABASE  . . .
        LOGFILE GROUP 1 ( 'DISK:A\ORA1.LOG',
                          'DISK:B\ORA1.LOG', 
                          'DISK:C\ORA1.LOG') SIZE 100K,
        LOGFILE GROUP 2 ( 'DISK:A\ORA2.LOG', 
                          'DISK:B\ORA2.LOG',
                          'DISK:C\ORA2.LOG') SIZE 100K,
        LOGFILE GROUP 3 ( 'DISK:A\ORA3.LOG',
                          'DISK:B\ORA3.LOG',
                          'DISK:C\ORA3.LOG') SIZE 100K
#
# ORACLE Performance Tuning Appendix A p. 456
# Setting an Optimal Size for a Rollback Segment
     CREATE PUBLIC ROLLBACK SEGMENT RB1 
                TABLESPACE  RB_TS
                STORAGE (OPTIMAL 50K . . .);
#
# ORACLE Performance Tuning Appendix A p. 460
# Declarative Data Integrity Constraints
    CREATE TABLE EMP   (EMP_NO      NUMBER (6,0)     UNIQUE NOT NULL,
                        EMP_NAME    VARCHAR2 (30)    NOT NULL,
                        SEX         VARCHAR2  (1),
                        HIRE_DATE   DATE             DEFAULT  SYSDATE)
                        CHECK (SEX IN ('M', 'F'))
                        CONSTRAINT  EMP_PK  PRIMARY KEY ( EMP_NO )
#
    CREATE TABLE EMP  (EMP_NO       NUMBER (6,0)
                      .
                      .
                      .
                      MGR_EMP       NUMBER (6,0)    CONSTRAINT EMP_MGR
                                                    REFERENCES EMP,
                      . . . )
                     CONSTRAINT  EMP_PK  
                                 PRIMARY KEY  ( EMP_NO )
                     CONSTRAINT  EMP_SALARY_TYPE
                                 FOREIGN KEY ( DEPT, GRP )
                                 REFERENCES  SALARY_GROUPS
#
    CREATE  TABLE  EMP ( . . . )
                        CHECK     (COLUMN3, COLUMN4 IS UNIQUE)
                        CHECK     (COLUMN3  >=  '01-JUL-93' )
                        CHECK     (COLUMN6 IN ('A', 'C', 'X'))
#
# ORACLE Performance Tuning Appendix A p. 464
# Foreign Key Constraints
    CREATE TABLE. . .
        ( column1 . . . CONSTRAINT TAB_FK REFERENCES TAB,
          column2  . . .,
          column3  . . .) ;
    CREATE TABLE . . .
        ( column1  . . .,
          column2  . . .,
          column3  . . . )
    CONSTRAINT TAB_FK
              FOREIGN KEY ( column1, column2 ) REFERENCES TAB;
#
# ORACLE Performance Tuning Appendix A p. 464
# Integrity Constraint Warnings
    ALTER TABLE tab     DISABLE PRIMARY KEY;
    ALTER TABLE tab     DISABLE CONSTRAINT Tab_FK;

    PERFORM DATA TAKEUP  .....

    ALTER TABLE tab     ENABLE PRIMARY Key;
    ALTER TABLE tab     ENABLE CONSTRAINT Tab_FK
                        EXCEPTIONS INTO excep_tab;
#
# ORACLE Performance Tuning Appendix A p. 465
# Integrity Constraint Warnings
    TABLE EXCEP_TAB (ROW_ID       ROWID,
                     CONSTRAINTS  VARCHAR2 (30),
                     OWNER        VARCHAR2 (30),
                     TABLE_OWNER  VARCHAR2 (30) );
#
    TABLE EMPLOYEE_MASTER.
        EMP_NUM         PRIMARY KEY      INDEXED
        COMPANY_CODE    FOREIGN KEY      INDEXED
        REPORT_GRP      FOREIGN KEY 
        DEPT_CODE       FOREIGN KEY      INDEXED
                 
        CREDIT_RATING   FOREIGN KEY
        SALARY_GRADE    FOREIGN KEY
        ADDRESS_LINE1
        ADDRESS_LINE2
        ADDRESS_LINE3
        POST_CODE       FOREIGN KEY