REPOST: Re: transportable tablespaces - violation explanation needed

Aha - it's actually a MASTER table from the dba_snapshots view - although I dropped the snapshots listed in the violations, these tables had other snapshots on them. As soon as I dropped the snapshots it cleared.

Thanks.

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<3c2ac56d$0$24018$afc38c87_at_news.optusnet.com.au>...
> Who's the owner of the table TEST_DATA_01?
>
> If the transport set contains anything owned by SYS, it won't transport, and
> the export process will bomb out with highly informative error messages such
> as this one.
>
> Other things to check are that you're not trying to transport just some
> partitions of a table or index, that there are no bitmap indexes involved
> and so forth.
>
> You can run the dbms_tts.transport_set_check package to populate a view
> (from memory, it's called transport_check_violations) which may provide you
> with more useful information about what is going wrong.
>
> Regards
> HJR.
>
>
>
>
> "Andy" <enzoweb_at_hotmail.com> wrote in message
> news:8d4033cd.0112261744.2cfd364d_at_posting.google.com...
> > I am trying to create a transportable tablespace set and when I run
> > the procedure get some violations. Some are easy to figure out, but
> > what about the ones which say
> > "Master table ORACLE.TTS_TEST in tablespace TEST_DATA_01 not allowed
> > in transportable set"?
> >
> > Why isn't it allowed, and how can I fix it?
> >
> > Thanks,
> >
> > Andy Horne

• WAS CANCELLED BY =======: Path: news.sol.net!spool1-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r From: enzoweb_at_hotmail.com (Andy) Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server Subject: cmsg cancel <8d4033cd.0112272000.5772c96d_at_posting.google.com> Control: cancel <8d4033cd.0112272000.5772c96d_at_posting.google.com> Date: Mon, 31 Dec 2001 08:56:41 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.8d4033cd.0112272000.5772c96d_at_posting.google.com> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009790217 28060 166.102.15.34 (31 Dec 2001 09:16:57 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 31 Dec 2001 09:16:57 GMT X-No-Archive: yes Comment: Anarchy! Fuck You! X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1 X-Unacanc3l: yes

This message was cancelled from within Mozilla...not Received on Thu Dec 27 2001 - 22:00:28 CST