hi all, please ignore this post. My problem is solved.
thanks Sathish -----Original Message----- Sent: Tuesday, February 12, 2002 1:33 PM To: '[EMAIL PROTECTED]' Importance: High hi all, I have read this document on partitioning which says that partitioning cannot be implemented in clusters. ------------------------------------------------------------------------ ------------------------------------------------ I.2 Version 8: --------------- Partitioning is offered as an option in Oracle V8 Enterprise Server Edition. It is an option that requires specific selection during installation of the RDBMS that enables it to be linked into the kernel. This new option is useful in addressing performance problems and database administration issues in Very Large Database (VLDB) environments. Administrators of databases with historical data are particularly interested in this option. Administrators of OLTP databases concerned the performance and/or availability also benefit with the implementation of this option. Advantages: - Improved database administration as several maintenance operations can now be done at a partition level rather than at a table or index level. Moreover, the independence between partitions allows the maintenance on those very partitions to take place simultaneously. - Database unavailability reduced. Finer grained recovery as it can be done at the partition level. - Better distribution of data as it is possible to spread it out on several partitions and different disks. - Performance enhancement in the dispatching of queries, particularly for data warehousing or decision making. The optimizer is capable of selecting a limited quantity of rows associated with one or several partitions specified in the query. This functionality is available for both indexes and tables, but cannot be implemented in clusters. ------------------------------------------------------------------------ ------------------------------------------------ does this mean that we cannot implement partitioning with Parallel server. It would be of great help in case you can clarify this point. thanks, Sathish. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sathish Tatikonda INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).