How to open exclusive a table in Oracle9i ?

[kmthien]

Hi guys,

How to open exclusive a table in Oracle9i like in Access, where when user1 is selecting,updating or deleting from this table, other users won't be able to select any data from this table until user1 completing his operation. Pls help....

 

[kmthien]

Hi guys....pls help !

 

[Argo]

You need to change lock level from row to table. In DB2 it's a database option, rather than table. Oracle might be similar in that.

 

[kmthien]

Hi,

Where can I get an online guide on this? Thx !

 

[Argo]

Not sure. Try google, oracle website, documentation that came with the software. Shouldn't be too hard to find.

 

[Haircut]

You can use

LOCK TABLE tablename IN EXCLUSIVE MODE;

to lock any given table, this will stop any other user from updating, inserting or deleting from that table until you either rollback or commit the transaction.

 

[kmthien]

Hi Haircut,

U mean I need to execute LOCK TABLE tablename IN EXCLUSIVE MODE statement first? For example, if I m using OCI in VC++ 6.0, I need to do the following?

COdb ora;
CString sql = "LOCK TABLE TABLE1 IN EXCLUSIVE MODE";
ora.exec(sql);
//This will lock TABLE1 from excessing by others ?
sql = "select * from TABLE1";
ora.Select(sql);
ora.close(); //release the lock ?

Pls help...Thx !

 

[kmthien]

Pls help...thx !

 

[kmthien]

Guys....pls help.....

 

[kmthien]

Pl.....s.......he....lp.......... :<

 

[CaffeineAndStuff]

If u explain why you want to lock a table I'm sure I could be more help - I've been coding for a while and have never needed to lock a table (alright - I tell a lie - I have once)