Re: Tablespace growth

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 27 Apr 2005 05:48:20 -0700
Message-ID: <1114606100.735012.228290@g14g2000cwa.googlegroups.com>

>>datafile 'c:\oracle\oradata\mydb\abc_01.dbf' size 1502M autoextend on
next 1502M MAXSIZE unlimited

>>How do I get a tablespace to grow until I run out of storage?

Setting the datafile autoextend with MAXSIZE unlimited is not a good way to get it!

(MAXSIZE should be N*extent_size + 64Kb)

>> extent management local uniform size 500M;

500M it's quite a lot! You must have very good reasons to set this size.

Cheers. Received on Wed Apr 27 2005 - 07:48:20 CDT