Can anyone let me know what is database partitioning and
useful link where I can learn more about it.
Are you talking about Table Partition?
Is there anything like Database partitioning other than table partitioning?
No, I never heard of Database Partitioning.
Why tamilselvan asked you this question I feel is because Logically if you consider a Database it is made up of tablespaces and there at least one or many physical datafiles assiciated with each tablespace.We place the datafiles in different Hard Disks or storage media so that the performance of the data being accessed is no way slow and offcourse it is easier for maintainence so we can still call this as database partitioning.
Whereas table partitioning is ur having a table which is split across different talbespace so that the performance is enhanced and easier to access.For example
Let us consider a table EMP which has the following fields
I can store the data as follows by using table partitioning
1-10000 -> users tablespace
10000-20000 -> users1 tablespace
20001-30000 -> users2 tablespace
rest of them -> users3 tablespace
Remember each and every tablespace has a physical datafile associated with it which might be in different hard disks so the access and storage of the data is real fast
Hope this helped
Click Here to Expand Forum to Full Width