Transportable Tablespaces

From: <Marmdba_at_aol.com>
Date: Tue, 07 May 2002 13:28:44 -0800
Message-ID: <F001.0045A992.20020507132844@fatcity.com>

Hi all,

I would like to use transportable tablespaces to refresh a selected tablespaces from a production environment. The problem is that I cannot put the production tablespaces into read-only mode. Has anyone tried putting the tablespaces in hot backup mode then exporting, copying datafiles?

One schema is currently being refreshed from the production environment using exp/imp method but it is taking too long. I am also considering a clone from a hot backup and dropping the tablespaces not needed for refresh.

Any other ideas/suggestions are appreciated.

TIA,
Michele Armstrong
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Marmdba_at_aol.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 Tue May 07 2002 - 16:28:44 CDT