OraFAQ Forum: Server Administration » How to make a temporary tablespace read only?

Home » RDBMS Server » Server Administration » How to make a temporary tablespace read only? (Oracle 9i WIndows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to make a temporary tablespace read only? [message #343718]

Wed, 27 August 2008 22:34

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...

Report message to a moderator

Re: How to make a temporary tablespace read only? [message #343719 is a reply to message #343718]

Wed, 27 August 2008 22:36

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: How to make a temporary tablespace read only? [message #343722 is a reply to message #343718]

Wed, 27 August 2008 22:41

ram_royalece@yahoo.co.in
Messages: 9
Registered: August 2008
Location: Chennai

Junior Member

I know. You shut...

Report message to a moderator

Re: How to make a temporary tablespace read only? [message #343728 is a reply to message #343718]

Wed, 27 August 2008 23:33

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

Report message to a moderator

Re: How to make a temporary tablespace read only? [message #343730 is a reply to message #343718]

Wed, 27 August 2008 23:38

BlackSwan
Messages: 26766
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.

Report message to a moderator

Previous Topic:	Errors in run 'srvconfig -version '
Next Topic:	ORA-07445: exception encountered

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 16 13:43:22 CDT 2026