tag:blogger.com,1999:blog-18371456.post7189159270767723099..comments2024-03-26T00:07:20.400-05:00Comments on The Db2 Portal Blog: CLONE Tables [DB2 9 for z/OS]Craig S. Mullinshttp://www.blogger.com/profile/17077237739217901780noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-18371456.post-77113731936998882632014-08-07T13:16:32.517-05:002014-08-07T13:16:32.517-05:00Clone tables are specifically for situations where...Clone tables are specifically for situations where the data in a table is periodically completely refreshed. With a clone table, the current table can continue to remain online and available while the clone table is populated with the new refreshed data. When the clone is ready, a quick switch swaps the clone with the current with minimal lack of availability. If you do not have a need like this, then clones are not useful for you.Craig S. Mullinshttps://www.blogger.com/profile/17077237739217901780noreply@blogger.comtag:blogger.com,1999:blog-18371456.post-75981014521883655962014-08-06T23:11:36.421-05:002014-08-06T23:11:36.421-05:00In your article you mentioned we made a Clone tabl...In your article you mentioned we made a Clone table. But what is the benefits? Why we make clone table? We can do our all work in base table also.What is the difference between base table and clone table?<br /><a href="http://www.arx.com" rel="nofollow"> digital signature </a>Anonymoushttps://www.blogger.com/profile/05521903245653355590noreply@blogger.comtag:blogger.com,1999:blog-18371456.post-9178005679693703572012-12-07T14:02:16.797-06:002012-12-07T14:02:16.797-06:00You have mentioned that Clones can be created on L...You have mentioned that Clones can be created on LOB objects too. Can you please let me know how this is accomplished. I did try to clone a LOB table and it fails with SQL Error -148 (THE SOURCE TABLE OR TABLESPACE source-name CANNOT BE ALTERED)Anonymousnoreply@blogger.com