Topic: Database Administration >> Tempfile offline
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Navi |
Posted: Jun 29, 2007 04:27:26 AM |
Total Post: 60
Joined: Jun, 2007
|
Hi,
I searched a lot but i dint got the answer fo this qouestion. Please any on help me out in this question.
1) Why we cant bring tablespace offline?
2) Why we can bring tempfile offline?
Regards,
Naveen |
|
|
 Vigyan |
| Posted: Jun 29, 2007 10:54:37 AM |  |
|
Total Post: 386
Joined: May, 2001
|
There is no need to take TEMP tablespace or TEMP files offline if they are locally managed.
The tempfiles does not have any reference in the data dictionary. The information in the temp files used and destroyed every time you start up and shut down the database.
Hope it helps.
Vigyan
|
|
|
|
|
| KS |
| Posted: Jul 02, 2007 11:56:57 PM | |
|
Total Post: 60
Joined: Nov, 2006
|
Navi,
we can bring the Tablespace offline.
Use ,
ALTER TABLESPACE <TABLESPACE_NAME> OFFLINE;
But you can't bring a datafile OFFLINE unless Media recovery is enabled.
thanks,
Sri
|
|
|
|
|
| KS |
| Posted: Jul 09, 2007 06:29:42 AM | |
|
Total Post: 60
Joined: Nov, 2006
|
Navi,
Go through this,
Taking Default Temporary Tablespace Offline :
Tablespaces are taken offline to make that part of the database unavailable to other users (for example, an offline backup, maintenance, or making a change to an application that uses the tablespace). Becuase none of these situations apply to a temporary tablespace, you cannot
take a default temporary tablespace offline.
Source : Oracle DBA Fundamentals Volume -I
-- Sri.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
