Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: shutdown abort to move data files
Much better to do
shutdown abort
startup restrict
shutdown immediate
and then copy your datafiles...
HTH,
Regards
rafiq
From: "Nguyen, David M" <david.m.nguyen_at_xo.com>
Reply-To: oracle-l_at_freelists.org
To: <oracle-l_at_freelists.org>
Subject: shutdown abort to move data files
Date: Thu, 8 Jul 2004 11:48:27 -0400
I need to shutdown oracle8i database to move data file to another disk but it takes about 40 minutes to shutdown immediate. Can I go ahead to issue "shutdown abort" then move data file? Does it hurt anything?
Thanks,
David