Doyen System Pvt. Ltd.
Saturday, 23 January 2016
DDL operation while execution
While query execution we cannot do the ddl operation in the earlier versions
From 11g we can use the below script to lock the object for mentioned seconds and perform the ddl operation.
ALTER SESSION SET DDL_LOCK_TIMEOUT=60;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment