| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SPACE FREE HOW?
<SPAN
class=932424820-18012002>Nick,
I have
a question regarding LiveReorg's method that prevents modifications to the
original table when it's time to switch to the newly reorged one. AS the
mechanism to prevent DML, LiveReorg creates a temporary trigger
on Insert, Update and Delete. It simply raises a user-defined
exception. With our 24x7 Siebel environment executing massive insert and
updates against the base tables, we expect that the application will receive
this error when we switch to the new table. The problem is that the
application is not coded to handle the exception and the user will get an error
displayed on the client. This is preventing us from utilizing the Live
feature of LiveReorg and is becoming as sore spot with our internal
clients. They expected uninterrupted maintenance and frankly, so did
we. Please correct me if I'm wrong or if I'm not using the tool
correctly.
<SPAN
class=932424820-18012002>
Tony
Aponte
Home
Shopping Network
<FONT face="Times New Roman"
size=2>-----Original Message-----From: Nick Wagner
[mailto:Nick.Wagner_at_quest.com]Sent: Friday, January 18, 2002 12:51
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
SPACE FREE HOW?
24x7... that does make it tough.. you might want to try
LiveReorg from Quest Software... it allows you to reorganize those
tables while users are still accessing them. It will even tell you which
tables to reorg to free up the most space... without even deleting data.
you can find out info about the products at
www.quest.com/livereorg
you can even get a free trial version to test it out, and make
sure it is what you need.
Nick
-----Original Message----- From: Seema
Singh [<A
href="mailto:oracledbam_at_hotmail.com">mailto:oracledbam_at_hotmail.com]
Sent: Friday, January 18, 2002 7:41 AM <FONT
size=2>To: Multiple recipients of list ORACLE-L <FONT
size=2>Subject: RE: SPACE FREE HOW?
Ethan The database is in production
and users are accesing 24x7.What will be best approach
to do? DO u have any scripts how to find HWM?
Thanks -Seema
>From: "Post, Ethan" <Ethan.Post_at_ps.net>
>Reply-To: ORACLE-L_at_fatcity.com <FONT
size=2>>To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com> >Subject: RE: SPACE
FREE HOW? >Date: Thu, 17 Jan 2002 14:25:37
-0800 > >Deleting
records from a table does not free up space in the database. <FONT
size=2>>Search for high water mark in the concepts manual and you should
find an >explanation of how this works. The
statement below only frees up space >above the high
water mark on the table. > <FONT
size=2>>You can... > <FONT
size=2>>create table foo nologging as (select * from big_table);
> >truncate table
big_table; > >insert
into big_table (select * from foo); >
>drop table foo; >
> >-Ethan <FONT
size=2>> >-----Original Message-----
>Sent: Thursday, January 17, 2002 3:27 PM <FONT
size=2>>To: Multiple recipients of list ORACLE-L <FONT
size=2>> > >ALTER
TABLE table DEALLOCATE UNUSED KEEP integer; >the
keep clause is optional. > <FONT
size=2>>-sunil > <FONT
size=2>>-----Original Message----- >Sent:
Thursday, January 17, 2002 2:58 PM >To: Multiple
recipients of list ORACLE-L > <FONT
size=2>> >Hi >I
deleted millions of rows from diffrent tables and I have not seen any
>impact on database size.What I have to do to get that
free space? >Is it necessary to shutdown the
database? >Thx <FONT
size=2>>-Seema > <FONT
size=2>>-- >Please see the official ORACLE-L
FAQ: <A target=_blank
href="http://www.orafaq.com">http://www.orafaq.com <FONT size=2>>-- >Author: Post, Ethan <FONT size=2>> INET: Ethan.Post_at_ps.net <FONT size=2>> >Fat City Network
size=2>>--------------------------------------------------------------------
size=2>_________________________________________________________________Get your FREE download of MSN Explorer at <A target=_blank href="http://explorer.msn.com/intl.asp">http://explorer.msn.com/intl.asp.
 |
 |