DELETE FROM our_table
WHERE rowid not in
(SELECT MIN(rowid)
FROM our_table
GROUP BY column1, column2, column3... ;
Monday, May 19, 2008
Delete Duplicate Rows in Oracle
Wednesday, May 14, 2008
Sun Volume Maintenance
1- Check volumes by metastat to see is there a mirror or submirror which contains not OK state(Last Erred|Needs Maintenance|Resyncing) like below:
metastat d5
d25: Submirror of d5
State: Resyncing
Size: 8395200 blocks
Stripe 0:
Device Start Block Dbase State Hot Spare
c1t1d0s5 0 No Resyncing
2- Check disk needs maintenance with format analyze or fsck commands.
3- If error repaired re-enable submirror with metareplace command:
metareplace -e d5 c1t1d0s5
after the command, submirror state change to Resyncing and if there is no hard error it will become OK.
Complete Help @ Sun
metastat d5
d25: Submirror of d5
State: Resyncing
Size: 8395200 blocks
Stripe 0:
Device Start Block Dbase State Hot Spare
c1t1d0s5 0 No Resyncing
2- Check disk needs maintenance with format analyze or fsck commands.
3- If error repaired re-enable submirror with metareplace command:
metareplace -e d5 c1t1d0s5
after the command, submirror state change to Resyncing and if there is no hard error it will become OK.
Complete Help @ Sun
Tuesday, May 13, 2008
Microsoft Mary, Mike and Sam Voice SAPI 5.0
To install additional voice for Microsoft Text to Speech 5.0 (TTS) download and install the following package from Microsoft:
http://download.microsoft.com/download/speechSDK/SDK/5.1/WXP/EN-US/speechsdk51.exe
If the engine is not installed download engine 5.1 and install this first:
https://www.cepstral.com/downloads/public/other/SAPI_5.1_installer.msi
http://download.microsoft.com/download/speechSDK/SDK/5.1/WXP/EN-US/speechsdk51.exe
If the engine is not installed download engine 5.1 and install this first:
https://www.cepstral.com/downloads/public/other/SAPI_5.1_installer.msi
Microsoft Mary, Mike and Sam Voice SAPI 5.0
To install additional voice for Microsoft Text to Speech 5.0 (TTS) download and install the following package from Microsoft:
http://download.microsoft.com/download/speechSDK/SDK/5.1/WXP/EN-US/speechsdk51.exe
If the engine is not installed download engine 5.1 and install this first:
https://www.cepstral.com/downloads/public/other/SAPI_5.1_installer.msi
http://download.microsoft.com/download/speechSDK/SDK/5.1/WXP/EN-US/speechsdk51.exe
If the engine is not installed download engine 5.1 and install this first:
https://www.cepstral.com/downloads/public/other/SAPI_5.1_installer.msi
Subscribe to:
Posts (Atom)