It depends.
If each row is distinct from the others, then
SQL> create table TEMPORARY1 as
SQL> select distinct * from TABLE_WITH_DUPLICATED_ROWS;
Jérôme Texier <jtexier_at_ystel.fr> a écrit dans le message :
7grg19$ev1$1_at_jaydee.iway.fr...
> Hello !
>
> I have load a table 2 times (there is no Unique key constraint). How can I
> delete my second load without delete my first load ?
>
> Please help me !
>
>
> ---------------
> Jérôme
> jt_at_ystel.fr
> ---------------
>
>
Received on Fri May 07 1999 - 12:08:08 CDT
