Re: please help me...
From: Reiner Perivolaris <tutlaibe_at_w250zrz.zrz.tu-berlin.de>
Date: 24 Jun 1994 20:10:17 GMT
Message-ID: <2ufej9$7jb_at_brachio.zrz.TU-Berlin.DE>
References: <CrJx3p.I7o_at_acsu.buffalo.edu> Sender:
Followup-To:
Distribution: world
Organization: /usr/news/lib/organisation Keywords: unique
Cc:
Date: 24 Jun 1994 20:10:17 GMT
Message-ID: <2ufej9$7jb_at_brachio.zrz.TU-Berlin.DE>
Newsgroups: comp.databases.oracle
Subject: Re: please help me... Summary: Expires:
References: <CrJx3p.I7o_at_acsu.buffalo.edu> Sender:
Followup-To:
Distribution: world
Organization: /usr/news/lib/organisation Keywords: unique
Cc:
Hi Qi Y. Zeng,
In article <CrJx3p.I7o_at_acsu.buffalo.edu>, Qi Y. Zeng <qizeng_at_acsu.buffalo.edu> wrote:
> When I use sqlplus, I find everything is duplicated.
> For example, when I type:
> SQL>help,
>every line comes out has a duplication right below it.
> When I type:
> SQL>select * from tablename
>the table will double its size because each record is
>duplicated.
... maybe You use EXP and IMP(!) and after IMP all records are duplicated. See Your IMP-manual for the parameters to overwrite existing records when IMPorting.
General I hope when You use CREATE UNIQUE INDEX ON <tablename>
the problem will be away in the future.
See Your SQL-book for DB-Administration ...
Gruss (german)
-Reiner-
-- reiner_at_physik.tu-berlin.de c=de; a=d400; p=tu-berlin; ou=physik; s=reiner --- "Wir haben die Aufgabe, den zentrifugalen Kraeften entgegenzuwirken."Received on Fri Jun 24 1994 - 22:10:17 CEST