Any oracle equivalent to Lockmode readlock ?

[steffg]

I need to create an oracle database to store off some ingress table archive log information. So in my duplication between the two database systems...

Ingres allows an exclusive lock on tables, set lockmode on tablename where readlock = exclusive which means the users can't access the same
rows that are being modified by another query.

Is there anything in oracle that does the same thing ? All of Oracle's locking seesm to be that you can still read data. And that is what my user is afraid of. He doesn't want to read old data, when it's being changed.

How do you work around this in oracle ?

[kschendel]

I don't pretend to know oracle, but I would look for some sort of "select .. for update" statement.

[rhann]

Your question isn't very clear and your understanding of READLOCK=EXCLUSIVE isn't quite right, but I think you are asking about how to make sure your Oracle user doesn't do dirty reads on the data you are importing.

You my have better luck asking an Oracle forum, but I believe Oracle works exactly as you would expect. The Oracle user won't see uncommitted data unless they've deliberately relaxed the isolation level to READ UNCOMMITTED.

In a nutshell, it's just not your problem. Just do your update and commit when you're finished (and not before).