List, I have a new server that I installed Oracle 8.1.7.3 with partitions and LMT. Some of the tables are quite large( in excess of 10 GIG) and I was creating the indexes when the communication channel was lost. Of course the rollback occurred but it was calculated to take in excess of 8 hours to complete. This was determined by "SELECT count(*) from dba_extents where segment_name = 'TEMP'; the answer was 104313. 5 minutes later the answer was 103849. I had thought that all would go as planned and went on vacatio--- for a week as planned. This is a new development server that I am trying to set up before creating the database for our production server. Later during the rollback I got the "snapshot to old" message. I'll live with it for now but the next day I received "can't allocate bytes in shared memory" error and SMON went to 100 % CPU and stayed that way for 4 days. The sysadmin suspended the SMON process while I was away. I returned today and shutdown the database with "shutdown abort", shutdown immediate hung. I restarted the database and all appeared well. I have a script that sums values in dba_free_space by tablespace_name and that appeared to be hung( not responding). I selected * from dba_free_space and the tablespace_name ='TEMP' had thousands of extents. I decided to halt the database and STARTUP MOUNT and ALTER DATABASE DATAFILE '...' OFFLINE DROP the datafile containing the TEMP tablespace. No problem as the database is not in archivelog mode. Then I open the database and DROP the TABLESPACE TEMP INCLUDING CONTENTS. This should allow me to create a new TEMP datafile and tablespace. The DROP TABLESPACE TEMP has been running for 4 hours now. I do not have exclusive use of the CPU as this server functions as a company production server for other processes besides Oracle.
My questions; About how long would you guess that the drop tablespace action should take to complete? How do I check the progress and can I stop the progress and pick up where it stopped ( the production people are nervous that it will not be done when they need the server) Does any one have an Oracle Database and other production functions on the same server using OpenVMS? Thanks, Ron ROR mô¿ôm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
