Re: LM Tablespace Autoextend Value - an easy one !!!

Johne_uk wrote:
> 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
>

Why not just dump the control file to trace? Oracle has done this for you and the resulting trace file will contain all of the same information.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown