Boomarking

[gunjan14]

Hi,

Is there any bookmark facility available in Oracle? We are using Oracle 8.0.6.0.0.
The problem is
We are transforming data from some old tables to new tables. The table structure is changing. Now the problem is that during transformation, we will be using commit only after certain amount of records has been transformed. It can so happen that the custome ends the transformation before all the records from the old tables has been transformed. Then when the transformation is next started, is there any possiblity that we can start from where we have left. Else we have to delete some records from the new table and then do the transformation.
Any information on this will be a great help...

Gunjan

 

[alexhu]

How are you doing the 'transformation' ?

Alex

 

[gunjan14]

We will be using intermediate views. I do not want to use Cursors. We have a constraint for the down time.

 

[abhijit74]

There is no facility to bookmark.
You might have to use a sequence number and keep track of the same.

If you have solved this problem, let me know how did you do it.

Cheers!
Abhijit

 

[sem]

If you have some column used as a sorting key, you may store its latest (highest or lowest depending on order of sorting) value into separate table and on next invocation add where column >(or <) <strored value> condition to your base query.

Regards, Dima