Re: unlock table/row

As to locking:
Locks are released by issuing commits and rollbacks As to the alter table statements:
They are correct. Note: If you have foreign keys referencing the primary key you MUST use the cascade option, or the primary key will not drop. Dropping the primary key will also drop the underlying index, beware.

Hth,

Sybrand Bakker, Oracle DBA

hpcheong_at_ncs.com.sg wrote:

> hi all,
>
> i understand that there are two types of locks provided by Oracle:
>
> 1)table level locking
> 2)row level locking
>
> But can anyone tell me how should i unlock the lock i have issue to
> table/row? is it true that these locks will stay until an unlock command is
> issue or the lock will stay until the end of the session.
>
> question 2
>
> can anyone verify the following syntax is correct?
>
> *** To drop a primary key/s ***
>
> optional
> |
> SQL> alter table <table_name> drop primary key {cascade};
>
> and
> optional
> |
> SQL> alter table <table_name> drop constraint PK_TB_APP {cascade};
>
> see if cascade option is issue correctly?
>
> thanks in advance!
>
> evelyn.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Nov 10 1998 - 05:43:14 CST