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

Thread: help needed on range partition in oracle 9i

  1. #1
    Join Date
    Jan 2003
    Posts
    141

    help needed on range partition in oracle 9i

    Hi,

    I have a table as "abc_xyz" with 34567278 records

    I want to partition this table, based on the date range.

    Can you pls. let me know how to go about this ?

    Thanks

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    can you pls, RTFM?

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Before RTM (Docs), please go through http://www.dbasupport.com/forums/sho...threadid=36219
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #4
    Join Date
    Jan 2003
    Posts
    141
    I have table which is not partitioned and having 1000000 records. Need to do a partition based on date(DAT_AS_OF) and branch(BRCH_CODE)

    columns :

    BRCH_CODE NOT NULL VARCHAR2(3)
    PORTF_NO NOT NULL VARCHAR2(20)
    CASH_ACCT_NO NOT NULL VARCHAR2(10)
    DAT_AS_OF NOT NULL DATE
    PP_CODE VARCHAR2(3)
    BASE_NO VARCHAR2(20)

    How to add partition for the above table?

    Cheers!

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    You can't add a partition to a non-partitioned table -- you have to create a new partitioned one.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #6
    Join Date
    Jan 2003
    Posts
    141
    Hi Dave Thanks for the support!

    Is it possible to do an export of the non-partitioned table and do an import after creating partition.

    Many Thanks

  7. #7
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    You can export the data, then drop and recreate the table as partitioned, and an import will re-insert all the rows.

    Or, if you have the space, you could more simply "create new_partitioned_table as select * from old_table"
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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