tag:blogger.com,1999:blog-4096575.post8179024281862459800..comments2024-03-18T02:14:37.994-04:00Comments on The Arup Nanda Blog: Tool to Add Range Partitions Automatically to a TableArup Nandahttp://www.blogger.com/profile/03392706779349258765noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-4096575.post-78505952073796190952021-03-27T06:09:52.362-04:002021-03-27T06:09:52.362-04:00I have been searching for such an informative publ...I have been searching for such an informative publication for many days, and it seems that my search here has just ended. Good job. Continue publishing.<br /><a href="https://www.yellowpages.ae/subcategory/Interior-Designing/Partitions/5ecb70c4ebee8a7379acd0f7" rel="nofollow">room dividers in dubai,glass partitions,glass partitions in dubai</a><br />sushanthttps://www.blogger.com/profile/02274241267024781588noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-12263526502976001242021-03-24T06:27:44.437-04:002021-03-24T06:27:44.437-04:00Nice post Requard room dividers in dubai,glass par...Nice post Requard room dividers in dubai,glass partitions,glass partitions in dubai . It shows the great knowledge thanks. For providing this valuable . Information but visit us for Requard niche Information.<br /><a href="https://www.yellowpages.ae/search/Partitions" rel="nofollow">room dividers in dubai,glass partitions,glass partitions in dubai</a><br />Anonymoushttps://www.yellowpages.ae/search/Partitionsnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-84521650619915222052020-08-16T15:12:22.161-04:002020-08-16T15:12:22.161-04:00Excellent information Providing by your Article Qu...Excellent information Providing by your Article <a href="https://thestandarddaily.com/quickbooks-support//" rel="nofollow">Quickbooks customer support number</a>sam smithhttps://www.blogger.com/profile/12003358823024192876noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-87044545605518797512012-08-30T11:14:22.398-04:002012-08-30T11:14:22.398-04:00Arup...Any update on my next question?Arup...Any update on my next question?Samnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-68462253343412592642012-08-28T10:19:16.448-04:002012-08-28T10:19:16.448-04:00Arup....
Here is the query im using...
select DB...Arup....<br /><br />Here is the query im using...<br /><br />select DB_NAME,a.DBID,input_type "Backup Object",STATUS,max(start_time) "Backup Begin",max(end_time) "Backup End"<br />from rman.rc_rman_backup_job_details bkp,(select b.db_key,b.dbid from rman.rc_database b) a<br />where<br />start_time > sysdate - 1 and input_type in ('DB INCR','DB FULL','ARCHIVELOG','BACKUPSET')<br />and a.db_key=bkp.db_key<br />group by DB_NAME,a.DBID,STATUS,input_type<br />order by 1<br />/<br /><br />i would like to get the hostname of the corresponding database name using any of the repository view i.e rc_* of a target database in the above query....Samnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-6017376510768654172012-08-27T18:00:50.014-04:002012-08-27T18:00:50.014-04:00@Sam There are two options:
SQL> select sys_co...@Sam There are two options:<br /><br />SQL> select sys_context('USERENV','HOST') from dual;<br /> <br />SYS_CONTEXT('USERENV','HOST')<br />--------------------------------------------------------------------------------<br />oradba2<br /> <br />1 row selected.<br /> <br />SQL> select HOST_NAME from v$instance;<br /> <br />HOST_NAME<br />----------------------------------------------------------------<br />oradba2<br /> <br />1 row selected.<br />Arup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-40111890506063121662012-08-27T17:32:14.517-04:002012-08-27T17:32:14.517-04:00how can i obtain the host name for the related dat...how can i obtain the host name for the related database name??Samnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-19239915716829211802012-06-05T01:32:48.634-04:002012-06-05T01:32:48.634-04:00This is a interesting article. I myself use CSS Fr...This is a interesting article. I myself use CSS Friendly Control Adapters. They are not perfect but at least give me some control over menu style. Don't care much about access keys but I'm going to use ListingAidan Hardinghttp://www.diskdoctors.com/data-recovery-atlanta.aspnoreply@blogger.comtag:blogger.com,1999:blog-4096575.post-35037808983590708292011-01-06T19:13:20.199-05:002011-01-06T19:13:20.199-05:00IN our case partitions are done with VALUES LESS T...IN our case partitions are done with VALUES LESS THAN ('110201')<br /><br />where 110201 is YYDDMM.<br /><br /><br />Thanks<br />Amit Sainitruegurmukhhttps://www.blogger.com/profile/05270645632722083028noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-32656374495343773402011-01-06T18:10:12.740-05:002011-01-06T18:10:12.740-05:00While executing prcedure getting error message
S...While executing prcedure getting error message<br /><br /><br />SQL> exec partition_create<br />Owner Table Part Unit Old HV New HV Exec<br />--------- ----------------------------- --------- ---------- ---------- ---<br />BEGIN partition_create; END;<br /><br />*<br />ERROR at line 1:<br />ORA-20001: ORA-01861: literal does not match format string<br />ORA-06512: at "SYS.PARTITION_CREATE", line 245<br />ORA-06512: at line 1<br /><br /><br />Any idea ?<br /><br />Thanks<br />Amit Sainitruegurmukhhttps://www.blogger.com/profile/05270645632722083028noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-50820759002833106172010-11-11T09:59:43.999-05:002010-11-11T09:59:43.999-05:00This is a comment I got from @dannorris via twitte...This is a comment I got from @dannorris via twitter.<br /><br />>> is that basically what interval partitioning does in 11g?<br /><br />My response: no; it's a little different.<br /><br />(1) interval partitioning creates partitions at runtime; not in advance. So, if you know that partitions will need to be created for the next month, before the month starts, you really can't do that in interval partitioning. You will need to insert a dummy record for the next month's date for the partition to be created. This tool, on the other hand can create that in advance.<br /><br />(2) Interval partitioning is only for 11g; this tool is for all versions - 10g. I haven't tried in 9i; but it should work too.Arup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-84271404273434557392010-11-11T09:55:02.336-05:002010-11-11T09:55:02.336-05:00@Flado on your specific comments:
>> Also, ...@Flado on your specific comments:<br /><br />>> Also, the tool is leaving all index partitions it rebuilds in the NOLOGGING state, even if they were LOGGING before.<br /><br />True. In the next version it will check for the previous state and reinstate that. <br /><br />>> INITRANS, FREELISTS and FREELIST GROUPS wouldn't be adjustable, if the values (respectively) 11, 11, and 7 were the optimal ones. <br /><br />Yes; that's an assumption I made. These values will most likely be the same across all indexes anyway.<br /><br />>> And maybe I'm reading the code wrong, but it appears the script would add a daily partition each time it is run (and other partitions if run on the first of the respective period). So, if it succeeds for some tables but fails later, I cannot simply re-run it, since this would create extra daily<br /><br />No; you are not reading the code wrong. The script would create exactly that. However, the workaround I propose is temporarily removing the table name from the driver table for the successful ones. I agree it's not the best option; but it works. I will introduce the functionality for the next iteration of enhancements.<br /><br />Thanks once again for the detailed feedback. They were quite helpful.Arup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-77838832770054991952010-11-11T09:49:42.534-05:002010-11-11T09:49:42.534-05:00@Flado - thanks for catching it. I had that functi...@Flado - thanks for catching it. I had that functionality but decided to pull it out pending further testing. But did a sloppy job at that - I pulled it from the table but not from the code. But now that I think about it, it's better to be there. It's the number of units you want to create in advance. For instance it's a DAILY partition, you may want the next daily partition to be 3 days from now instead of just 1. In that case you would put 3 there; not 1. That specific functionality will be enhanced over time.<br /><br />I have changed the table creation and the insert statements accordingly. No change has been made to the procedure.Arup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-68832377058352584042010-11-11T06:29:36.648-05:002010-11-11T06:29:36.648-05:00Hi Arup,
Where does "l_sched_rec.num_parts_t...Hi Arup,<br /><br />Where does "l_sched_rec.num_parts_to_create" come from? It is not in the partition_create_schedule table.<br /><br />Also, the tool is leaving all index partitions it rebuilds in the NOLOGGING state, even if they were LOGGING before.<br /><br />And what if my MAXVALUE partition is not named PMAX? I mean, I could adjust the script to use my name, but I might have different names for the MAXVALUE partitions of different tables. Now what?<br /><br />INITRANS, FREELISTS and FREELIST GROUPS wouldn't be adjustable, if the values (respectively) 11, 11, and 7 were the optimal ones.<br /><br />And maybe I'm reading the code wrong, but it appears the script would add a daily partition each time it is run (and other partitions if run on the first of the respective period). So, if it succeeds for some tables but fails later, I cannot simply re-run it, since this would create extra daily (and possibly weekly etc.) partitions, moving my highest partition a period in the future. Do this enough times, and I may find myself creating daily partitions a year ahead.<br /><br />And failing is not unlikely. A single active transaction against any of the PMAX partitions would crash the whole procedure. Sure, I would get the email, but re-running the script is not trivial.<br /><br />Cheers,<br />FladoFladohttps://www.blogger.com/profile/04901763101139511192noreply@blogger.comtag:blogger.com,1999:blog-4096575.post-62327567768096131742010-11-11T05:09:14.913-05:002010-11-11T05:09:14.913-05:00Thanks Arup.
Great job,
MarcoVThanks Arup.<br />Great job,<br />MarcoVMarco V.https://www.blogger.com/profile/01205506217107591086noreply@blogger.com