I think the actual problem is the lack of space to create that index. Add some more space to that tablespace or add one more datafile to that tablespace

Originally posted by anjandg
I have a tablespace whose max_extent is 505. I am creating an index which comes out giving an error max_extent reached. I want to increase the max_extent for that particular tablespace. Can I do it by issuing an alter tablespace command? I am using oracle 7.3.3 on HP-Unix 10.20. What will be the syntax for the same?