BUT:
see:Note:1029252.6
But there cannot be object stored in the end of the file!
> -----Urspr=FCngliche Nachricht-----
> Von: Marin Dimitrov [SMTP:marin_at_sirma.bg]
> Gesendet am: Donnerstag, 20. Juli 2000 10:55
> An: Multiple recipients of list ORACLE-L
> Betreff: Re: Resizing datafiles
>=20
> > Is it possible to resize a temp datafile (in a temp tablespace)
> > to a smaller size? What would be the syntax? Would it have
> > any negative effects to do that?
>=20
> To resize the file to 15 MB u can execute
>=20
> ALTER DATABASE DATAFILE '/path/to/file/temp01.dbf' RESIZE 15M;
> =20
>=20
> hth,
>=20
> Marin
>=20
> ------------
>=20
> "The important thing for all of us is never look *at* the bars, look
> *through* them. Because if you keep looking *at* bars, you'll never =
get
> anything done, and you'll never have fun in life, any joy."
>=20
> William Wharton, =
"Pride"
>=20
>=20
> --=20
> Author: Marin Dimitrov
> INET: marin_at_sirma.bg
>=20
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Jul 20 2000 - 04:41:11 CDT
