Heather - Is there a particular reason the consultant is doing this other
than maybe this is the first opportunity to learn this? Just my cynical
side. Mentioning cynical, I was leery of the procedure to convert an
existing dictionary-managed tablespace to a locally-managed one, but we
production DBAs tend to be a conservative lot. If you go that route, be sure
that you end up with uniform extents which I consider the best part of LMT.
Be sure to study the paper "How to Stop Defragmenting and Start
Living: The Definitive Word on Fragmentation" by Himatsingka and Loaiza.
before your consultant comes so that both of you agree on the approach to
take. This is available on Oracle's Web site. The worst circumstance (see
cynical above) would be for one person to create them and the other person
to maintain them, but each with a different philosophy.
I think LMT and uniform extents and extensible tablespaces are the
greatest features Oracle has added recently.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Friday, December 14, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L
I have just heard today that an external consultant, who is coming to
upgrade software for our Student Records system next week, wants to unload
the live, test and training databases, and recreate them using locally
managed tablespaces.
I've been reading all the incredibly positive things oracle have to say
about this, but has anybody any real experience of using locally managed
tablespaces, and if so, are there any major disadvantages or knock-on
effects that I should be aware of? Apart from trying to find disk space to
unload each database to do this, would it have any additional space
implications?
Basically, I need to decide if I should let this go ahead.
Heather
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Docherty, Heather
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
