DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: partitioning

Hybrid View

  1. #1
    Join Date
    Sep 2002
    Posts
    59

    partitioning

    hello
    i have a table with thousands of records , now i want to go for partition .i have to do without using logical backup that is create a new table and taking a backup of the records query wise and than dump it to the new table which is partitioned.
    one of my colleage is not sure of the syntax but he said to use exchange to copy the records to the new table which is partitioned.
    could you please help me with the correct syntax or help me out with a solution
    thank you

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    You could use CREAT TABLE ... AS SELECT ... or you could export the data and create the new partitioned object then import.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447

  4. #4
    Join Date
    Sep 2002
    Posts
    59

    partitioning

    hello jim
    thst is fine
    is there no keyword or sytax called exchange to transfer the records.
    thanks for suggestion

  5. #5
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    The CREATE TABLE ... AS SELECT with create the new table structure and copy the records.

    eg

    if you have a table TEST and you want to create a partition table TEST2 with the values from TEST you could do something similar to the following:

    Code:
     create table TEST2
     partition by range (id)
       (partition range1 values less than (5),
       partition range2 values less than (50))
     as select * from TEST
    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  6. #6
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448

    Re: partitioning

    Originally posted by ramuv
    hello
    i have a table with thousands of records thank you
    is thousend of records enough to decide for partitioning???
    remember not to forget the overhead of partitioning.

    Oracle recommends this feature as must for table with > 2GB!

    Orca


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