Re: Autoextending Datafile
Date: 1996/05/20
Message-ID: <4nq9ks$1lrq_at_mule1.mindspring.com>#1/1
Your statement should work. The error message seems to tell me that you do not have 7.2 (or greater) installed. The autoextend feature was not around before 7.2. My error 01916 says keyword online, offline, resize, autoextend, or end expected.
jolsen
jolsen_at_mindspring.com
"Joseph Y. Suh" <josephs_at_clientlink.com> wrote:
>I am trying to autoextend current datafile by
>alter database datafile '/oracle/xxx.dbf' autoextend on maxsize
>unlimited;
>getting error message
>ORA-01916: ONLINE keyword or OFFLINE keyword expected.
>same error message when I try to resize a datafile.
>TIA
>Joseph Suh
>Oracle DBA
>ClientLink
>Alpharetta, Georgia
>USA
>josephs_at_clientlink.com.usa
Received on Mon May 20 1996 - 00:00:00 CEST