tag:blogger.com,1999:blog-697307722356110163.post5319989641125609548..comments2023-10-19T08:14:15.629-04:00Comments on Halimdba: How can partition a non-partitioned table in oracle 10ghalimdbahttp://www.blogger.com/profile/06064045814557676169noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-697307722356110163.post-58368399426884824742015-11-19T07:39:44.201-05:002015-11-19T07:39:44.201-05:00Hello Sir ,
A Very informative article but correc...Hello Sir , <br />A Very informative article but correct me if i am wrong.<br /><br />In the part h)<br /><br />h)Rename all the constraints and indexes to match the original names.<br />ALTER TABLE unpar_table RENAME CONSTRAINT unpar_table_pk2 TO unpar_table_pk;<br />ALTER INDEX create_date_ind2 RENAME TO create_date_ind;<br /><br />It is mentioned that rename the constraint unpar_table_pk2 to the unpar_table_pk.But this renaming will not change the index name created with this primary key. To change the primary key index name we need to -<br /><br />ALTER INDEX unpar_table_pk2 RENAME TO unpar_table_pk;<br /><br />- AmitAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-697307722356110163.post-21806084332554057162015-05-24T07:58:40.612-04:002015-05-24T07:58:40.612-04:00Sir this is Very informative and to the point post...Sir this is Very informative and to the point post. I question only that the table name in where clause should be in Upper case.<br /><br />Thanks a lot.<br /><br />From<br />AKTAnonymousnoreply@blogger.com