Re: Resolving TTS issues

From: Tim Gorman <tim_at_evdbt.com>
Date: Sun, 26 Dec 2004 20:17:32 -0700
Message-ID: <BDF4CCDC.21539%tim@evdbt.com>

Bryan,

Search the Oracle9i online documentation at

"http://www.oracle.com/pls/db92/db92.homepage" for the phrase
"transport_set_violations".  One of the links returned will refer to the
"Administrator's Guide" and a section on "Pick a Self-Contained Set of

Tablespaces" at
"http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/tspaces .htm#8927".

The basic idea is that every table in the tablespaces that you are transporting, as well as any indexes or partitions related to those tables, have to be "contained" within the set of tablespaces you are transporting. You have a choice -- either move the things that are "dangling" within the set, or enlarge the set. The table TRANSPORT_SET_VIOLATIONS tells you what is "dangling".

Visualize a roller-coaster ride: please keep all arms, legs, and other body parts inside the cab. Anything "dangling", not "self-contained", might just end up becoming "separated" during the ride, which means that the owner will not be good for much when the ride is over.

Hope this helps...

-Tim

on 12/23/04 1:38 PM, Bryan Wells at bunjibry_at_gmail.com wrote:

> Ive used the sys.dbms_tts.transport_set_check and SELECT * FROM
> SYS.TRANSPORT_SET_VIOLATIONS to identify issues in my transportable
> set. however, im not sure how to resolve the issues. Ive inherited
> this datawarehouse so im learning by fire the ways of the DBA. how to
> I get something to be contained, like an index, in the transportable
> set? rebuild the index as it has been a part of the partitioned table
> since it began?
>
> --
> Bryan S Wells - DBA Newbie
> bunjibry_at_gmail.com
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Dec 26 2004 - 21:44:53 CST