Re: importing into a different tablespace

If you only have a few tables :

Pre-create the tables you want to move in the new tablespace and then import with "tables=(...,...) ignore=yes". The import will try to create the tables and, since they will already exists, will import the data into the existing one.

To pre-create the tables, use import with "show=y logfile=precreate.sql". Edit the "precreate.sql" to modify the original tablespaces name to new names and run the sql.

Regards,

Marc Mazerolle
InforMaze Technologies

Thomas Jork wrote:

> hi there
>
> i want to make an export from one oracle database and than import the
> tables, constraints, trigger and the data into another oracle database
> on a different computer. the problem is, that the tablespaces on these
> databases have different names. so, how can i induce oracle to to use
> the right tablespaces on the target database.
>
> thanks in advance
>
> tom
Received on Wed Jun 09 1999 - 08:58:49 CDT