How to drop a table

Hi, friends,

I created a cluster and two tables as follows.

	CREATE CLUSTER DOCTORNO (DNO CHAR(10)) SIZE 512
		STORAGE (INITIAL 100K NEXT 50K PCTINCREASE 10)

	CREATE TABLE DOCTORS (
		DEA#  CHAR(10) CONSTRAINT P1_KEY PRIMARY KEY,
 		L_NAME  CHAR(24),
		F_NAME  CHAR(24),
	 	STREET  CHAR(32),
	 	POBOX   CHAR(24),
 		CITY    CHAR(24),
 		PROV    CHAR(24),
 		POSTCODE CHAR(8),
 		H_PHONE  CHAR(12),
		O_PHONE  CHAR(12),
		SEX     CHAR(2),
		DATE_OF_BIRTH DATE,
		AGE     NUMBER(4),
 		SPECIALITY CHAR(24),
 		TITLE   CHAR(12),
		DEPT    CHAR(20),
	        GRAD_DATE DATE,
	        GRAD_UNIV VARCHAR2(40),
 		MEMO    VARCHAR2(30))
		CLUSTER  DOCTORNO(DEA#)

	CREATE TABLE AVAILABLE (
 		DEA#  CHAR(10) CONSTRAINT F8_KEY REFERENCES DOCTORS(DEA#),
 		WORK_DATE    DATE,
 		UNIT_NO      NUMBER(4),
 		SCHEDULE_TIME CHAR(10),
 		AVAILABLE     NUMBER(2))
		CLUSTER DOCTORNO(DEA#)

I inputed 20 records into table DOCTORS and almost 200,000 records into table AVAILABLE. Now I can not query, update and drop table AVAILABLE. No error message was given. It seems that dead lock occurred.         

Do you have any idea how to drop the tables and cluster? Please mail to me "wyu_at_cs.uregina.ca", Thank you very much in advance.

Weidong Received on Sat Sep 07 1996 - 00:00:00 CEST