Hello All,
I am unsure if similar question has already been posted to this group.
If so please point me to the relevant post/group.. otherwise please
read on...
We are in the process of migrating our application from Sybase to
Oracle. Basically for each table, we would do an bcp out of the table
and load it into oracle via sqlldr.
The source table has duplicate rows in it. However, we would not want
to ex****t those dupe rows to our oracle table.
My intention is to create a view that would pick up only the unique
records and I can bcp the data out of the view.
I can create a view something like
select distict * from sybase_table. However, I am worried about the
performance since I have heard that distinct clause is a costly
operation ( I am working on about 120-140 million rows ).
Is there a better way to achieve it?
Thanks in advance
Arun
