RE: SPACE FREE HOW?

[Aponte, Tony]

Title: RE: SPACE FREE HOW?

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.

 

Tony Aponte

Home Shopping Network

-----Original Message-----
From: Nick Wagner [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 18, 2002 12:51 PM
To: Multiple recipients of list ORACLE-L
Subject: 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 [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 18, 2002 7:41 AM
To: Multiple recipients of list ORACLE-L
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" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>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.
>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.
>
>You can...
>
>create table foo nologging as (select * from big_table);
>
>truncate table big_table;
>
>insert into big_table (select * from foo);
>
>drop table foo;
>
>
>-Ethan
>
>-----Original Message-----
>Sent: Thursday, January 17, 2002 3:27 PM
>To: Multiple recipients of list ORACLE-L
>
>
>ALTER TABLE table DEALLOCATE UNUSED KEEP integer;
>the keep clause is optional.
>
>-sunil
>
>-----Original Message-----
>Sent: Thursday, January 17, 2002 2:58 PM
>To: Multiple recipients of list ORACLE-L
>
>
>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
>-Seema
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Post, Ethan
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California        -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).