-
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#
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|