-
Unable to drop tablespace
Hi,
I am Converting from dictionary managed PERMANENT "temp" tablespace to localy managed temp tablespace.
1. created "temp2" and assigned as default and temporary tablespace.
2. no permanent objects in "temp"
3. Seven segments exist in temp of type temporary
4. tablespace temp offline
4. Drop tablespace including hangs at :
select file#, block# from seg$ where type# = 3 and ts# = :1
I have even all datafiles offline.
Any way to drop this tablespace without system restart ?
thanks in advance.
-
Are there any entires in V$SORT_USAGE that are in the "temp" tablespace?
-
dba_segments shows :
SYS 5.2 TEMPORARY PSAPTEMP
SYS 5.2562 TEMPORARY PSAPTEMP
SYS 5.5122 TEMPORARY PSAPTEMP
SYS 5.7682 TEMPORARY PSAPTEMP
SYS 5.10242 TEMPORARY PSAPTEMP
SYS 5.12802 TEMPORARY PSAPTEMP
SYS 5.15362 TEMPORARY PSAPTEMP
and v$sort_usage :
USERNAME USER CONTENTS SEGTYPE
----------- --------- --------- ---------
SMARTDBA SYS PERMANENT DATA
SMARTDBA SYS PERMANENT INDEX
SMARTDBA SYS PERMANENT DATA
SMARTDBA SYS PERMANENT INDEX
SMARTDBA SYS PERMANENT DATA
SMARTDBA SYS PERMANENT INDEX
SMARTDBA SYS PERMANENT DATA
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
|