Oracle tablespace management
From: Srini <aone1504_at_yahoo.com>
Date: 12 Aug 2003 02:48:37 -0700
Message-ID: <e5aecd60.0308120148.1cd03e5e_at_posting.google.com>
Date: 12 Aug 2003 02:48:37 -0700
Message-ID: <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
Received on Tue Aug 12 2003 - 11:48:37 CEST