To: Multiple recipients of list ORACLE-L
Sent: Thursday, November 07, 2002 10:39 AM
Subject: Space management failures on autoextend datafiles
I have a 9.2 database running on Solaris 8. I'm creating some test tables with
indexes. The USER_INDX tablespace's datafile is set to autoextend
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
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
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 table
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
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
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
I have a 9.2
database running on Solaris 8. I'm creating some test tables with indexes. The
USER_INDX tablespace's datafile is set to autoextend (as are TEMP and
USER_DATA). When the system attempts to create indexes, instead of auotextending
the datafile (there is plenty of space on the
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-
recipients of list ORACLE-LSubject:
Space management failures on autoextend datafiles
I have a 9.2
database running on Solaris 8. I'm creating some test tables with indexes. The
USER_INDX tablespace's datafile is set to autoextend (as are TEMP and
USER_DATA). When the system attempts to create
-
From:
Fink, Dan
To: Multiple recipients of list ORACLE-L
Sent: Thursday, November 07, 2002 10:39
AM
Subject: Space management failures on
autoextend datafiles
I have a 9.2
database running on Solaris 8. I'm creating some test tables with indexes. The
USER_INDX
To: 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
[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 after the build
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 not
the only
-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
-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
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 list
17 matches
Mail list logo