Re: alter tablespace

Ed,

The minextents usually are set when creating the tablespace. Example follows.

	create tablespace test_tablespace
	datafile '/drive/x' size 4M
	default storage (minextents 20 maxextents 100 pctincrease 1) ;

The alter is:

	alter tablespace test_tablespace
	default storage (minextents 10) ;

To create additional rollback segments

	create rollback segment test_rollback
	tablespace test_tablespace
	storage (initial 10k next 10k minextents 5 maxextents 120 ) ;

However, if you want the minimal approach:

        create rollback segment test_rollback tablespace test_tablespace ;

(The above is not the optimal, but it sounds like you are just learning...)

Hope this helps.

Joel Received on Wed Feb 18 1998 - 00:00:00 CST