DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: how do i solve this problem

  1. #1
    Join Date
    Sep 2008
    Posts
    4

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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
  •  


Click Here to Expand Forum to Full Width