Oracle-L: RE: Transportable Tablespaces

From: Martin, Alan (Contractor) (DLIS) <Alan.S.Martin_at_dla.mil>
Date: Fri, 10 Oct 2003 12:09:24 -0800
Message-ID: <F001.005D2B86.20031010120924@fatcity.com>

Just be aware of an undocumented "feature" in 8i (8.1.7.2 for me). Once you transport a tablespace from DB-A to DB-B, you can't transport (the same TS) from DB-B to DB-C. There are some internal issues preventing the re-transport. I believe this is fixed in 9i.

Regards,
Alan Martin
DBA - Defense Logistics Info Service

-----Original Message-----
Sent: Friday, October 10, 2003 3:49 PM
To: Multiple recipients of list ORACLE-L

You can reference the documentation at http://tinyurl.com/qhcl <http://tinyurl.com/qhcl> paying specific attention to the "Limitations". MetaLink documents 100693.1 and 77523.1 provide some helpful information as well.

-----Original Message-----
Sent: Friday, October 10, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L

Anyone got a "1, 2, 3" for using transportable tablespaces?

Got a client that thinks this might be a good solution to transfer large amounts of data.

This is HP/UX and should be 8.1.7.4...

Any gotchas that may kill this idea?

Thanks.

Michael Kline, Principal Consultant
Business To Business Solutions, LLC
Richmond, VA
804-744-1545

--

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

Author: Martin, Alan (Contractor) (DLIS) INET: Alan.S.Martin_at_dla.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Oct 10 2003 - 15:09:24 CDT