To find out which Tablespace Drop out from ur DATABASE

!HELLO
Here akram shaik ,


IF u want to find out which tablespace Drop out and How many times Tablespace name is Repeat. U CAN FIND Here its helps U .

1. SQL> SELECT TS#,NAME,OWNER#,INC# FROM TS$;
output :
========
TS# NAME OWNER# INC#
---- ------------------------------ ---------- ----------
11 UNDOTBS2 0 1
12 T1 0 1
13 USER_DATA 0 1

3.drop tablespace user_data including contents and datafiles;

4. TS# NAME OWNER# INC#
----- ------------------------------ ---------- ----------
11 UNDOTBS2 0 1
12 T1 0 1
13 USER_DATA 0 1

5)TS# NAME OWNER# INC#
--- ------------------------------ ---------- ----------
11 UNDOTBS2 0 1
12 T1 0 1
13 USER_DATA 0 2

==========================
Note:: check out the INC#