Re: Oracle tablespace management

aone1504_at_yahoo.com (Srini) wrote in message news:<e5aecd60.0308120148.1cd03e5e_at_posting.google.com>...
> In our Oracle installation on SCO Unix, we have reached almost 100% of
> tablespace allocated to Oracle. Now we have deleted a large table from
> the database after taking backup elsewhere.
> [1] Now if we start inserting rows to the table, will the tablespace
> try to grow further or will Oracle utilise the space available because
> of deletion of the table rows.?
>
> [2] How do we add more space from the Operating system to Oracle
> tablespace?
>
>
> Thanks,
> Srini

Hi Srini,

1. New data insert into objects residing on this tablespace will use the space created by deletion of rows.
2. You can always add a datafile from another disk to this tablespace.

Cheers Received on Tue Aug 12 2003 - 16:04:23 CEST