Re: Create TABLE with 1 EXTENT ??
From: Dave Mausner <dma956_at_lulu.acns.nwu.edu>
Date: 1995/06/30
Message-ID: <3t1pnt$mj4_at_news.acns.nwu.edu>#1/1
Date: 1995/06/30
Message-ID: <3t1pnt$mj4_at_news.acns.nwu.edu>#1/1
In article <3spjj5$hot_at_warp10.smartlink.net>,
IDSI <idsi_at_warp10.smartlink.net> wrote:
>How do I create a table with only one extent so that it never trys to
>grab another extent ?
>
>I am new to this game and find it very confusing !!!!!!
>
>Thanks in Anticipation
>
>New DBA
You specify the anticipated table size using create table with the
storage() clause: something like:
create table x (columns...) storage(initial 10M maxextents 1);
--Received on Fri Jun 30 1995 - 00:00:00 CEST