RE: recoving the temp tablespace

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Wed, 24 Mar 2004 09:07:59 -0500
Message-ID: <AFF54B073FF15849B53E32E67EE860763A7CBC@ENHBGPRI11.PA.LCL>

Well, good. This tightens up the operation a little bit. I didn't think it would let me drop the file before I created a new one. This is pretty convenient. Imagine it being easy and straight forward :^).

PINE-SYS> STARTUP
ORACLE instance started.

Total System Global Area            135339844 bytes
Fixed Size                             454468 bytes
Variable Size                       109051904 bytes
Database Buffers                     25165824 bytes
Redo Buffers                           667648 bytes

Database mounted.
Database opened.

PINE-SYS> ALTER DATABASE tempfile 'C:\OraHome1\oradata\pine\temp01.dbf' DROP;

Database altered.

PINE-SYS> ALTER TABLESPACE temp ADD tempfile 'C:\OraHome1\oradata\pine\temp01.dbf' SIZE 102400K autoextend OFF;

Tablespace altered.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Carel-Jan Engel Sent: Tuesday, March 23, 2004 4:26 PM
To: oracle-l_at_freelists.org
Subject: RE: recoving the temp tablespace

Donald,

You don't need a different one. You can just -re-create the original (not-resoterd, because not backed up) tempfile for the tablespace. The tablespace is there in the dictionary, just the tempfiles are missing. They can be added to the tablespace again.

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok) ===

At 11:19 PM 3/23/2004, you wrote:

Your database is going to be looking for the 'old' temp file. Create a new, different one. Drop the old one, recreate the old one, drop the new one. Is that too many 'olds' and 'news?' :-)

CREATE TEMPORARY TABLESPACE TEMP1
TEMPFILE 'F:\ORACLE\ORADATA\NEDSSARP\TEMP99.DBF' SIZE 2097152K AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL UNIFORM SIZE 4096K SEGMENT SPACE MANAGEMENT MANUAL
/

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP1
/

DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES
/

CREATE TEMPORARY TABLESPACE TEMP
TEMPFILE 'F:\ORACLE\ORADATA\NEDSSARP\TEMP01.DBF' SIZE 2097152K AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL UNIFORM SIZE 4096K SEGMENT SPACE MANAGEMENT MANUAL
/

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
/

DROP TABLESPACE TEMP1 INCLUDING CONTENTS AND DATAFILES
/

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 Wed Mar 24 2004 - 08:08:09 CST