| 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-