RE: Oracle 7.3.4 - woes deepen, pls advise

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 5 Aug 2004 09:19:48 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DE4A@usahm018.exmi01.exch.eds.com>

First, select * from v$recover_file to verify the recovery is complete

Second, verify the problem tablespace is online

Third, determine what the tablespace is "full" of. If only temporary segments remain then cycling the tablespace offline and online might clear it up. In this case you could also try to coalesce the tablespace: alter session set events 'immediate trace name coalesce level n' where n is the file#

Forth, if problems still persist then if the problem tablespace is dedicated to this one user's objects then drop tablespace x including contents

Finally you could try dropping individual objects in the tablespace.

HTH -- Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Denham Eva Sent: Wednesday, August 04, 2004 4:49 PM To: oracle-l_at_freelists.org
Subject: Oracle 7.3.4 - woes deepen, pls advise

Hello Folks,

My woes have deepened the server crashed on me.

The server has recovered fine, except that the user dose not exist anymore, however the tablespaces remain "full".

I have started to create new tablespaces for data and indexes. Will I be able to restore this users data or will the database still have object names etcetera in the dictionary?

This is with the idea of dropping the tablespaces at a later stage.

Regards

Denham

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Thu Aug 05 2004 - 08:16:32 CDT