Oracle does not allow a user to specifically locate tables, since that is a part of the function of the RDBMS. However, for the purpose of increasing performance, oracle allows a developer to create a CLUSTER. A CLUSTER provides a means for storing data from different tables together for faster retrieval than if the table placement were left to the RDBMS.
Clustering is a method of storing tables that are intimately related and often joined together into the same area on disk. For example, instead of the BOOKSHELF table being in one section of the disk and the BOOKSHELF_AUTHOR table being somewhere else, their rows could be interleaved together in a single area, called a cluster.
Above answer was rated as good by the following members: shiiva
you have wrote oracle doesn't allow a user to specifically lacate the tables that's means.I didn't understand clearelly.please tell me that meaning thank u.
Clustering is a method of storing tables that are intimately related and often joined together into the same area on disk. For example instead of the BOOKSHELF table being in one section of the disk and the BOOKSHELF_AUTHOR table being somewhere else their rows could be interleaved together in a single area called a cluster.
1 
0