Unable to drop tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Unable to drop tablespace

  1. #1
    Join Date
    Oct 2000
    Posts
    6

    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.

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    Are there any entires in V$SORT_USAGE that are in the "temp" tablespace?

  3. #3
    Join Date
    Oct 2000
    Posts
    6
    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
  •  



Click Here to Expand Forum to Full Width