Re: (Newb) Create table ... default storage

if all your tables located in the same tablespace then you can define a default storage for such tablespace.

    create tablespace tbname datafile filedefinition

            default storage .........;

Then you create a schema owner with such default tablespace

    create user user1 identified by user1

            default tablespace tbname;

then you can create your tables without your storage clause.

John Chiu
johnc_at_relsol.com

Chui Tey wrote:

> When I run a CREATE TABLE statement, my default settings somehow uses up all
> the available Tablespace. To circumvent this I use the STORAGE( INITIAL ..)
> directive explicitly when creating every table. How do I alter the default
> storage size for all subsequent tables created without having to explicitly
> state this every time. Thanks.
Received on Sat Sep 11 1999 - 05:23:24 CDT