Re: Pre-allocation of spce for new rows.

> Could you pls tell me, if I want to insert 1 million row to a table,
> how would I pre-allocate space to the data and index tablespaces, so
> that it will not fail. Oracle 7.3.

Alter table allocate extent ( [size integer [M|K]] [datafile 'filename']);

It's in the FM.

Rob Received on Thu Oct 11 2001 - 07:51:46 CDT