RE: Transportable tablespaces violation question

From: Fred Smith <fred_fred_1_at_hotmail.com>
Date: Wed, 21 Feb 2007 15:19:03 -0500
Message-ID: <BAY132-F29B43AD4664FC4D568F458FE880@phx.gbl>

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_at_cable.comcast.com>
>To: <fred_fred_1_at_hotmail.com>
>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_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fred Smith
>Sent: Wednesday, February 21, 2007 10:12 AM
>To: oracle-l_at_freelists.org
>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
>
>--
>http://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

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

Received on Wed Feb 21 2007 - 14:19:03 CST