Hi Igor,
Glad you enjoyed Jonathan's talks! Next time, you'll have to join us at
his seminar which followed AAOUG and wrapped up yesterday! I'm actually
heading over to the hotel to pick him up and take hime to the airport in
a few minutes. It was a really great three days. I think all 24 peop
Hi Ron,
you're quite right and I'm pointing out that this functionality
(auto-extension of a file to accomodate a tempoary segment) works fine for
me.
That suggests that (bugs aside) temporary segments are quite capable of
forcing a datafile to extend.
The thrust of your earlier mail seemed to be
Mike,
In the previous discussion on this thread the problem was that the
autoextent would not work for a temp segment created during the index
creation and the problem was solved by extending the tablespace to
handle the temp segments.
Ron
>>> [EMAIL PROTECTED] 11/08/02 09:18AM >>>
Ron,
I don't
I just tried a cartesian product/sort and the TEMP tablespace, which is set
up as temporary and using a tempfile was able to autoextend. Of course, the
next step is to set up a TEMP tablespace as temporary using a datafile, then
permanent and see what happens...volunteers?
In regards to the issue
as i said. maybe temp segments don't cause autoextend :)
--- Ron Rogers <[EMAIL PROTECTED]> wrote:
> Let's think about this for a minute.
> You create and index called idx1 using a designated tablespace that
> has
> sufficient space to hold the complete index.
> You create a new index idx2 on the
Ron,
I don't believe all of that to be true.
In your example idx2 should be created and the tablespace should extend.
Otherwise what would be the point of having AUTOEXTEND on any tablespace
which held only indexes?
I agree that Oracle will use a temporary segment to hold the index data
until it i
Let's think about this for a minute.
You create and index called idx1 using a designated tablespace that has
sufficient space to hold the complete index.
You create a new index idx2 on the table using the same tablespace and
you think that it should autoextend to hold the permanent index.
The syst
maybe temp segments don't cause an autoextend?
at least it's consistent
--- "Fink, Dan" <[EMAIL PROTECTED]> wrote:
> Update... I tried the same test with 8.1.7 on Solaris 8. Same
> result...
>
> -Original Message-
> Sent: Thursday, November 07, 2002 1:09 PM
> To: Multiple recipients of
-Original Message-From: Igor Neyman
[mailto:[EMAIL PROTECTED]]Sent: Thursday, November 07, 2002
10:34 AMTo: Multiple recipients of list
ORACLE-LSubject: Re: Space management failures on autoextend
datafiles
Dan,
That's exactly, what someone desc
-Original Message-From: Igor Neyman
[mailto:[EMAIL PROTECTED]]Sent: Thursday, November 07, 2002
10:34 AMTo: Multiple recipients of list ORACLE-LSubject:
Re: Space management failures on autoextend datafiles
Dan,
That's exactly, what someone described yesterday, it was LMT
ECTED]
- Original Message -
From:
Fink, Dan
To: Multiple recipients of list ORACLE-L
Sent: Thursday, November 07, 2002 12:15
PM
Subject: RE: Space management failures on
autoextend datafiles
Igor
and Yechiel,
Thanks for the responses. I'm glad to hear that I am
Adar
[mailto:[EMAIL PROTECTED]]Sent: Thursday, November 07, 2002 9:35
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Space management failures on autoextend datafiles
Hi Paulo
When creating an index, or CTAS, oracle use temp
segments while building and rename them afte
: Multiple recipients of list ORACLE-L
Sent: Thursday, November 07, 2002 6:04
PM
Subject: RE: Space management failures on
autoextend datafiles
never heard on this problem but are u sure table the
temp tablespace of the user executing the commeand is temp and not
user_indx
I've heard about the same problem yesterday (while attending
Ann Arbor OUG conference), unfortunately - no solution, I think, they opened
TAR.
BTW, it was very good conference, great presentations by
Jonathan Lewis.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message ---
never
heard on this problem but are u sure table the temp tablespace of the user
executing the commeand is temp and not user_indx???
regards
Paulo
-Original Message-From: Fink, Dan
[mailto:[EMAIL PROTECTED]]Sent: quinta-feira, 7 de Novembro de 2002
15:39To: Multiple recipients
Dan,
is your datafile approaching (or past) the maxsize setting? AUTOEXTEND
functionality won't grow a file beyond this but I believe it's possible to
manuallly resize the file beyond the MAXSIZE figure.
That would explain the apparent anomaly.
regards,
Mike Hately
-Original Message-
Se
16 matches
Mail list logo