LM Tablespace Autoextend Value - an easy one !!!

Hi,

I have a Locally Managed tablespace created at size 1GB and allowed to autoextend to 4GB (in 5MB chunks). The t/s has a single datafile.

I'm writing a sql script to recreate all my tablespaces as part of an overnight backup job. I've written the procedure to do this but I'm having trouble getting the 5M autoextend value from the data dictionary. I'm using the value in dba_data_files.increment_by but this reports 640 bytes - is there somewhere else I need to be returning this value from.

Thanks in advance
John Received on Tue Jan 09 2007 - 05:34:35 CST