Hi :

I have a tablespace that is made autoextend off and I want to make it ON.. Is that OK and possible on a system where the tablespace is constantly used.. What other choices do I have ??

Secondly, the application I am working on is Siebel.. And we are doing some dataloads. What I dont understand is, the datafile size is 1.3GB and the index file is already 2GB.. The indexes are for the data and how can the indexes be occupying more space than the entire data..

THirdly, I want to re-organize the indexes and I remember that it is best to drop and create indexes rather than re-organize them. What is the best method here, if I want to take a backup of indexes alone..

Thanks, ST