Re: Cannot alter database datafile n offline immediate

From: Dino Hsu <dino1.nospam_at_ms1.hinet.net>
Date: Thu, 30 Aug 2001 10:17:19 +0800
Message-ID: <ff8rot0nm28plqqn4jvo51bgp3sm2qaafa@4ax.com>

On Wed, 29 Aug 2001 15:35:59 GMT, "Terry Dykstra" <dontreply_tdykstra_at_cfol.ab.ca> wrote:

>You need to specify the full filename:
>alter database datafile 'D:\ORACLE\ORADATA\O8I_TEST\USERS01.DBF' offline

SQL> alter database datafile 'd:\oracle\oradata\o8i_test\users01.dbf' offline immediate;
alter database datafile 'd:\oracle\oradata\o8i_test\users01.dbf' offline immediate

*
ERROR at line 1:
ORA-00933: SQL command not properly ended

If it is 'offline' without 'immediate', no problem, though.

Dino Received on Wed Aug 29 2001 - 21:17:19 CDT