To:
[EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: ORA-1658 even
though there is enough contig free (SOLVED)
07/31/02 03:03 PM
Please respond
Jacques Kilchoer£¬
hi, i am sure it is because of the parallel clause.
If you use parallel, then oracle will allocate two 140M space for that index.
2002-07-30 16:43:00 You wrote:
Could it be because of the minimum extent size? Though I would think it
unlikely that your minimum
-1658 even though there is enough contig free
Rich,
1)Run following script to check fat size which will indicate
how big your
initial extent may be as you are not finding contigous space in your
tablespace. when it ask for value give your tablespace name..
undefine table_space
set verify
-Original Message-
From: Mohammad Rafiq [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 5:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-1658 even though there is enough contig free
Rich,
1)Run following script to check fat size which will indicate
how
/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: Mohammad Rafiq [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 5:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-1658 even though
recipients of list ORACLE-L
Subject: Re: ORA-1658 even though there is enough contig free
Rich,
1)Run following script to check fat size which will indicate
how big your
initial extent may be as you are not finding contigous space in your
tablespace. when it ask for value give your tablespace
PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-1658 even though there is enough contig free
Rich,
1)Run following script to check fat size which will indicate
how big your
initial extent may be as you are not finding contigous
space in your
tablespace. when
International, Sussex, WI USA
-Original Message-
From: Mohammad Rafiq [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 12:56 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-1658 even though there is enough contig free
That query give u perfect size in shape
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-1658 even though there is enough contig free
That query give u perfect size in shape of FAT_MB and that's
the maximun
size of intitial extent... I never relied on DBA_FREE_SPACE
Have you coalesed yr tablespace before and after
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 5:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-1658 even though there is enough contig free
Rich,
1)Run following script to check fat size which will indicate
how big your
initial extent may be as you
-Original Message-
From: Mohammad Rafiq [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 12:56 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-1658 even though there is enough contig free
That query give u perfect size in shape of FAT_MB and that's
Subject: RE: ORA-1658 even though there is enough contig free
That query give u perfect size in shape of FAT_MB and that's
the maximun
size of intitial extent... I never relied on DBA_FREE_SPACE
Have you coalesed yr tablespace before and after running this
query? Besides
Rich,
1)Run following script to check fat size which will indicate how big your
initial extent may be as you are not finding contigous space in your
tablespace. when it ask for value give your tablespace name..
undefine table_space
set verify off
prompt This script provides a report useful for
Title: RE: ORA-1658 even though there is enough contig free
Could it be because of the minimum extent size? Though I would think it unlikely that your minimum extent size would be greater than 147MB.
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
On 8.1.7.2.0
14 matches
Mail list logo