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: Export/Import problem...

Re: Export/Import problem...

From: Stewart Burnett <Stewart_at_burnettms.nospam.demon.co.uk>
Date: Wed, 7 Oct 1998 13:08:13 +0100
Message-ID: <6vflja$4ak$1@hagen.cloud9.co.uk>

I think you need to import the table using an oracle user with default tablespace TS_B.

See Create User or Alter User commands.

Jimmy wrote in message <361B52B1.6ED26519_at_comp.polyu.edu.hk>...
>
> I have a problem about moving table from instance A to instance B.
> I export a table to a file test.dmp (in instance A, the table is in
>tablespace TS_A). I want to import this file to another instance B in
>tablespace TS_B. How can I do this with import utilities?
Received on Wed Oct 07 1998 - 07:08:13 CDT

Original text of this message

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