Re: decrease tablespace in 8.03

From: Joel Garry <joelga_at_pebble.org>
Date: Fri, 17 Jul 1998 23:54:21 GMT
Message-Id: <slrn6qvp32.hv3.joelga@pebble.org>

On Thu, 16 Jul 1998 11:29:46 -0700, Krishnan Ranganathan <krishnan_at_cdgpd.com> wrote:
>Hi,
>
>You should be able to do :
>
>alter database datafile 'path\filename' resize XXXXM;

Be sure you have a good backup first. I'm sure Oracle has fixed all the bugs, but I had a messup as recently as 7.3.4., with a resize larger (Before I had put any data in no less - no problem showed until I tried to create an index beyond that point [this was a tablespace for indexes]).

>
>/Krishnan
>
>
>
>

--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Fri Jul 17 1998 - 18:54:21 CDT