Re: Transportable tablespace doubts

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 19 Oct 2004 14:46:47 +1000
Message-Id: <41749c32$0$20126$afc38c87@news.optusnet.com.au>

Tho Nguyen wrote:

> Hi folks,
>
> I am familiar with exp/imp but never try transportable tablespace
> option before. I hope you guys may help to clear my doubts.
> Let's say I have tablespace A_1, that is self-contained. In that
> tablespace, I have data, indexes, etc of schema X. Now I tranfer that
> one to another database, so will Oracle create user X in the target
> database?
> I wish I could test it now but I can't.
> Thanks a bunch.

Off the top of my head, I recall doing demonstrations where the user had to pre-exist in the database. But that was a while ago in 8i.

So I've just had a look at a 10g dump file done with transport_tablespace=Y and one of the first lines I saw in it was 'CONNECT SCOTT'... unlike a conventional dump file, therefore, this one does not issue 'create user scott' commands before hand, even in 10g. And that means it won't create user X in the target database, and user X will have to be created, manually, by your good self, before you start.

Regards
HJR Received on Mon Oct 18 2004 - 23:46:47 CDT