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