RE: Oracle 7.3.4 - woes deepen, pls advise
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 5 Aug 2004 09:19:48 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Denham Eva
Sent: Wednesday, August 04, 2004 4:49 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
