RE: REP: Locally Managed Tablespaces

Or tables were imported with compress=y? Or an alter index rebuild (into one extent for an index)? Anyone?

Scott Shafer
San Antonio, TX
210-581-6217

> -----Original Message-----
> From: Patricia Ashe [SMTP:pashe_at_TRUELINK.com]
> Sent: Tuesday, April 24, 2001 3:47 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: REP: Locally Managed Tablespaces
>
> I am doing some research on locally managed tablespaces prior to using
> them.
> Looking for problems, etc. This is the first negative response I have
> heard
> about them. Perhaps, storage parameters were specified on the create
> table?
>
> Patricia
> -----Original Message-----
> Sent: Tuesday, April 24, 2001 12:52 PM
> To: Multiple recipients of list ORACLE-L
>
> A couple of threads here and in other lists have mentioned this. A person
> puts LMTSs up and sets uniform extents on and sets it to, say 1M. Later
> they
> notice that not all extents are 1M.
>
> Thanks,
>
> Earl
>
> ---
>
> TheOracleDBA
> theoracledba_at_lycos.com
>
>
> On Mon, 23 Apr 2001 11:01:37
> Jared Still wrote:
> >On Monday 23 April 2001 11:40, The Oracle DBA wrote:
> >> Are you using uniform extents? We are told they are not really = and
> >> actually are not the same at all over time.
> >>
> >Do you have a source for this information? A number of us have been
> >using LMT's with uniform extents, and have not seen that.
> >
> >Jared
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Scott.Shafer_at_dcpds.cpms.osd.mil

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).