Re: Transportable tablespaces within the same database

On Jun 12, 10:54 am, "jms.n..._at_gmail.com" <jms.n..._at_gmail.com> wrote:
> On Jun 9, 3:12 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
>
>
>
> > "J" <n..._at_noone.org> a écrit dans le message denews: 466a2d19$0$17156$afc38..._at_news.optusnet.com.au...
> > | "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> > |
> > | >
> > | > <jms.n..._at_gmail.com> a crit dans le message de news:
> > | > 1181278817.166749.65..._at_i13g2000prf.googlegroups.com...
> > | > | Instead of transporting a tablespace between 2 databases .... can one
> > | > | transport the tablespace to the same database to essentially "restore"
> > | > | a tablespace to the state when the datafiles were copied ?
> > | > |
> > | > | e.g.: Assuming I have only one user that owns objects in the
> > | > | tablespace(s):
> > | > |
> > | >
> > | > And the purpose is?
> > |
> > | You did not read the first part of the post ? The OP says to "restore" a
> > | tablespace to the state when the datafiles were copied.
>
> > I meant what is the purpose to use TTS instead of "rename".
>
> 1) Tablespace rename only works with Oracle10g.
>
> 2) Even if I was using 10g, you still have to use a transportable
> tablespace, dont you ?
>
> jms

I was finally able to import the tablespace within the same database, using the steps I outlined in the OP. However, I also needed to drop the tablespaces before doing the import.

I did get a few errors though about:

IMP-00093: Inconsistency between dumpfile constraint definition for table XXX with columns ("yyyy" )

IMP-00003: ORACLE error 1925 encountered
ORA-01925: maximum of 30 enabled roles exceeded
IMP-00000: Import terminated unsuccessfully

... which I ignored.

However, the problem that I am facing now is that all of the user's sequences were NOT imported!, whereas if I do an expport/import for the user, the sequences are imported. Aren't sequences stored in the user's default tablespace ? Received on Tue Jun 12 2007 - 18:46:14 CDT