EXECUTE IMMEDIATE, ALTER OBJECT MOVE/REBUILD, TEMPORARY SEGMENTS STAY allocated
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: EXECUTE IMMEDIATE, ALTER OBJECT MOVE/REBUILD, TEMPORARY SEGMENTS STAY allocated

  1. #1
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi,


    ORACLE : Oracle 8.1.7.3.50 EE

    i developed a REORG-Tool for Indexes and Tables with PL/SQL.
    One of the Procedures moves all Objects of an Tablespace to another. The DDL's are executed with EXECUTE IMMEDIATE ...

    When the Destination-Tablespace grows due to moved Objects the Source-Tablespace shows always the same total allocated size. When the script finished then no allocated place is seen in the Source-Tablespace.

    - I have seen tempoary segments in the Source-Tablespace
    - every objects moved created a temporary Segment in the Source-Tablespace

    Why Oracle holds the segments till the procedure ends?

    Please let me know if you have an idea

    Orca


  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi, thanks for ( future ) reply;
    The problem is not in the TEMP-Tablespace, it's in the Source-Tablespace ( LOCAL MANAGED, UNIFORM, ... )
    Every Table / Index-segment which is moved to the Dest-Tablespace is not deleted immediatly but renamed/marked as 'TEMPORARY'.
    This must be a sideeffect with EXECUTE IMMEDIATE!

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