You can't take your SYSTEM and TEMPORARY tablespaces offline

----- Original Message -----
From: "Hussein Korkomaz "
<oracledba-ezmlmshield-x43289352.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Saturday, June 30, 2007 4:55 PM
Subject: tablespace offline


> How can I make table space system offline
>
> I am trying to do like this but it is failed
>
>
>
> SQL> conn /as sysdba ;
>
> Connected.
>
> SQL> alter tablespace system offline immediate ;
>
> alter tablespace system offline immediate
>
> *
>
> ERROR at line 1:
>
> ORA-01541: system tablespace cannot be brought offline; shut down if
> necessary
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>


Oracle LazyDBA home page