Oracle tablespace management

[Srini]

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

[Mark D Powell]

ao******@yahoo.com (Srini) wrote in message news:<e5**************************@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

See the Oracle Concepts manual. Space management is fully explained there.

HTH -- Mark D Powell --

[Daniel Roy]

Please read a bit about Oracle storage concepts at tahiti.oracle.com.
It's important for us to know which version of Oracle you're using,
since Oracle storage features vary widely from version to version. A
tablespace (i.e. datafile) can be set to grow automatically or not
(look at the value of the columns AUTOEXTENSIBLE, MAXBLOCKS of
DBA_DATA_FILES for the datafiles in your tablespace. Look also at
EXTENT_MANAGEMENT and ALLOCATION_TYPE of DBA_TABLESPACES to see if
you're dealing with locally or dictionary-managed tablespaces).
Depending on your setup, you might need to either create a new
datafile, or allocate more space to an existing one.

Daniel

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

[Shailandra Vaish]

ao******@yahoo.com (Srini) wrote in message news:<e5**************************@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

[Stephen_CA]

ao******@yahoo.com (Srini) wrote in message news:<e5**************************@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,

[1] If you merely deleted the rows it will not release the space; if
you truncated the table (or dropped and recreated it) it will try to
use the space

[2] Use the ALTER TABLESPACE command to either:
i) resize one or more datafiles that make up the tablespace or;
ii) add a datafile to the tablespace

Hope this helps,

Steve

[Srini]

Thank you all for the help.

Regards,
Srini

st**********@sympatico.ca (Stephen_CA) wrote in message news:<5a**************************@posting.google. com>...

ao******@yahoo.com (Srini) wrote in message news:<e5**************************@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,

[1] If you merely deleted the rows it will not release the space; if
you truncated the table (or dropped and recreated it) it will try to
use the space

[2] Use the ALTER TABLESPACE command to either:
i) resize one or more datafiles that make up the tablespace or;
ii) add a datafile to the tablespace

Hope this helps,

Steve