declare dummy number; begin for sq in ( select sequence_owner||'.'||sequence_name nm from dba_sequences where sequence_owner in ( 'CLIENTDBO','DEALERTOOLS_DBO','GAINDBO','IT_JOB_LOG','MXDBO','MYBROKERDBO', 'NEWTOPSDBO','ODFSDBO','ODL_DBADMIN_DBO','ODL_DBSERVICES_DBO','ODL_USERAPPS_DBO', 'PRODUCTDBO','RECONCILIATIONSDBO','SETTLEMENTSDBO','USER_ADMIN_SYS','WEB') ) loop dbms_output.put_line(sq.nm); for i in 1..10000 loop execute immediate 'select '||sq.nm||'.nextval from dual' into dummy; end loop; end loop; end; ![]() |
Friday, 5 February 2010
Oracle : Rolling sequences forward
Posted by
Ook
at
08:30
0
comments
Labels: Oracle
Thursday, 28 January 2010
Powershell : Get inner errors for more info (sometimes)
Statement that fails # Trap { # write-output "herea" # $_.Exception # $err = $_.Exception # while ( $err.InnerException ) # { # $err = $err.InnerException # write-output $err.Message # }; # continue # } ![]() |
Posted by
Ook
at
01:32
0
comments
Wednesday, 20 January 2010
Powershell : IUnable to install CTP3 - Access Denied Error
Reason was a anti-confickr strategy of adding a permission to stop values being changed in a registry key : HKLM, Software\Microsoft\Windows Nt\CurrentVersion\Svchost This has advanced acl perms set to Deny Everyone Set Value ![]() |
Posted by
Ook
at
07:21
0
comments
Tuesday, 12 January 2010
Powershell - Performance Diagnostics reports error
When using powershell to query performance counters (via New-Object Diagnostics.PerformanceCounter) getting an errors (The network path was not found) Fix - Assuming wiondows firewall on the target machine is turned on enable File and Printer Sharing in the exceptions on the target ![]() |
Posted by
Ook
at
08:48
0
comments
Sunday, 27 December 2009
Vmware : Vsphere Console Desktop Shortcut
For Vmware infrastructure :![]() |
Posted by
Ook
at
04:11
0
comments
Labels: VMWare
Monday, 30 November 2009
Windows : What is the NTFS cluster size ?
* Run chkdsk on the drive - chkdsk C: * Cluster size if third line from bottom eg. 4096 bytes in each allocation unit ![]() |
Posted by
Ook
at
03:22
0
comments
Thursday, 12 November 2009
Excel : Bullets in a cell
![]() |
Posted by
Ook
at
07:56
0
comments
Subscribe to:
Posts (Atom)






