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)
/
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.
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".
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
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!!
Previous Topic: how 0 can be replaced
Next Topic: Comparing records and merging them into one record (merged)
Goto Forum:
  


Current Time: Wed Dec 07 04:59:20 CST 2016

Total time taken to generate the page: 0.15921 seconds