Re: Tablespace unlimited

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 21 Feb 2002 17:01:55 GMT
Message-ID: <3C752817.BB053D46@ci.seattle.wa.us>

What do you mean by ... "I need to?" Because you can't.

You can, of course, enable autoextend. But depending on your operating system you will likely not be able to autoextend to wipe out your entire DASD without adding another datafile: Something you can not automate within Oracle (or at least not easily).

But then again you can also do other things in Oracle that others might strongly advise against.

Is it that horrible to look at freespace from time-to-time? I mean that is what DBAs are paid for isn't it?

Daniel Morgan

Rod_GBP wrote:

> Hello guys!
> Some doubts:
> 1- If I create a tablespace, it has a limited to grow up?
> 2- I need to change this limit to unlimited.. how I can do it? ALTER
> TABLESPACE t1 UNLIMITED?????
>
> See ya, everyone!
Received on Thu Feb 21 2002 - 11:01:55 CST