(Oracle DB) - 7. DROP TABLE

/* DROP TABLE */
DROP TABLE ex2_10;
/*
	#	The database objects : table, data in the table are removed from database
	
	#	DROP TABLE ex2_10 CASCADE CONSTRAINT;
		Primary key of the table and constraint for reference integrity are removed.
		CAUTION : Dropped table can not be recovered!!!	
*/

	/* Case for failed to DROP TABLE */
SELECT
	s.sid, s.serial#, s.username, o.object_name
	FROM v$locked_object l, dba_objects o, v$session s
WHERE l.object_id = o.object_id AND l.session_id = s.sid;

ALTER SYSTEM KILL SESSION 'sid, serial#';	-- Replace sid, serial# to the values gotten