how do i solve this problem
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,021
    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.
    this space intentionally left blank

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