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

Thread: Need help on partition create script

Threaded View

  1. #1
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87

    Question Need urgent help on partition create script

    I have an Index which has 70 mil rows in DSS. I was assigned to create a global partitions on the column (part_name)
    by range can somebody help with the query about how to create partitions.
    1. My Index is "CREATE INDEX IND_POR_DT_UTI ON
    PORT_VISION(PART_NAME, UTI);"
    2. And the data type of Varchar2(50) with 60 distinct values
    and data of part_name is like this"ISETSTMT,LOADER55,LINER55,PGMSTZVE43,KMULTSTRT21...)
    3. Oracle 9i
    Thanks & I appreciate your help
    Last edited by portal; 11-12-2004 at 12:48 PM.
    sat

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