Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2002
    Posts
    165

    Unanswered: How can I configure...

    index to go in different tbs in CRATE TABLE statement?

    For example table ZKAJF.ZKAJF
    ( COL1 NUMBER NOT NULL
    constraint CINDEX ( COL1)
    TABLESPACE ( FOR TABLE) TBSTABLE
    TABLESPACE ( FOR INDEX) TBSINDEX

    Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Try the attached SQL.

    That should give you some pointers, there are many ways to create the constraints / indexes etc separately to the table creation, for readability of the script I suppose it depends on how detailed your storage parameters are?

    HTH
    Bill
    Attached Files Attached Files

  3. #3
    Join Date
    Jan 2002
    Posts
    165

    SP2-0734

    Well,I don't want to entering storage parameters.
    My problem is,basically,when i try executing script via SQL*PLUS
    i always see erorr that command beginninig with TABLESPACE
    is not valid.
    I created script through Enterprise Manager console,save that in file,
    removed table,and try to create that through SQL*PLUS.
    Every time i see error that command beginning with TABLESPACE is not valid .
    tHANKS,zVONIMIR

  4. #4
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697

    Re: SP2-0734

    Can you post the offending statement, and also the actual error message you are getting.

    You may find it's a privileges problem on the tablespace, or Oracle couldn't allocate any extents in the tablespace etc...

    HTH
    Bill

Posting Permissions

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