Subject | unsucessful metadata |
---|---|
Author | Benny Setiawan Tanua |
Post date | 2002-05-23T06:14:25Z |
Dear All,
i have problem
i use this query :
CREATE TABLE M_ROLES(ROLE_ID INTEGER NOT NULL PRIMARY KEY,
STATUS INTEGER,
NAME VARCHAR(64),
CREATED DATE,
CLOSED DATE,
NOTE VARCHAR(128),
PARENT_ROLE_ID INTEGER ,
FOREIGN KEY (PARENT_ROLE_ID) REFERENCES
M_ROLES(ROLE_ID)
);
but error :
unsucessful metadata object M_ROLES is in use
does anyone knows about this error and why..??
Thanks,
-bst-
i have problem
i use this query :
CREATE TABLE M_ROLES(ROLE_ID INTEGER NOT NULL PRIMARY KEY,
STATUS INTEGER,
NAME VARCHAR(64),
CREATED DATE,
CLOSED DATE,
NOTE VARCHAR(128),
PARENT_ROLE_ID INTEGER ,
FOREIGN KEY (PARENT_ROLE_ID) REFERENCES
M_ROLES(ROLE_ID)
);
but error :
unsucessful metadata object M_ROLES is in use
does anyone knows about this error and why..??
Thanks,
-bst-