tag:blogger.com,1999:blog-5085850589914248681.post4996594728468709318..comments2021-01-08T14:27:52.071+01:00Comments on Managing Oracle: Oracle table reorganization: Online or OfflineFJ Franken (DBA)http://www.blogger.com/profile/14960974918564490086noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-5085850589914248681.post-15577959985708591592021-01-08T14:22:19.068+01:002021-01-08T14:22:19.068+01:00Great Article Artificial Intelligence Projects Pro...Great Article <a href="http://projectcentersinchennai.co.in/Final-Year-Projects-for-CSE/Final-Year-Projects-for-CSE-Artificial-Intelligence-Domain" title="Artificial Intelligence Projects" rel="nofollow">Artificial Intelligence Projects</a><br><br> <a href="http://projectcentersinchennai.co.in" title="Project Center in Chennai" rel="nofollow">Project Center in Chennai</a><br><br> <a href="http://javascripttrainingcourses.com" title="JavaScript Training in Chennai" rel="nofollow">JavaScript Training in Chennai</a><br><br> <a href="http://wisentechnologies.com/it-courses/html-css-javascript-jquery-training.aspx" title="JavaScript Training in Chennai" rel="nofollow">JavaScript Training in Chennai</a> <a href="http://wisensoft.com/ieee-projects/project-centers-in-chennai" title="Project Centers in Chennai" rel="nofollow">Project Centers in Chennai</a> Sankarhttps://www.blogger.com/profile/15190208567205518324noreply@blogger.comtag:blogger.com,1999:blog-5085850589914248681.post-65101002912557457272019-02-04T16:10:04.161+01:002019-02-04T16:10:04.161+01:00This is really very nice document.This is really very nice document.Anonymoushttps://www.blogger.com/profile/09266817946689690798noreply@blogger.comtag:blogger.com,1999:blog-5085850589914248681.post-60983945610974315122016-01-13T11:46:00.462+01:002016-01-13T11:46:00.462+01:00Very precise and clear document on Re-org. Thanks ...Very precise and clear document on Re-org. Thanks you for preparing and sharing this one. valiantvimalhttps://www.blogger.com/profile/09925725191033973521noreply@blogger.comtag:blogger.com,1999:blog-5085850589914248681.post-42919773216706916182014-10-27T15:19:55.691+01:002014-10-27T15:19:55.691+01:00Thanks for Information Oracle Online TrainingThanks for Information<a href="http://www.flaxit.com/oracle-technologies/" rel="nofollow"> Oracle Online Training</a>Anonymoushttps://www.blogger.com/profile/11855345812967782689noreply@blogger.comtag:blogger.com,1999:blog-5085850589914248681.post-11682014379905163122014-04-07T07:23:45.048+02:002014-04-07T07:23:45.048+02:00Really helpful Franken..Really helpful Franken..Adithiyanhttps://www.blogger.com/profile/01188886691907415519noreply@blogger.comtag:blogger.com,1999:blog-5085850589914248681.post-12001825724857977022013-06-22T14:03:07.851+02:002013-06-22T14:03:07.851+02:00Be careful on a dataguard logical standby. There i...Be careful on a dataguard logical standby. There is a bug in Oracle all the way up to v 11.2.0.3. Bug 13070166 - SHRINK SPACE receives ORA-16211 on real time apply logical standby[Article ID 13070166.8. I know - I just hit it! Not fixed until v12 !AK28https://www.blogger.com/profile/04188212278477334436noreply@blogger.comtag:blogger.com,1999:blog-5085850589914248681.post-89071761594054562872013-03-04T08:28:02.386+01:002013-03-04T08:28:02.386+01:00Hi,
My knowledge about Dataguard is not up to dat...Hi,<br /><br />My knowledge about Dataguard is not up to date, so I can't tell for sure what would happen. My first guess is that all will be going fine.<br />Remember that this action will generate an extra amount of redo-shipping, so make sure there is sufficient redo/archive space available.<br /><br />ThanksFJ Franken (DBA)https://www.blogger.com/profile/14960974918564490086noreply@blogger.comtag:blogger.com,1999:blog-5085850589914248681.post-10857083293667207932013-03-04T08:07:54.957+01:002013-03-04T08:07:54.957+01:00Hi Franken,
I'm going to apply y...Hi Franken,<br /> <br /> I'm going to apply your document steps in our production environment and we have data guard enable is there any precution I have to take before applying it.<br /><br />Regards,<br />MohammedAnonymoushttps://www.blogger.com/profile/03196559980070816288noreply@blogger.comtag:blogger.com,1999:blog-5085850589914248681.post-68321703830443038872013-02-28T09:11:21.907+01:002013-02-28T09:11:21.907+01:00Hi Franken,
I Appritiate you...Hi Franken,<br /><br /> I Appritiate your quick response as I tested your given steps in this blog in our test env soon going to apply on production too and thanks for your reply...<br /><br />Regards,<br />Mohammed khaja raziuddinAnonymoushttps://www.blogger.com/profile/03196559980070816288noreply@blogger.comtag:blogger.com,1999:blog-5085850589914248681.post-89396528456142250512013-02-27T10:15:30.017+01:002013-02-27T10:15:30.017+01:00Thanks for the comment.
It is not necessary to di...Thanks for the comment. <br />It is not necessary to disable row movement if you will do a shrink again in the near future. Keeping row movement enabled does not affect normal database operations. <br />However, if this was a one time operation, and your application depends on rowid's ( not recommend ), then it might be safe to disable it again, so no unplanned shrink is executed during business hoursFJ Franken (DBA)https://www.blogger.com/profile/14960974918564490086noreply@blogger.comtag:blogger.com,1999:blog-5085850589914248681.post-814213409350330152013-02-27T09:57:19.719+01:002013-02-27T09:57:19.719+01:00Hi Franken,
Nice article I had app...Hi Franken,<br /><br /> Nice article I had apply it on my DB but I had one doubt what if we enable row movement on table after shrinking that table we need to disable row movement on that table.Anonymoushttps://www.blogger.com/profile/03196559980070816288noreply@blogger.comtag:blogger.com,1999:blog-5085850589914248681.post-20502636150127325722012-09-17T19:49:10.553+02:002012-09-17T19:49:10.553+02:00Excellent article. U made us understand about re-o...Excellent article. U made us understand about re-org in a cool way. Thank you.Anonymoushttps://www.blogger.com/profile/09320528203699384387noreply@blogger.comtag:blogger.com,1999:blog-5085850589914248681.post-65714184009958402082011-10-25T18:17:20.205+02:002011-10-25T18:17:20.205+02:00This is very very helpful. Thank you for putting i...This is very very helpful. Thank you for putting it so simply.Mandrakehttps://www.blogger.com/profile/12533732722514938548noreply@blogger.comtag:blogger.com,1999:blog-5085850589914248681.post-66405857951668996752011-08-12T09:01:20.786+02:002011-08-12T09:01:20.786+02:00Nice documentNice documentsucheehttps://www.blogger.com/profile/02409889526245543144noreply@blogger.com