Re: importing new fields without destroying data

Your export contains create table statements, not alter table statements. As your tables already exist, a subsequent create table will simply not get executed.
This will mean for any 'altered' table, the import will fail completely. You need to pre-create the changed tables in the new database.

Hth,

Sybrand Bakker, Oracle DBA

"andrew phuong" <caop_at_infosci.com.au> wrote in message news:IN6K5.24$f86.3868_at_vic.nntp.telstra.net...
> Hi All,
>
> I have a database and a new database dump file (exp ...rows=n)
> Now this new database dump file may contained new constraints and fields
 for
> some
> of the tables..
> My question is, is it possible to import these new columns and constraints
> in
> without destroying the data already on the database?
>
> Thankyou in advance.
>
> Andrew
>
>
Received on Fri Oct 27 2000 - 09:52:00 CDT