Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    79

    Unanswered: Table creation using index

    CONSTRAINT TPMS_PK2
    *
    ERROR at line 7:
    ORA-00922: missing or invalid option

    I get this error..wonder why...
    CREATE table myTable (
    ID VARCHAR2 (17), /* ID Number */
    CONSTRAINT TPMSNON_PK
    PRIMARY KEY (ID )
    USING INDEX
    TABLESPACE TID_INDEX PCTFREE 10
    STORAGE ( INITIAL 24K NEXT 256K PCTINCREASE 0 ));

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Are you sure this code caused ORA-00922 error? There's no TPMS_PK2 constraint in it ...

    Furthermore, I successfully created a table using your code on my Ora 9 DB.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •