How to change maxsize of a datafile?

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Thu, 27 May 2004 13:36:51 -0500
Message-ID: <A6801E8A03316A4DA597866F77A013F702D4EE42@irv2kexch01>

We=20have=20two=20datafiles=20with=20autoextend=20ON and=20the=20maxsize=20were=20set=20to=2032=20GB.

SQL>=20select=20file_id,=20bytes/1024/1024=20mb,=20maxbytes/1024/1024,AUTO= EXTENSIBLE
=20=202=20=20from=20dba_data_files
=20=203=20=20where=20tablespace_name=20=3D=20'PSAPEL46CD';

=20=20=20FILE_ID=20=20=20=20=20=20=20=20=20MB=20MAXBYTES/1024/1024=20AUT

----------=20----------=20------------------=20---


=20=20=20=20=20=20=20=2035=20=20=20=20=20=20=201600=20=20=20=20=20=20=20=20=

=20=20=20=20=20=2010000=20YES
=20=20=20=20=20=20=20147=20499.992188=20=20=20=20=20=20=20=20=2032767.9844=
=20YES
=20=20=20=20=20=20=20148=20999.992188=20=20=20=20=20=20=20=20=2032767.9844=
=20YES
SQL> I=20just=20want=20to=20set=20the=20maxsize=20to=2010=20GB so=20that=20they=20do=20not=20grow=20more=20than=2010=20GB. How=20do=20I=20do=20this?

Thanks.

---

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
-----------------------------------------------------------------

Received on Thu May 27 2004 - 13:34:10 CDT