Home » RDBMS Server » Server Administration » Changing the Initial extent
Changing the Initial extent [message #369622] Fri, 10 November 2000 17:26
ram
Messages: 95
Registered: November 2000
Member
I am not a DBA, I have a DBA related question. I have created a tablespace for storing my indices, I have large amount of data to be indexed. Hence I created the tablespace with a large initial extent. I get an unable to create initial extent error.
Now, how do I make the initial extent smaller ? The ALTER TABLESPACE command lets you set the MINIMUN EXTENT size but not change the INITIAL EXTENT. Any help is appreciated.

Thanks,
-- Ram
Previous Topic: Re: sql session unable to open from client. urgent please
Next Topic: Rollback Segment Survey
Goto Forum:
  


Current Time: Thu May 02 17:59:21 CDT 2024