Database Administration (MOSC)

MOSC Banner

Unique system index on a blob column in a partitioned table

edited Jun 20, 2017 5:03AM in Database Administration (MOSC) 3 commentsAnswered

Hi,

I have a table

CREATE TABLE "owner"."table_name"

   (     "id1" NUMBER(5,0) NOT NULL ENABLE,

        "id2" NUMBER(19,0) NOT NULL ENABLE,

       "SAMPLES" BLOB,

       CONSTRAINT "PK_tablename" PRIMARY KEY ("id1", "id2")

       USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255

....

STORAGE(

  BUFFER_POOL DEFAULT)

  TABLESPACE "tablespacename"

LOB ("SAMPLES") STORE AS (

  ENABLE STORAGE IN ROW CHUNK 16384 PCTVERSION 10

  NOCACHE LOGGING

  STORAGE(

  BUFFER_POOL DEFAULT))

  PARTITION BY RANGE ("id1","id2")

(PARTITION "tablename_1_43601"  VALUES LESS THAN (1, 5001)

  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

......

}

SELECT * FROM USER_INDEXES WHERE .....;

SYS_IL0001531233C00003$$LOBOWNER

   TABLE_NAME

TABLEUNIQUE

This is a system generated index, it seems oracle create a LOCAL unique index on the blob column?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center