-
how do i solve this problem
CREATE TABLE "MY_OE"."CUSTOMERS" ( "CUSTOMER_ID" NUMBER(6), "CUST_FIRST_NAME" VARCHAR2(20) CONSTRAINT "CUST_FNAME_NN" NOT NULL , "CUST_LAST_NAME" VARCHAR2(20) CONSTRAINT "CUST_LNAME_NN" NOT NULL , "CUST_ADDRESS" "MY_OE"."CUST_ADDRESS_TYP", "PHONE_NUMBERS" "MY_OE"."PHONE_LIST_TYP", "NLS_LANGUAGE" VARCHAR2(3), "NLS_TERRITORY" VARCHAR2(30), "CREDIT_LIMIT" NUMBER(9, 2), "CUST_EMAIL" VARCHAR2(30), "ACCOUNT_MGR_ID" NUMBER(6), "CUST_GEO_LOCATION" "MDSYS"."SDO_GEOMETRY", "DATE_OF_BIRTH" DATE, "MARITAL_STATUS" VARCHAR2(20), "GENDER" VARCHAR2(1), "INCOME_LEVEL" VARCHAR2(20), CONSTRAINT "CUSTOMERS_PK" PRIMARY KEY ("CUSTOMER_ID") VALIDATE , CONSTRAINT "CUSTOMER_CREDIT_LIMIT_MAX" CHECK (credit_limit <= 5000) VALIDATE , CONSTRAINT "CUSTOMER_ID_MIN" CHECK (customer_id > 0) VALIDATE ) TABLESPACE "USERS" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) NOLOGGING
*
ERROR at line 1:
ORA-00902: invalid datatype
-
You can start by putting each column on a different line and then seeing which data type is the problem. You can also make sure that you have the proper grants for the "MDSYS" data types.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|