Rebuilding Indexes and Recreating Partitions. From Old Tbl to New Tbl. Sql Queries!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Rebuilding Indexes and Recreating Partitions. From Old Tbl to New Tbl. Sql Queries!

Threaded View

  1. #1
    Join Date
    Jan 2007
    Posts
    12

    Question Rebuilding Indexes and Recreating Partitions. From Old Tbl to New Tbl. (RESOLVED)

    I need to know how, by using SQL Queries, Do i do the following:

    1-Create a new empty table based on another tables structure:

    I have worked this part out.

    Create Table NewTable as Select * From OldTable Where 1 = 0

    -----------------------

    2-Rebuild the Indexes on the new table so they start where the old table ended off

    Not a clue

    -----------------------

    3-ReCreate the exact partitions of the old table, to the new table

    Not a clue


    Please note that it must be done using SQL Queries!

    Also when i try to export a script of a table to see if i could get a clue of syntax etc from there, TOAD crashes everytime. Oracle help and most of the help on the net will only tell me how to do it using the interface and not Queries. The idea of this is to do it without TOAD just using Queries. Thanks in advance

    Using Toad for Oracle version 8.6
    Last edited by Pixie22; 01-24-2007 at 09:22 AM.

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