create table Parent(
  ParentID number( 16 ) not null,
  primary key (ParentID)
)

create table Child(
  ChildID number( 16 ) not null,
  ParentID number( 16 ) not null,
  primary key (ChildID),
  Foreign key (ParentID) References Parent
)

CREATE TABLE schema.parent (
       ParentlID             NUMBER( 5 ) NOT NULL,
       DateFrom             DATE NULL,
       CONSTRAINT XPKPRIVEL 
              PRIMARY KEY (PrivelID)
:       USING INDEX
:  PCTFREE  10 
:    INITRANS  2 
:   MAXTRANS  255 
:    STORAGE  (
:   INITIAL  131072 
:   NEXT  131072 
:   MINEXTENTS  1  
:   MAXEXTENTS  4096  
:   PCTINCREASE  0  
:   FREELISTS  1  
:   FREELIST GROUPS  1  
:  )
:  REVERSE