Re: Resolving TTS issues

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@xxxxxxxxx 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@xxxxxxxxx
> --
> http://www.freelists.org/webpage/oracle-l
> 

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

Other related posts: