Home » SQL & PL/SQL » SQL & PL/SQL » create table statement
create table statement [message #213404] Wed, 10 January 2007 12:12 Go to next message
rastrahm
Messages: 3
Registered: January 2007
Junior Member
the following statement is from the create table section of the 10g documentation. i'm unable to locate the "including" clause in the syntax diagram. "including" does appear in the index_org_overflow_clause, but it is followed by the the keyword overflow. am i missing something?

create table countries_demo
(country_id char(2) constraint country_id_nn_demo not null,
country_name varchar2(40),
currency_name varchar2(25),
currency_symbol varchar2(3),
region varchar2(15),
constraint country_c_id_pk_demo primary key (country_id))
organization index
including country_name
pctthreshold 2
storage
(initial 4k next 2k pctincrease 0 minextents 1 maxextents 1)
overflow storage (initial 4k next 2k pctincrease 0 minextents 1 maxextents 1)
/

Report message to a moderator

Re: create table statement [message #213406 is a reply to message #213404] Wed, 10 January 2007 12:18 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Here it mentions the INCLUDING clause in the index_org_overflow_clause.

Report message to a moderator

Re: create table statement [message #213423 is a reply to message #213406] Wed, 10 January 2007 13:01 Go to previous messageGo to next message
rastrahm
Messages: 3
Registered: January 2007
Junior Member
i concede that the "including" keyword appears in the index_org_overflow_clause. however, the syntax diagram indicates that it is immediately followed by the required keyword "overflow".

Report message to a moderator

Re: create table statement [message #213426 is a reply to message #213423] Wed, 10 January 2007 13:42 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The INCLUDING clause isn't included in the train diagram because it's referenced in index_org_overflow_clause that is in the train diagram. The CREATE TABLE train diagram is definitely one that seems to go on and on.

Since the example CREATE TABLE statement you posted is stipulating storage characteristics for the OVERFLOW segment AND for the table segment itself, the OVERFLOW clause is specified before the closing STORAGE clause instead. As indicated in the docs:

All physical attributes and storage characteristics you specify in this clause after the OVERFLOW keyword apply only to the overflow segment of the table. Physical attributes and storage characteristics for the index-organized table itself, default values for all its partitions, and values for individual partitions must be specified before this keyword.

HTH

Report message to a moderator

Re: create table statement [message #213432 is a reply to message #213426] Wed, 10 January 2007 14:13 Go to previous message
rastrahm
Messages: 3
Registered: January 2007
Junior Member
thanks a lot for your help!!

Report message to a moderator

Previous Topic: how 0 can be replaced
Next Topic: Comparing records and merging them into one record (merged)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 08 17:54:02 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.