Results 1 to 2 of 2

Thread: Move tables

  1. #1
    Join Date
    Oct 2003
    Location
    Republic of Srpska, Bosnia and Herzegovina
    Posts
    35

    Unanswered: Move tables

    Connect to sqlplus as MyUser and type the commands:

    spool MoveTables.sql
    select 'alter table '|| table_name||' move table_space NEW_TBS' from user_tables
    where tablespace_name='OLD_TBS'
    spool off

    spool RebuildIndexes.sql
    SELECT 'ALTER INDEX '|| OBJECT_NAME || ' REBUILD' from USER_OBJECTS WHERE OBJECT_TYPE='INDEX'
    spool off

    Then execute scripts MoveTables.sql and RebuildIndexes.sql.


    Hope this help.

  2. #2
    Join Date
    Oct 2003
    Location
    Republic of Srpska, Bosnia and Herzegovina
    Posts
    35
    Sorry my false

Posting Permissions

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