RE: recoving the temp tablespace
- From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Mar 2004 09:07:59 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Carel-Jan Engel
Sent: Tuesday, March 23, 2004 4:26 PM
To: oracle-l@xxxxxxxxxxxxx
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
/
Other related posts:
