restore controlfile , and adding tempfile to temp tablespace [message #271526] |
Mon, 01 October 2007 18:20 |
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.
|
|
|
|
|
|
|