Locally managed tablespaces

From: Docherty, Heather <H.Docherty_at_napier.ac.uk>
Date: Fri, 14 Dec 2001 07:55:57 -0800
Message-ID: <F001.003DCADB.20011214065520@fatcity.com>

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: H.Docherty_at_napier.ac.uk

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 Fri Dec 14 2001 - 09:55:57 CST