Home » RDBMS Server » Backup & Recovery » restore controlfile , and adding tempfile to temp tablespace
restore controlfile , and adding tempfile to temp tablespace [message #271526] Mon, 01 October 2007 18:20 Go to next message
prince973
Messages: 37
Registered: November 2006
Member
hi all,
i have read in many web pages that if u restore controlfile from autobackup and u have locally managed tablespace u need to add tempfile to temporary tablespace , or u will get an error if u try to make sort sql statement.
on my db, i have locally managed temp tbs, and i restored controlfile from autobackup , i didn't add any new tempfile to temp tablespace, i made sql containing sort , i didn't get error, and every thing went fine , my question is why they advise for adding tempfile if there is no problem ,
what is ur idea,
thanks for reading.
Re: restore controlfile , and adding tempfile to temp tablespace [message #271530 is a reply to message #271526] Mon, 01 October 2007 21:44 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
if u restore controlfile from autobackup and u have locally managed tablespace u need to add tempfile to temporary tablespace


From where you got this information? It's not true.
Re: restore controlfile , and adding tempfile to temp tablespace [message #271650 is a reply to message #271530] Tue, 02 October 2007 06:09 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Arju wrote on Mon, 01 October 2007 22:44
Quote:
if u restore controlfile from autobackup and u have locally managed tablespace u need to add tempfile to temporary tablespace


From where you got this information? It's not true.

It was true for versions prior to 10gR2.
Re: restore controlfile , and adding tempfile to temp tablespace [message #271772 is a reply to message #271526] Tue, 02 October 2007 19:47 Go to previous messageGo to next message
prince973
Messages: 37
Registered: November 2006
Member
thanks ebrian.
appreciated.
Re: restore controlfile , and adding tempfile to temp tablespace [message #271781 is a reply to message #271526] Tue, 02 October 2007 21:57 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Thanks Brian. I started my Oracle era after 10.2.0.2
Previous Topic: lost system tablespace datafile in oracle8i
Next Topic: EXP-00056:Oracle error 31600
Goto Forum:
  


Current Time: Fri Nov 29 19:07:48 CST 2024