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

    Reorganizing Tablespace

    I am in Oracle 8.1.7 with Dictionary Managed Tablespaces in my development. I am trying to regain some space by moving some objects off of one tablespace to another by useing the move command for tables and the rebuild command for indexes.

    I am having a problem with the partitioned tables. I was able to move the partitions but the table itself has a default tablespace of the tablespace I want to move it off of. What is the command to move the table to another tablespace when it is partitioned?

  2. #2
    Join Date
    Jan 2001

    Got It

    I got it from another DBA here

    alter table modify default attributes tablespace ;

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.