Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export/Import problem...
I don't think you can using import/export utilities. You have to either
use the
fromuser touser feature of the import where the new user1 has a default
tablespace of TS_B or you have to create the table ahead of time with the
tablespace
you want. You can get the actual SQL to create the table with a dummy
import
with indexfile=Y or something to get the create table command. Then,
change the
tablespace, create the table, and import it.
Jimmy wrote:
> Hello all,
>
> 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?
> The situation is as follows:
> (I don't want to use copy command to do this)
>
> Original Target
> ------- ------
> Table Name: T_A Table Name: T_A
> Tablespace: TS_A Tablespace: TS_B
> Instance: A Instance: B
> Owner: User1 Owner: User1
>
> Thanks,
> Jimmy
Received on Wed Oct 07 1998 - 12:14:16 CDT