Title: RE: decrease initial extent
Mladen,
Keep reading, it's further down.
From the 8.1.7 SQL Reference Manual, under the ALTER TABLE entry
(top of page 8-36):
"If you specify KEEP, then the specified amount of space is kept
and the remaining space is freed. When the remain
Title: RE: decrease initial extent
You are right, but:
In 8.1.6 doc the line next to the KEEP parameter
say:
KEEP: specify the number of bytes above the high water
mark the table will have after deallocation.
This let me to believe the deallocate will not shrink the
first extent.
The text
Thanks to all who replied.
Alter table/index deallocate keep 64k worked like a charm.
I did not checked it in depth but I think that it keep 64k from the actual
end of the data, not the high water mark.
When I read the manual about keep nk I was sure that it means above the high
water mark.
Yech
I don't understand. Here is what manual says:
deallocate_unused_clause
Use the deallocate_unused_clause to explicitly deallocate unused space at the end of
the table,
partition or subpartition, overflow data segment, LOB data segment, or LOB index and
make the
space available for other segment
For tables/indexes, the minimum initial extent size is 2 blocks (8k = 2*
4k). Block 0 contains the segment header, block 1 contains the data/index
entries.
Daniel Fink
[EMAIL PROTECTED] wrote:
Since
I agreed with Mladen that it wouldn't work, I just had to test this.On
8.1.7.3 on OpenVMS the "
Title: RE: decrease initial extent
Since
I agreed with Mladen that it wouldn't work, I just had to test
this.
On
8.1.7.3 on OpenVMS the "deallocate unused keep # " shrinks the initial
extent.
It
shrank a test table from 1m to 8k. I'm not sure why it chose
8
Title: RE: decrease initial extent
If you use "keep " it will.
Alex.
-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 03, 2003 12:59 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: decrease initial extent
That w
That will not do anything for the initial extent.
You may try with
alter table pray intensely for the desired change;
On 12/03/2003 03:34:25 PM, [EMAIL PROTECTED] wrote:
> alter table deallocate unused keep 1;
>
> Alex.
>
>
> -Original Message-
> Sent: Wednesday, December 03, 2003
Title: RE: decrease initial extent
Just for note, 10g has alter table shrink opportunity
:)
Tanel.
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, December 03, 2003 10:34
PM
Subject: RE: decrease
Title: RE: decrease initial extent
alter table deallocate unused keep 1;
Alex.
-Original Message-
From: Yechiel Adar [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 03, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L
Subject: decrease initial extent
Is there any
Yechiel, I thought that the mantra of oracle sales people was
"disks are cheap", which i very correct, especially when they
don't pay for the disks from their own pockets. What is measly
130M today? My son stores music in GB, not MB. Surely, you
company can afford an iPod sized disk?
On 12/03/20
Thank you.
OK. Another 130MB down the drain.
Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 03, 2003 8:49 PM
> You can move it after you convert the long field to LOB. As it is one
> of the system tables w
You can move it after you convert the long field to LOB. As it is one
of the system tables which appears in noexp$, it's not guaranteed that
your database will work afterward. OK, let me restate it: it's guaranteed
that it will not work. Other then that, it's only exp/imp of the full
database, and
Is there any way to decrease the initial extent allocated to a table.
It is one of the system tables, so I do not want to drop and recreate it.
I can not export/import as it appear in noexp$.
It has long field so I can not do alter table move.
Yechiel Adar
Mehish
--
Please see the official ORACLE
14 matches
Mail list logo
