Re: how do I change the maxsize for a datafile?

From: Navneet Gupta <draki_in_at_hotmail.com>
Date: Thu, 27 May 2004 09:52:14 +0530
Message-ID: <BAY18-DAV49BGTuAyHs000078d2@hotmail.com>

>

SQL>=20alter=20database=20datafile=20'/oracle/PR2/sapdata5/el46cd_3/el46cd=
> .data3'=20RESIZE=2010000m;

;)
Regards,
Navneet

• Original Message ----- From: "Roger Xu" <roger_xu_at_dp7uptx.com> To: "Oracle-L_at_Freelists. Org (E-mail)" <oracle-l_at_freelists.org> Sent: Thursday, May 27, 2004 3:16 AM Subject: how do I change the maxsize for a datafile?

>
>

SQL>=20alter=20database=20datafile=20'/oracle/PR2/sapdata5/el46cd_3/el46cd=
> .data3'=20maxsize=2010000m;
>

alter=20database=20datafile=20'/oracle/PR2/sapdata5/el46cd_3/el46cd.data3'=
> =20maxsize=2010000m
>

=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
>

=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=
> =20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20*
> ERROR=20at=20line=201:
>

ORA-01916:=20keyword=20ONLINE,=20OFFLINE,=20RESIZE,=20AUTOEXTEND=20or=20EN=
> D/DROP=20expected
>
>
> SQL>
>
> ************************************************************************
>

This=20e-mail=20is=20intended=20solely=20for=20the=20person=20or=20entity=20 =
>

to=20which=20it=20is=20addressed=20and=20may=20contain=20confidential=20an=
>

d/or=20privileged=20information.=20Any=20review,=20dissemination,=20copyin=
>

g,=20printing=20or=20other=20use=20of=20this=20e-mail=20by=20persons=20or=20 =
>

entities=20other=20than=20the=20addressee=20is=20prohibited.=20If=20you=20=
>

have=20received=20this=20e-mail=20in=20error,=20please=20contact=20the=20s=
> ender=20immediately=20and=20delete=20the=20material.=20
> ************************************************************************
>

This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes=
>

sageLabs=20Email=20Security=20System.=20Any=20questions=20please=20call=20=
>

972-721-8257=20or=20email=20your=20request=20to=20tech_support_at_dp7uptx.com=
> .
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed May 26 2004 - 23:16:07 CDT