I don't see any problem in dropping a table.Code:SQL> CREATE TABLE BP ( BV_ID VARCHAR2 (32) DEFAULT NULL NOT NULL, BP_ID VARCHAR2 (32) DEFAULT NULL NOT NULL, CONSTRAINT BP_PK PRIMARY KEY ( BV_ID, BP_ID ) ) ; Table created. SQL> insert into bp select substr(object_name,1,32), substr(object_name,1,32) from dba_objects 2 where rownum <101 ; 100 rows created. SQL> commit ; Commit complete. SQL> drop table bp ; Table dropped.
However, if you have referential integrity constraint, then you need to disable it also.
Tamil




Reply With Quote