ALTER TABLE OE.CUSTOMERS
DROP PRIMARY KEY CASCADE;
DROP TABLE OE.CUSTOMERS CASCADE CONSTRAINTS;
CREATE TABLE OE.CUSTOMERS
(
CUSTOMER_ID NUMBER(6),
CUST_FIRST_NAME VARCHAR2(20 BYTE) CONSTRAINT CUST_FNAME_NN NOT NULL,
CUST_LAST_NAME VARCHAR2(20 BYTE) CONSTRAINT CUST_LNAME_NN NOT NULL,
CUST_ADDRESS OE.CUST_ADDRESS_TYP,
PHONE_NUMBERS OE.PHONE_LIST_TYP,
NLS_LANGUAGE VARCHAR2(3 BYTE),
NLS_TERRITORY VARCHAR2(30 BYTE),
CREDIT_LIMIT NUMBER(9,2),
CUST_EMAIL VARCHAR2(30 BYTE),
ACCOUNT_MGR_ID NUMBER(6),
CUST_GEO_LOCATION MDSYS.SDO_GEOMETRY,
DATE_OF_BIRTH DATE,
MARITAL_STATUS VARCHAR2(20 BYTE),
GENDER VARCHAR2(1 BYTE),
INCOME_LEVEL VARCHAR2(20 BYTE)
)
COLUMN CUST_ADDRESS NOT SUBSTITUTABLE AT ALL LEVELS
COLUMN CUST_GEO_LOCATION NOT SUBSTITUTABLE AT ALL LEVELS
TABLESPACE EXAMPLE
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER