Subject | Object YY is un use |
---|---|
Author | Guillermo Najar-Arreola |
Post date | 2003-05-06T22:12:26Z |
Hi,
When executing scripts specialy those that alter a table to add an FK like
this:
ALTER TABLE MANIFESTDEVOL_V2
ADD FOREIGN KEY (OID_PROVEEDOR)
REFERENCES PROVEEDOR;
ALTER TABLE MANIFESTCOMPEN_V2
ADD FOREIGN KEY (OID_PROVEEDOR)
REFERENCES PROVEEDOR;
ALTER TABLE REGOPER_ACUMULADO
ADD FOREIGN KEY (OID_PROVEEDOR)
REFERENCES PROVEEDOR;
ALTER TABLE REGOPER_PART
ADD FOREIGN KEY (OID_PROVEEDOR)
REFERENCES PROVEEDOR;
I usually get the following error message: "This operation is not defined
for system tables. Unsuccessful metadata update. Object PROVEEDOR is in
use". There are no programs or pending transaction; why I get this error? is
there any db parameter I have to adjust?
Thank you,
Guillermo N.
When executing scripts specialy those that alter a table to add an FK like
this:
ALTER TABLE MANIFESTDEVOL_V2
ADD FOREIGN KEY (OID_PROVEEDOR)
REFERENCES PROVEEDOR;
ALTER TABLE MANIFESTCOMPEN_V2
ADD FOREIGN KEY (OID_PROVEEDOR)
REFERENCES PROVEEDOR;
ALTER TABLE REGOPER_ACUMULADO
ADD FOREIGN KEY (OID_PROVEEDOR)
REFERENCES PROVEEDOR;
ALTER TABLE REGOPER_PART
ADD FOREIGN KEY (OID_PROVEEDOR)
REFERENCES PROVEEDOR;
I usually get the following error message: "This operation is not defined
for system tables. Unsuccessful metadata update. Object PROVEEDOR is in
use". There are no programs or pending transaction; why I get this error? is
there any db parameter I have to adjust?
Thank you,
Guillermo N.