Blogs about: Oracle 10g
Featured Blog
Not perfect every time
The sql for converting rows to columns has a problem in 9i due to a limitation on sort keys, ora-01467. This can be fixed via this modification: with a as ( select caseid, formname, max(case when name… more →
Ronnie Doggart's Weblog
Producing ORA-08006 with MERGE and ROW MOVEMENT
Todor Botev wrote 1 day ago: Here is what the Oracle Docs say about ORA-08006: ORA-08006: specified row no longer exists Cause: t … more →
Why restore before recover? The new Oracle 10g Backup Strategy
ZyK wrote 2 weeks ago: Delivering Oracle 10g R2 Administration Workshop II we had a closer look at the new recommended back … more →
ASM on windows
Liakat Hossain wrote 2 weeks ago: Creating ASM on windows . step 1: create a windows based service for asm. c:\oradim -new -asmsid +as … more →
ASM on windows
Liakat Hossain wrote 2 weeks ago: Creating ASM on windows . step 1: create a windows based service for asm. c:\oradim -new -asmsid +as … more →
ORA-01555: snapshot too old: rollback segment number 11 with name "_SYSSMU11$" too small
notakerjaku wrote 2 weeks ago: Error occurs during export dumpfile:- ORA-01555: snapshot too old: rollback segment number 11 with n … more →
Import dan Export File Dump Oracle 10g Dengan Datapump
bpdp wrote 3 weeks ago: Tulisan ini sekedar tips kecil untuk mempermudah kalau anda ingin mengekspor suatu file dump di Orac … more →
Backup and Recovery of OCR Demo Part -2
Ritesh Das wrote 3 weeks ago: … more →
Yii dan Oracle 10g
bpdp wrote 1 month ago: Pengantar Tulisan ini akan sedikit menguraikan hal-hal yang diperlukan dan sekedar jalan pembuka jik … more →
data pump export
Liakat Hossain wrote 1 month ago: data pump =============== sql>conn sys as sysdba sql>GRANT CREATE ANY DIRECTORY TO scott; sql … more →
Oracle RAC DBA Openings @ Hyderabad,INDIA
whizhuntjobs wrote 1 month ago: This is Sudhir, Sr.Recruiter from Whizhunt Management Consultancy Services Pvt Ltd., I would like to … more →
How to check tablespace size usage?
Morader wrote 1 month ago: I use following query: select a.tablespace_name "Tablespace", trunc(a.bytes_alloc / 1024 / 1024,2) " … more →
Errors ORA-01565 with ORA-27047
Morader wrote 1 month ago: I got following errors during creation controlfiles: CREATE CONTROLFILE REUSE SET DATABASE “NA … more →
Undocument Oracle parameters
Morader wrote 1 month ago: SELECT a.ksppinm "Parameter", a.ksppdesc "Description", b.ksppstvl "Session Value", c.ksppstvl "Inst … more →
Exadata: Quite a lemon?
sidn wrote 2 months ago: Oracle has one of the largest followings, I am proud to be one of them. Oracle has about half of all … more →
Install Oracle 10g Express Edition
Duwi Agus Hidayat wrote 2 months ago: Untuk meng-Install Oracle 10g Expess Edition, anda bisa dapatkan di Klik Disini langkah-langkah meng … more →
Deleting many records from a big table
Morader wrote 2 months ago: How to delete many rows from a big table? I’m using next way: If some table is the parent in t … more →
Not perfect every time
rdoggart wrote 2 months ago: The sql for converting rows to columns has a problem in 9i due to a limitation on sort keys, ora-014 … more →
Listener password
Liakat Hossain wrote 2 months ago: Setting listener password LSNRCTL> set current_listener x LSNRCTL> change_password Old passwor … more →
Which version of Oracle database is more stable?
dbametrix wrote 2 months ago: Hi, Which version of Oracle database is more stable find out in your real experience working environ … more →
