Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    1

    Arrow Unanswered: Indexing a Blob...defining a tablespace

    I am having a hard time creating a BLOB index. I can create the index, but it aways goes into the system tablespace. I have tried to define the parameters, but it doesn't seem to recognize them. Here's what I am doing:


    begin
    ctx_ddl.create_preference('resumestore', 'BASIC_STORAGE');
    ctx_ddl.set_attribute('resumestore', 'I_TABLE_CLAUSE', 'tablespace IRC_INDX storage (initial 5m)');
    ctx_ddl.set_attribute('resumestore', 'K_TABLE_CLAUSE', 'tablespace IRC_INDX storage (initial 5m)');
    ctx_ddl.set_attribute('resumestore', 'R_TABLE_CLAUSE',
    'tablespace IRC_INDX storage (initial 5m)');
    ctx_ddl.set_attribute('resumestore', 'N_TABLE_CLAUSE',
    'tablespace IRC_INDX storage (initial 5m)');
    ctx_ddl.set_attribute('resumestore', 'I_INDEX_CLAUSE',
    'tablespace IRC_INDX storage (initial 5m)');
    end;


    CREATE INDEX i_temp1 ON temp (temp_blob)
    INDEXTYPE IS ctxsys.context
    PARAMETERS ('storage resumestore');

    Does anyone know what I'm doing wrong??

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    the syntax is
    CREATE INDEX name ON table (bla)
    TABLESPACE tsname;
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

Posting Permissions

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