Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: decrease tablespace in 8.03

Re: decrease tablespace in 8.03

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 16 Jul 1998 16:57:07 GMT
Message-ID: <35b130b4.9960071@192.86.155.100>


A copy of this was sent to zoider_at_my-dejanews.com (if that email address didn't require changing) On Thu, 16 Jul 1998 15:25:50 GMT, you wrote:

>Is there any way to decrease tablespace size in version 8?
>
>It seems to me I saw something, once upon a time, somewhere in the online
>documentation but I can't find it again. Maybe it was one of those late night
>hallucinations.

you can shrink data files if nothing is allocated at the end of the datafile.

see the 'alter database' command for more info. by shrinking the files in a tablespace, you will shrink the tablespace itself...

>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  



Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Jul 16 1998 - 11:57:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US