Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Location
    Toronto, Ontario, Canada
    Posts
    34

    Question Unanswered: moving tablespace objects

    Hi all

    Here is my question. I have a tablespace which has a ton of objects. I would like to move the objects to another tablespace on the same db. Is there a way I can do this without having to drop and recreate the objects. There is approximately 800 objects and I am using Oracle 8i. I have read that you can export tablespaces but that only copies data dictionary information so I can't use that method to resolve my issue.

    Thanks

    Hamza Ally

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Try:

    alter table MyTable move tablespace NewTablespace;

    and

    alter index MyIndex rebuild tablespace NewTablespace;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •