Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

export an insert

Cds MAXOct 28 2022 — edited Oct 28 2022

Hi,
On 11.2.0.4 using SQL DEV version 19.2.1.247 Build 247.2212
I create table B as select * from Table A.
Then run select * from A and export the result in an insert format file.
I delete all rows in B and execute insert file in sqlplus. The rows are inserted in B. But when I compare them:

select * from tableA
minus
select * from tableB

many/all rows are returned. The data is not exactly the same.
What is wrong with my action?
Thanks.

This post has been answered by L. Fernigrini on Nov 7 2022
Jump to Answer
Comments
Post Details
Added on Oct 28 2022
10 comments
463 views