Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    184

    Unanswered: Specifying the Tablespace when creating an Index

    I'm looking for the way to specify the tablespace an index is created in when the index is stored in a different tablespace than the data.

    I tried this the following, but it choked...

    CREATE INDEX notificationDays
    2 on fmNotifications(numbdays)
    3 TABLESPACE table_space_name STORAGE (INITIAL 100
    4 NEXT 100 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PCTUSED 80
    Any help would be appreciated.

    Thank you in advance.

    Robert

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    Please post your full error text.
    I tend to rebuild the indexes.
    However, here is a sample script:
    PHP Code:
    CREATE INDEX notificationDays ON fmNotifications
    (numbdays)
    LOGGING
    TABLESPACE my_tablespace_name
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    
    (
                
    INITIAL          32K
                NEXT             16K
                MINEXTENTS       1
                MAXEXTENTS       249
                PCTINCREASE      0
                FREELISTS        1
                FREELIST GROUPS  1
                BUFFER_POOL      
    DEFAULT
               )
    NOPARALLEL
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    May 2004
    Posts
    184
    Duck,

    Thank you. I think I figured out that my error was 'PCTUSED 80 '. Apparently this is not allow on a CREATE INDEX statement?

    Thank you for your example and quick response.

    Robert

Posting Permissions

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