Creation of a REF Request and REF Passing Method Set

rem
rem Now create the object employees which contains
rem nested tables, types and normal attributes
rem
CREATE TABLE employees OF emp_t
OIDINDEX oid_employees (TABLESPACE raw_INDEX)
NESTED TABLE dependents STORE AS dependentsv8a
       PCTFREE 10 PCTUSED 80
       INITRANS 5 MAXTRANS 255
       TABLESPACE raw_data
       STORAGE (
              INITIAL 20m NEXT 10m
              MINEXTENTS 1 MAXEXTENTS 10
              PCTINCREASE 0
       )
/
 
ALTER TABLE employees ADD
       CONSTRAINT PK_employees
              PRIMARY KEY (employee_id)
       USING INDEX
              PCTFREE 20
              INITRANS 5
              MAXTRANS 255
              TABLESPACE raw_index
              STORAGE (
                     INITIAL 10m NEXT 10m
                     MINEXTENTS 1 MAXEXTENTS 121
                     PCTINCREASE 0 FREELISTS 5
              )
/
 
ALTER TABLE employees MODIFY
   name NOT NULL
/

SEE CODE DEPOT FOR FULL SCRIPTS

If you like Oracle tuning, you may enjoy the book Oracle Tuning: The Definitive Reference , with over 900 pages of BC's favorite tuning tips & scripts.  You can buy it directly from the publisher and save 30%, and get instant access to the code depot of Oracle tuning scripts.