Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Transportable tablespace doubts

Re: Transportable tablespace doubts

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 18 Oct 2004 21:30:03 -0700
Message-ID: <1098160152.670509@yasure>


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.

  1. Oracle will not create a new user just because you transport a tablespace.
  2. Never do anything you can't test first.
-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Oct 18 2004 - 23:30:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US