With LMT, Oracle allocates extents the way the
tablespace was created even if you specify storage at
the table level.
- Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com> a
écrit : > HPUX 11i 64 bit
> Oracle 8.1.7.1 32 bit
>
> I am creating a new database and decided to go with
> locally managed
> tablespaces. I was going to go with autoallocate
> because the best I can
> tell the only possible drawback with this is a
> little wasted space.
> However, I was under the impression that you could
> not specify a next in the
> storage clause of a table creation. Yet you can.
> So what happens if I have
> a next defined? Do they pretty much just throw that
> away or should I really
> not define it?
>
>
>
> ________________________________
> Kimberly Smith
> Database Administrator
> IT Dept. - Fujitsu/GMD
> Phone: (503) 669-6050
> Fax : (503) 669-5705
> Email : kimberly.smith_at_gmd.fujitsu.com
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Kimberly Smith
> INET: kimberly.smith_at_gmd.fujitsu.com
>
> 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).
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com
Do You Yahoo!? -- Vos albums photos en ligne,
Yahoo! Photos :
http://fr.photos.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
INET: stephane_paquette_at_yahoo.com
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).
Received on Thu Jul 19 2001 - 11:22:01 CDT