Re: Import

It will not work.
If you don't specify ignore=y, imp will simply not create it, and do nothing.
If you specify ignore=y, imp will skip the create and insert into the old table.
As the column definitions changed, this will most likely fail. In other words, you need either to drop the table or setup a database link between those two databases and design a conversion script.

Hth,

--
Sybrand Bakker, Oracle DBA
Stefan Jahnke <s.jahnke_at_luw-ag.de> wrote in message news:384CEAA3.2633E630_at_luw-ag.de...
> Hi,
>
> Is it possible to do the following:
>
> Database A, table A already exists.
>
> Database B, table A is created, with the same structure as in Database
> A.
>
> Now I change the structure of table A, I recreate it, some columns are
> added, others are gone.
> Next, I export table A from database A and import it into the new table
> A in database B. Could this possibly work somehow ?
> What import parameters do I have to consider ?
>
> TIA
> Stefan
>
> PS: It seems to be problematically to use Oracle 7.3 export files with
> Oracle 8.0.5 import. Is this true ?
>
>
>
Received on Tue Dec 07 1999 - 12:40:42 CST