Re: ORA-1597

From: Brian Peasland <oracle_dba_at_nospam.peasland.net>
Date: Tue, 23 May 2006 16:32:52 GMT
Message-ID: <Izq8Mx.Es8@igsrsparc2.er.usgs.gov>

BS wrote:
> alter system rollback segment offline accidently via OEM.
>

Everything should be just fine in your database. You cannot take the SYSTEM rollback segment offline and the ORA-1597 error is telling you just that. Your operation was aborted since it was an illegal operation.

No harm was done. Chalk it up to a learning experience...

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Tue May 23 2006 - 11:32:52 CDT