alter tablespace offline

 

Hi,

 

This weekend I was migrating an oracle 7.3.4 environment to oracle 9.2.0.4 and we encountered

a strange problem in issueing alter tablespace name offline.

I had to reorganize tablespace and when testing this I did this manually and no problem at all.

I put the statements in a script.

 

Executing the script put the tablespace offlline

with exactly : alter tablespace name offline

Moving the file with os and then starting up the database in mount phase lead to the problem it would not do this.

 

Backtracking this to a test environment and rereading the docs lead me to that I should have used

alter tablespace name offline normal

 

I cannot remember whether I did this ok in the first tests but I might have copied it wrong into my script.

What is the problem in issueing a alter tablespace name offline so without the normal clause?

 

Details: HP-UX11.11, Oracle 9.2.0.4

 

Regards,

 

Jeroen

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeroen van Sluisdam
  INET: jeroen.van.sluisdam_at_vrijuit.nl

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).