-- Generated by Oracle SQL Developer Data Modeler 3.1.3.706 -- at: 2013-12-20 14:57:56 CET -- site: Oracle Database 10g -- type: Oracle Database 10g CREATE USER SH IDENTIFIED BY ACCOUNT UNLOCK ; CREATE TABLE CAT ( ID_CAT NUMBER (38) NOT NULL , CAT_NAME VARCHAR2 (20 BYTE) ) PCTFREE 10 PCTUSED 40 MAXTRANS 255 TABLESPACE EXAMPLE NOLOGGING STORAGE ( INITIAL 65536 NEXT 1048576 PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 2147483645 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ; CREATE UNIQUE INDEX SH.CAT_PK ON CAT ( ID_CAT ASC ) TABLESPACE EXAMPLE PCTFREE 10 MAXTRANS 255 STORAGE ( INITIAL 65536 NEXT 1048576 PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 2147483645 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOLOGGING ; ALTER TABLE CAT ADD CONSTRAINT CAT_PK PRIMARY KEY ( ID_CAT ) USING INDEX SH.CAT_PK ; CREATE TABLE HELLO ( DESCRIPTION VARCHAR2 (20 BYTE) , ID NUMBER (20) NOT NULL ) PCTFREE 10 PCTUSED 40 MAXTRANS 255 TABLESPACE EXAMPLE NOLOGGING STORAGE ( INITIAL 65536 NEXT 1048576 PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 2147483645 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ; CREATE UNIQUE INDEX SH.HELLO_PK ON HELLO ( ID ASC ) TABLESPACE EXAMPLE PCTFREE 10 MAXTRANS 255 STORAGE ( INITIAL 65536 NEXT 1048576 PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 2147483645 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOLOGGING ; ALTER TABLE HELLO ADD CONSTRAINT HELLO_PK PRIMARY KEY ( ID ) USING INDEX SH.HELLO_PK ; CREATE TABLE HELLOCATEGORIE ( ID_HELLO NUMBER (20) , ID_CAT NUMBER (38) ) PCTFREE 10 PCTUSED 40 MAXTRANS 255 TABLESPACE EXAMPLE NOLOGGING STORAGE ( INITIAL 65536 NEXT 1048576 PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 2147483645 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) ; ALTER TABLE HELLOCATEGORIE ADD CONSTRAINT HELLOCATEGORIE_FK1 FOREIGN KEY ( ID_HELLO ) REFERENCES HELLO ( ID ) NOT DEFERRABLE ; ALTER TABLE HELLOCATEGORIE ADD CONSTRAINT HELLOCATEGORIE_FK2 FOREIGN KEY ( ID_CAT ) REFERENCES CAT ( ID_CAT ) NOT DEFERRABLE ; -- Oracle SQL Developer Data Modeler Summary Report: -- -- CREATE TABLE 3 -- CREATE INDEX 2 -- ALTER TABLE 4 -- CREATE VIEW 0 -- CREATE PACKAGE 0 -- CREATE PACKAGE BODY 0 -- CREATE PROCEDURE 0 -- CREATE FUNCTION 0 -- CREATE TRIGGER 0 -- ALTER TRIGGER 0 -- CREATE STRUCTURED TYPE 0 -- CREATE COLLECTION TYPE 0 -- CREATE CLUSTER 0 -- CREATE CONTEXT 0 -- CREATE DATABASE 0 -- CREATE DIMENSION 0 -- CREATE DIRECTORY 0 -- CREATE DISK GROUP 0 -- CREATE ROLE 0 -- CREATE ROLLBACK SEGMENT 0 -- CREATE SEQUENCE 0 -- CREATE MATERIALIZED VIEW 0 -- CREATE SYNONYM 0 -- CREATE TABLESPACE 0 -- CREATE USER 1 -- -- DROP TABLESPACE 0 -- DROP DATABASE 0 -- -- ERRORS 0 -- WARNINGS 0