471,092 Members | 1,525 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

Oracle tablespace management

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
Jul 19 '05 #1
5 10198
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 --
Jul 19 '05 #2
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

Jul 19 '05 #3
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
Jul 19 '05 #4
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
Jul 19 '05 #5
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

Jul 19 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by susmita_ganguly | last post: by
1 post views Thread by Jens H. Hamann | last post: by
reply views Thread by Zvika Glickman | last post: by
133 posts views Thread by jonathan | last post: by
56 posts views Thread by Ashish Patankar | last post: by
3 posts views Thread by christof | last post: by
5 posts views Thread by Srini | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.