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

Jonathan Lewis wrote:
> "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

Hi

Thanks Jonathan I'd just found out from AskTom that its blocks and not actual bytes. But you are on the ball as per usual.

Thanks again
John Received on Tue Jan 09 2007 - 05:52:28 CST