Re: Looking for clarification

From: Jérôme Vitalis <vitalismanREMOVETHAT_at_gmail.com>
Date: Sat, 5 Nov 2005 21:22:23 +0100
Message-ID: <436d1481$0$4356$626a54ce@news.free.fr>

"Vince Laurent" <vincelaurent_at_REMOVETHISsbcglobal.net> a écrit dans le message de news: f04nm1lsls4rltto3ji8bmja8ifi8j4uso_at_4ax.com...
>I need to move a datafile from one disk to another. I am running
> Oracle 9.2.0.4 on HP-UX11. I have done it before one a test system
> where I could control the access. We run SAP and in the test system
> I could make sure there were no users BUT SAP was still up. The
> datafile move went uneventful.
>
> Now I need to do it to a production. What exactly happens if someone
> or something tries to access a table that is OFFLINE? This datafile
> move shouldn't take too long BUT I can't get 100% of the users out of
> SAP. Will thier transaction just fail? Hang? Get moved to the
> rollback/undo/whatever and wait for the table?

SAP will receive error ORA-00376. I don't know this app, but chances are high that it will handle this error simply by returning the error to the end user.

Jerome Received on Sat Nov 05 2005 - 14:22:23 CST