Re: Export/Import problem...

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

Should be able to set up User1 in the Target to have default tablespace TS_B with quota UNLIMITED, and if there is a tablespace TS_A then make sure that User1 has quota 0 (zero) on it -- and do the import.

Good luck.
- sooz Received on Thu Oct 08 1998 - 00:39:57 CDT