Kbase P26368: CREATE VIEW fails with error 7872
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
SYMPTOM(s):
CREATE VIEW fails with error 7872
Failure to acquire exclusive schema lock for DDL operation. (7872)
CAUSE:
As per SQL Concepts, a view is a virtual table; its definition is saved as metadata.
FIX:
Make sure the view is created while no other user has a schema lock.