I've=20found=20the=20solution. SQL>=20alter=20database=20datafile =20=202=20=20'/oracle/PR2/sapdata5/el46cd_2/el46cd.data2' =20=203=20=20autoextend=20on=20maxsize=2010000m; Database=20altered. -----Original=20Message----- From:=20Roger=20Xu=20 Sent:=20Wednesday,=20May=2026,=202004=204:46=20PM To:=20Oracle-L@Freelists.=20Org=20(E-mail) Subject:=20how=20do=20I=20change=20the=20maxsize=20for=20a=20datafile? SQL>=3D20alter=3D20database=3D20datafile=3D20'/oracle/PR2/sapdata5/el46cd_= 3/el46cd=3D .data3'=3D20maxsize=3D2010000m; alter=3D20database=3D20datafile=3D20'/oracle/PR2/sapdata5/el46cd_3/el46cd.= data3'=3D =3D20maxsize=3D2010000m =3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D2= 0=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D =3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D2= 0=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D =3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D20=3D2= 0=3D20=3D20=3D20=3D20* ERROR=3D20at=3D20line=3D201: ORA-01916:=3D20keyword=3D20ONLINE,=3D20OFFLINE,=3D20RESIZE,=3D20AUTOEXTEND= =3D20or=3D20EN=3D D/DROP=3D20expected SQL> ************************************************************************ This=3D20e-mail=3D20is=3D20intended=3D20solely=3D20for=3D20the=3D20person=3D= 20or=3D20entity=3D20=3D to=3D20which=3D20it=3D20is=3D20addressed=3D20and=3D20may=3D20contain=3D20c= onfidential=3D20an=3D d/or=3D20privileged=3D20information.=3D20Any=3D20review,=3D20dissemination= ,=3D20copyin=3D g,=3D20printing=3D20or=3D20other=3D20use=3D20of=3D20this=3D20e-mail=3D20by= =3D20persons=3D20or=3D20=3D entities=3D20other=3D20than=3D20the=3D20addressee=3D20is=3D20prohibited.=3D= 20If=3D20you=3D20=3D have=3D20received=3D20this=3D20e-mail=3D20in=3D20error,=3D20please=3D20con= tact=3D20the=3D20s=3D ender=3D20immediately=3D20and=3D20delete=3D20the=3D20material.=3D20 ************************************************************************ This=3D20email=3D20has=3D20been=3D20scanned=3D20for=3D20all=3D20viruses=3D= 20by=3D20the=3D20Mes=3D sageLabs=3D20Email=3D20Security=3D20System.=3D20Any=3D20questions=3D20plea= se=3D20call=3D20=3D 972-721-8257=3D20or=3D20email=3D20your=3D20request=3D20to=3D20tech_support= @dp7uptx.com=3D . ---------------------------------------------------------------- Please=20see=20the=20official=20ORACLE-L=20FAQ:=20http://www.orafaq.com ---------------------------------------------------------------- To=20unsubscribe=20send=20email=20to:=20=20oracle-l-request@xxxxxxxxxxxxx put=20'unsubscribe'=20in=20the=20subject=20line. -- Archives=20are=20at=20//www.freelists.org/archives/oracle-l/ FAQ=20is=20at=20//www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- For=20technical=20support=20please=20email=20tech_support@xxxxxxxxxxx=20or= =20you=20can call=20(972)721-8257.=20 This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes= sageLabs=20Email=20Security=20System. ************************************************************************ 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 -----------------------------------------------------------------