What is this trying to do...
From: cg <gore_at_intersystems.com>
Date: 26 Dec 2002 09:14:44 -0800
Message-ID: <747dbee0.0212260914.3aa52c5e_at_posting.google.com>
PCTTHRESHOLD 50
NOPARALLEL
/
Date: 26 Dec 2002 09:14:44 -0800
Message-ID: <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