Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Import

Re: Import

From: Bernard Polarski <bpolarsk_at_my-deja.com>
Date: Wed, 08 Dec 1999 10:33:40 GMT
Message-ID: <82lc65$tdo$1@nnrp1.deja.com>


Why not considering the following :

   -copy table B in B2
   -recreate B as A, B is empty
   -Load export  A into B (the struct is the same)
   -insert (field list) from B into B2
   -drop B
   -rename B2 to B


  "Sybrand Bakker" <postmaster_at_sybrandb.nospam.demon.nl> wrote:
> 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 ?
> >
> >
> >
>
>

--
Regards

B.Polarski
Email : bpolarsk_at_yahoo.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 08 1999 - 04:33:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US