Well, the tablespaces are not named, however, I believe what you need to do is grab all the tablespaces that are related together. What is not shown is if the 2 tablespaces (data & indexes tablespaces) are the same as <index_tablespace_name> and <data_tablespace_name>. If that is true, I don't know the answer, if not true then move the objects into one of the tablespaces you are moving as a group (data & indexes tablespace). Joel Patterson Database Administrator joel.patterson@xxxxxxxxxxx x72546 904 727-2546 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Fred Smith Sent: Wednesday, February 21, 2007 12:12 PM To: oracle-l@xxxxxxxxxxxxx Subject: Transportable tablespaces violation question I am trying to transport 2 tablespaces (data & indexes tablespaces) from 1 database to another. When I ran the DBMS_TTS.TRANSPORT_SET_CHECK and subsequently select from transport_set_violations, I see 5 violations that are all: Index <index> in tablespace <index_tablespace_name> enforces primary constraints of table <table_name> in tablespace <data_tablespace_name> How can I get around these violations? Thanks! _________________________________________________________________ The average US Credit Score is 675. The cost to see yours: $0 by Experian. http://www.freecreditreport.com/pm/default.aspx?sc=660600&bcd=EMAILFOOTE RAVERAGE -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l