venkat82.k

 Profile Answers by venkat82.k 

• Mar 19th, 2008

 

Hi guys
  partitionings nothing but a huge table is divided into
some meaningfull  parts to do manipulations ,for easy maintain
we divide partitions while creating tables.
mainly 3 types of partitions r there
they are
1.List partitions
2.Range partitions 
3.Hash partitions

ex:-
create table employ(empno number(4),ename varchar2(20),sal number(10),deptno number(3),job varchar2(20))
 partition by range(empno)
(partition p1 values lesthan(101),
partition p2 values lesthan(201),
partition p3 values lesthan(301),
partition p4 values lesthan(maxvalue));

as i know..............best of luck '''''''''
byeeeeeeee