Move tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Move tables

  1. #1
    Join Date
    Jan 2001
    Posts
    16
    Could someone please post the syntax for moing a table from one tablespace to another. I just cant get it right.

    I tried

    alter table emp tablespace users;

    it wont work.


    I'm using oracle 8.0.6.


    Thanks a lot.

  2. #2
    Join Date
    Jul 2000
    Posts
    296
    Moving a table to another tablespace isn't that easy. If the table has no rows, no triggers, no grants etc, dropping and recreating is an option. Export and import the table in another tablespace is the best option.

  3. #3
    Join Date
    Jan 2001
    Posts
    16
    Thanks. The table contains no data so I think I'll just drop and recreate them.
    when I was using 8i, we could do this. That's why I was confused.

    Thanks a lot anyway.

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    "ALTER TABLE table_name MOVE TABLESPACE tablespace_name" not supoorted on lower versions of 8.1.x.

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