DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002

    ORACLE : Oracle 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


  2. #2
    Join Date
    Apr 2002
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.