Create TABLE with 1 EXTENT ??

idsi_at_warp10.smartlink.net!

Reply to a message from idsi_at_warp10.smartlink.net to All:

 i> How do I create a table with only one extent so that it never trys to  i> grab another extent ?
Try the following:

create table xyz (i number, ... ) storage (initial <initial-extent-size>)

For more information have a look to the syntax explaining the statements:

1. create table
2. create tablespace
3. create index

they all have a storage-clause.

Bye Ralf! Received on Sat Jul 01 1995 - 00:00:00 CEST