From: raju_pillai@yahoo.com
Subject: Re: export/import
Date: 2000/03/03
Message-ID: <89objo$b49$1@nnrp1.deja.com>#1/1
References: <89m74a$pr1$1@nnrp1.deja.com> <38BECAA6.556B8ECB@Unforgetable.com>
X-Http-Proxy: 1.1 x25.deja.com:80 (Squid/1.1.22) for client 64.38.26.200
Organization: Deja.com - Before you buy.
X-Article-Creation-Date: Fri Mar 03 12:36:07 2000 GMT
X-MyDeja-Info: XMYDJUIDraju_pillai
Newsgroups: comp.databases.oracle.server
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)


what if my table does not have a unique key or unique index and so it
can contain duplicate records inserted by applications. I read in the
book that, i can do reord using export/import, if i am doing that in
this case, then I may have double records each time, i reorg it. Is
there any other way to do the export/import without having to insert
duplicate rows ?

Any help is appreciated.

Thanks




In article <38BECAA6.556B8ECB@Unforgetable.com>,
  K Stahl <BlueSax@Unforgetable.com> wrote:
> raju_pillai@yahoo.com wrote:
> >
> > Folks, I am trying to user export and import as a mode of backing up
> > data for the tables owned by a specific user. But when I import the
 data
> > back to the tables, I get duplicate rows. How can I eliminate this ?
> > Below are the example of export and import commands I am using :
> > EXPORT:
> > exp system/manager rows=y consistent=y grants=n indexes=n
 constraints=n
> > owner=X file=/oraclebackup/plvwdbX.bkp record=y
> >
> > IMPORT:
> > imp system/manager file=/oraclebackup/plvwdbX.bkp rows=y grants=n
> > indexes=n touser=X fromuser=X ignore=y
> >
> > What am i missing here ?
> >
> > Thanks
> >
> > Raju
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> You need to have a unique key on each table and you need a unique
 index.
> You should go ahead and export tables, rows, grants and constraints.
 If you
> perform an import you will receive errors for dup val on index, but
 you can
> ignore these messages.
>
> Otherwise what you need to do is truncate the table before you do the
> import.
>


Sent via Deja.com http://www.deja.com/
Before you buy.