Not a dumb question, I should have specified it ... I am trying to transport the 2 tablespaces. The tablespace's names <name> is what I did for the e-mail, it does actually specify the tablespace names in question.
I was just worried that I can't transport tablespaces that show errors in transport_set_violations, even if I transport the 2 tablespaces in question. It sounds like I can do it though??
Thanks!
From: "Fenstermacher, Robert" <Robert_Fenstermacher@xxxxxxxxxxxxxxxxx> To: <fred_fred_1@xxxxxxxxxxx> Subject: RE: Transportable tablespaces violation question Date: Wed, 21 Feb 2007 11:07:14 -0700 Hi Fred- Dumb question, but you are trying to transport the two tablespaces together, right? A transport set of tablespaces must be self-contained, so specify both tablespaces in the exp command line (or .par file) Exp file=exp_tts.dmp log=exp_tts.dmp transport_tablespace=y tablespaces=(data_tablespace_name, index_tablespace_name) HTH Robert -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Fred Smith Sent: Wednesday, February 21, 2007 10:12 AM 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
_________________________________________________________________Want a degree but can't afford to quit? Top school degrees online - in as fast as 1 year http://forms.nextag.com/goto.jsp?url=/serv/main/buyer/education.jsp?doSearch=n&tm=y&search=education_text_links_88_h288c&s=4079&p=5116
-- //www.freelists.org/webpage/oracle-l