Re: What is this trying to do...

Hi cg,

This sql statement looks quite correct. SYS_IOT_TOP_288891 is a name of primary key constraint. If this name confuses you, you can write this:

CREATE TABLE WB_RT_TIME_SRC
( ID_COL NUMBER NOT NULL PRIMARY KEY
 )
. . .

Oracle gives your primary key automatic name.

Regards,
Michael
Brainbench MVP for Oracle Programming
http://www.brainbench.com

gore_at_intersystems.com (cg) wrote in message news:<747dbee0.0212260914.3aa52c5e_at_posting.google.com>...
> Hi -
>
> I'm not certain what this Create Table statement on Oracle 8.1.7 is
> doing (it doesn't look like leagle SQL to me, but I'm not certain)
>
>
> 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 - 13:52:05 CET