Re: exp/imp tables to new tablespace name

Try ignore=y. I think this will cause the table to be created in the users default tablespace if the tablespace from the former database does not exist

Cheers,
John.

Jan Oksfeldt Jonasen wrote:

> I've been trying to export (with exp) some tables from one database
> server to another. I think I have done the export correctly however when
> importing it, Oracle won't create all the tables, since it cannot find a
> tablespace with the same name (smt) as in the former database. All I
> want to do is export tables and primary key constraints, notthing else
> is needed. Which switches should I give to exp and imp so they wont
> think about tablespace names?
>
> --
> Mvh/re Jan Jonasen
> jonasen (at) it (dot) dk
>
> You'll get two operating systems in one! (Kommende reklame slogan)
Received on Thu Mar 22 2001 - 04:08:21 CET