Home » Server Options » Streams & AQ » Please help me!
Please help me! [message #198242] Mon, 16 October 2006 04:49
v_piti
Messages: 2
Registered: October 2006
Location: Bucharest
Junior Member

I have a problem
: For the following instruction:
>
> insert into tabel1 select * from tabel2;
>
> If I have 1.000.000 of records which i must insert
> from tabel2 into tabel1 and it is an error.
> How could i detect where the error appears(at what
> rowid?)
>
> For example:
> Tabel1 has the records
> emp_id
> 1
> 2
> 3
> 4
> an error(NULL,PK)
> 6
>
> Tabel2 has the following structure
> emp_id number not null
>
> For the following instruction:
>
> insert into tabel1 select * from tabel2;
>
> It detect an error because an emp_id is NULL
>
> My question:
> How could I find out that the error appears at the
> 5th
> record.
Previous Topic: Error in DBMS_PROPAGATION_ADM.CREATE_PROPAGATION in Oracle 8i
Next Topic: Remove rule from the streams
Goto Forum:
  


Current Time: Thu Mar 28 11:22:48 CDT 2024