User Profile

Collapse

Profile Sidebar

Collapse
nbajrach
nbajrach
Last Activity: Dec 12 '07, 02:04 PM
Joined: Sep 5 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • nbajrach
    started a topic creating raw partition for asm diskgroup
    in Oracle

    creating raw partition for asm diskgroup

    i am trying to create raw partition in linux so that it can be user as used as disk group. can anyone please help me how can i do that.

    I used fdisk command and i did make partition but i couldn't see any diskgroup while i was installing database(dbca) and choose asm.

    Thanks
    See more | Go to post
    • nbajrach
      replied to Partition a table
      in Oracle
      Same error

      alter table si add partition by range(si_id)
      *


      ERROR at line 1:

      ORA-00902: invalid datatype
      See more | Go to post

        Leave a comment:

      • nbajrach
        started a topic Partition a table
        in Oracle

        Partition a table

        how to partition on a table if table already exits without any partition.


        This is what i tried but gave me error

        SQL> alter table sip add partition by range(si_id)

        2 partition p1_si values less than (50001),

        3 partition p2_si values less than (100001),

        4 partition p3_si values less than (150001),

        5 partition p4_si values less than (200001);...
        See more | Go to post
        No activity results to display
        Show More
        Working...