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 WeblogTodor 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 →
ZyK wrote 2 weeks ago: Delivering Oracle 10g R2 Administration Workshop II we had a closer look at the new recommended back … more →
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 →
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 →
notakerjaku wrote 2 weeks ago: Error occurs during export dumpfile:- ORA-01555: snapshot too old: rollback segment number 11 with n … more →
bpdp wrote 3 weeks ago: Tulisan ini sekedar tips kecil untuk mempermudah kalau anda ingin mengekspor suatu file dump di Orac … more →
Ritesh Das wrote 3 weeks ago: … more →
bpdp wrote 1 month ago: Pengantar Tulisan ini akan sedikit menguraikan hal-hal yang diperlukan dan sekedar jalan pembuka jik … more →
Liakat Hossain wrote 1 month ago: data pump =============== sql>conn sys as sysdba sql>GRANT CREATE ANY DIRECTORY TO scott; sql … more →
whizhuntjobs wrote 1 month ago: This is Sudhir, Sr.Recruiter from Whizhunt Management Consultancy Services Pvt Ltd., I would like to … more →
Morader wrote 1 month ago: I use following query: select a.tablespace_name "Tablespace", trunc(a.bytes_alloc / 1024 / 1024,2) " … more →
Morader wrote 1 month ago: I got following errors during creation controlfiles: CREATE CONTROLFILE REUSE SET DATABASE “NA … more →
Morader wrote 1 month ago: SELECT a.ksppinm "Parameter", a.ksppdesc "Description", b.ksppstvl "Session Value", c.ksppstvl "Inst … more →
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 →
Duwi Agus Hidayat wrote 2 months ago: Untuk meng-Install Oracle 10g Expess Edition, anda bisa dapatkan di Klik Disini langkah-langkah meng … more →
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 →
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 →
Liakat Hossain wrote 2 months ago: Setting listener password LSNRCTL> set current_listener x LSNRCTL> change_password Old passwor … more →
dbametrix wrote 2 months ago: Hi, Which version of Oracle database is more stable find out in your real experience working environ … more →