Hi Gurus.
Oracle has tablespace maxextents and table or index maxextents. Which one
oracle depend on?
thanks
Mitchell
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mitchell
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
Hello,
Read up on the hierarchy rules and you will see that if no specific
table/index parameters are set, then they default to the tablespace's
parameters.
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL PROTECTED]
-Original
Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: mitchell [SMTP:[EMAIL PROTECTED]]
Sent: Monday, January 14, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: tablespace default maxextents
Hi Gurus
'tablespace maxextents' is used as a default, when you don't explicitly
specify 'table or index maxextents'.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, January 14, 2002 1:25 PM
Hi Gurus.
Hi Mitchell,
The maxextents on the tablespace are applied as defaults to tables or
indexes that are created without an explicit maxextents value. An
explicit maxextents clause on the table or index level
will override the tablespace clause.
Hope this helps,
John
[EMAIL PROTECTED] wrote:
Hi
Oracle doesn't depend on maxextents. Oracle depends on the
sale of their software. As for the maxextents, it depends:
If maxextents is specified for the table, then the table level definition
will be used. If, not the tablespace level default will be used.
I believe that that is explained in the
