. I swear I saw it in the docs too. Anyone
back me up on this? - E
-Original Message-
From: DENNIS WILLIAMS
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 4:40 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Automanagement of extent sizing
!! Please do
!! Please do not post Off Topic to this List !!
I've been using LMTs in production systems since 1999 with no problems. I've
been doing uniform extents for (almost) everything (enforced through controlling
the DDL) since 1990 - and wouldn't have it any other way.
My strategy is simple - assign
[EMAIL PROTECTED]
.comcc:
Sent by: Subject: Re: Automanagement of extent
sizing
[EMAIL PROTECTED
cc:
Sent by: Subject: Re: Automanagement of extent
sizing
[EMAIL PROTECTED
!! Please do not post Off Topic to this List !!
Inline answers...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 14, 2001 7:45 AM
!! Please do not post Off Topic to this List !!
Don,
Just to confirm a point that I think
!! Please do not post Off Topic to this List !!
Prior to the advent of 8i, uniform extents had to be enforced through making
sure that every extent in a given tablespace was the same size by using
appropriate values in the storage clause in effect at the time of object
creation. The easiest
!! Please do not post Off Topic to this List !!
Cherie - We have been using the autoextend feature for 6 months now and have
been really pleased with it. I am now studying the Oracle White Papers on
the locally managed and uniform extent philosophy and beginning to follow
that scheme. I would
!! Please do not post Off Topic to this List !!
I am using it for some of my new databases and so far there are no
issues. I have long ago given up on caring how many extents there
will be. I only tend to size for tablespace sizing purposes. I had
no issues before hand and I have no issues
ORACLE-L
Subject: RE: Automanagement of extent sizing
!! Please do not post Off Topic to this List !!
Cherie - We have been using the autoextend feature for 6
months now and have
been really pleased with it. I am now studying the Oracle
White Papers on
the locally managed and uniform extent
!! Please do not post Off Topic to this List !!
Ethan - Can you use the SQL command ALTER TABLE MOVE? In a quick glance at
the documentation, it seems like you could probably use it on a table with a
LONG. Test it first, obviously.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
--
me up on this? - E
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 4:40 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Automanagement of extent sizing
!! Please do not post Off Topic to this List !!
Ethan - Can you use
, September 13, 2001 4:40 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Automanagement of extent sizing
!! Please do not post Off Topic to this List !!
Ethan - Can you use the SQL command ALTER TABLE MOVE? In a
quick glance at
the documentation, it seems like you could probably use
12 matches
Mail list logo
