can a specified table partition be locked ?

[Advocate]

this is something that i have not encountered yet ...

can i identify if a particular table partition is locked
and, if not, can i lock it ?


regards, david - no such thing as problems - only solutions.

 

[Advocate]

oops, found the syntax in sql reference manual


regards, david - no such thing as problems - only solutions.

 

[SantaMufasa]

no such thing as problems - only solutions.

Okay, David, our problem is that you listed no solution. Other Tek-Tipsters cannot learn from your thread if no solution appears. What did you find?


Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[Advocate]

apologies for not responding to this one but requirement actually disappeared and i had no need to do any more investigation ... from memory, you CAN lock one partition if required

regards, david - no such thing as problems - only solutions.

 

[Advocate]

found the time to go back and document the reference in case anyone is interested ... did not test any scenarios though ...

10g sql reference, chapter 18 SQL Statements: DROP SEQUENCE to ROLLBACK

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_9015.htm#sthref6976

e

regards, david - no such thing as problems - only solutions.