> SQL>=20alter=20database=20datafile=20'/oracle/PR2/sapdata5/el46cd_3/el46cd= > .data3'=20RESIZE=2010000m; ;) Regards, Navneet ----- Original Message ----- From: "Roger Xu" <roger_xu@xxxxxxxxxxx> To: "Oracle-L@Freelists. Org (E-mail)" <oracle-l@xxxxxxxxxxxxx> 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@xxxxxxxxxxx= > . > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------