Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export/Import problem...
Hi,
the create commands in the export-file contain the storage parameters, which obviously refer to the original tablespace and size. If you want to override these during the import, you have to create the table before the import.
greetings,
Thierry
DBA & System Manager for VTB-VAB
http://www.vab.be
Jimmy wrote in message <361B52B1.6ED26519_at_comp.polyu.edu.hk>...
>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 Thu Oct 08 1998 - 02:21:34 CDT