Home » RDBMS Server » Server Administration » How to make a temporary tablespace read only? (Oracle 9i WIndows XP)
How to make a temporary tablespace read only? [message #343718] Wed, 27 August 2008 22:34 Go to next message
ram_royalece@yahoo.co.in
Messages: 9
Registered: August 2008
Location: Chennai
Junior Member
When i try this query,

alter tablespace tablespace_name read only;

It throws an error msg. ORA-03217 invalid option for alter of temporary tablespace.

Why do i get this error? How to fix this? Pls do reply...
Re: How to make a temporary tablespace read only? [message #343719 is a reply to message #343718] Wed, 27 August 2008 22:36 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

>Why do i get this error?
Because it is invalid SQL


>How to fix this?
Stop issuing invalid SQL.
Re: How to make a temporary tablespace read only? [message #343722 is a reply to message #343718] Wed, 27 August 2008 22:41 Go to previous messageGo to next message
ram_royalece@yahoo.co.in
Messages: 9
Registered: August 2008
Location: Chennai
Junior Member
I know. You shut...
Re: How to make a temporary tablespace read only? [message #343728 is a reply to message #343718] Wed, 27 August 2008 23:33 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
Cause: invalid option for alter of temporary tablespace was specified
Action: Specify one of the valid options: ADD TEMPFILE, TEMPFILE ONLINE, TEMPFILE OFFLINE
Re: How to make a temporary tablespace read only? [message #343730 is a reply to message #343718] Wed, 27 August 2008 23:38 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
simply put, Oracle prevents (ab)user from changing a "TEMPORARY" tablespace to READONLY.
READONLY is NOT a valid option for TEMPORARY tablespace.
Previous Topic: Errors in run 'srvconfig -version '
Next Topic: ORA-07445: exception encountered
Goto Forum:
  


Current Time: Sun Dec 04 20:43:36 CST 2016

Total time taken to generate the page: 0.06305 seconds