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: cannot resize a tablespace

Re: cannot resize a tablespace

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Thu, 23 Sep 1999 16:40:02 GMT
Message-ID: <37ea57c9.181193042@news.earthlink.net>


import/export and precreate tables with needed storage parameters.

On Fri, 17 Sep 1999 11:29:14 +0200, "Jorge" <pumuky22_at_usa.net> wrote:

>I deallocate unused space of all tables but I cannot downsize datafile under
>lowest currently used block, but I have a datafile too much bigger, so, How
>can I defrag it or set the lowest currently used block acording to my amount
>of data???
>
>


Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Thu Sep 23 1999 - 11:40:02 CDT

Original text of this message

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