Re: LM Tablespace Autoextend Value

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 9 Jan 2007 11:42:01 -0000
Message-ID: <mLGdnU6uFd2dHT7YRVnyvgA@bt.com>

"Johne_uk" <edgarj_at_tiscali.co.uk> wrote in message news:1168342475.178100.317280_at_42g2000cwt.googlegroups.com...
> 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
>

Assuming you are running with an 8KB block size, 640 blocks is 5MB. Is your extraction, (or interpretation) of the column correct ?

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Received on Tue Jan 09 2007 - 05:42:01 CST

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