Re: What is this trying to do...

This "CONSTRAINT SYS_IOT_TOP_288891" is just the name of the primary key constraint created on the following line ("PRIMARY KEY (ID_COL) ENABLE VALIDATE"). If you don't specify the name that way, that name is system-generated. You can see that by looking at the table user_constraints, for CONSTRAINT_NAME = 'SYS_IOT_TOP_288891', after you ran this statement. Besides that, this SQL statement is a relatively simple one which creates an index-organized table (as can be seen with "ORGANIZATION INDEX") consisting of only one column.

HTH Daniel
OCP
>
> CREATE TABLE WB_RT_TIME_SRC
> (
> ID_COL NUMBER NOT NULL,
> CONSTRAINT SYS_IOT_TOP_288891
> PRIMARY KEY (ID_COL) ENABLE VALIDATE
> )
> ORGANIZATION INDEX
> TABLESPACE USERS
> LOGGING
> PCTFREE 10
> INITRANS 2
> MAXTRANS 255
> STORAGE(INITIAL 5M
> NEXT 5M
> MINEXTENTS 1
> MAXEXTENTS UNLIMITED
> PCTINCREASE 0
> FREELISTS 1
> FREELIST GROUPS 1
> BUFFER_POOL DEFAULT)
> PCTTHRESHOLD 50
> NOPARALLEL
> /
>
>
> It's the "CONSTRAINT SYS_IOT_TOP_288891" bit that confuses me. I'm
> working on documenting some SQL that we have inherited, and this
> is throwing me for a loop.
>
> Thanks in advance
Received on Fri Dec 27 2002 - 16:43:05 CET