Dbms_xplan by Granville Bonyata
I am extremly busy these days and do not have any time to blog.That’s why my friend Granville Bonyate decided to write few small posts.Here is the first on in series. Having worked with Oracle for many (twenty!) years, I sometimes find new features released several years ago that I didn’t catch at the … Read more
Resolving Oracle specific errors ( ORA-01031, ORA-00942 etc.)
I lost a count how many times I run into ORA-01031 error .Since I am the one executing the query I can see which SQL statement I am running and then focus on specific objects to find missing privilages. It gets more difficult when end-user get this error.Thanks to Oracle events this is easy to resolve. … Read more
Disabling Oracle Streams Propagation when nothing else works
It’s been a while since I wrote any post .. I need vacation too Here is very short one but useful tip for folks that are using Oracle Streams. I know everyone is talking about GoldenGate but trust me Oracle Streams are good solution if you do not have budget for GoldenGate.Oracle is working very hard … Read more
Export / Import data over db link – using dbms_datapump and dbms_file_transfer packages
– Datapump FULL MODE EXPORT – DECLARE h1 NUMBER; — data pump job handle job_state VARCHAR2(30); — job state status ku$_Status; — data pump status job_not_exist exception; pragma exception_init(job_not_exist, -31626); BEGIN h1 := dbms_datapump.open(operation=>’EXPORT’,job_mode=>’FULL’, remote_link=>”, job_name=>NULL, version=>’COMPATIBLE’); dbms_datapump.add_file( handle=>h1, filename=>’test.dmp’, directory=>’DPUMP_DIR’, filetype=>dbms_datapump.ku$_file_type_dump_file); dbms_datapump.add_file( handle=>h1, filename=>’test.log’, directory=>’DPUMP_DIR’, filetype=>dbms_datapump.ku$_file_type_log_file); dbms_datapump.start_job(h1); job_state := ‘UNDEFINED’; BEGIN WHILE (job_state != … Read more
Oracle GoldenGate and Encrypted Tablespaces (TDE) in 11.2
To make GG work with encrypted tablespaces you have to apply database patch: Patch 10395645 for Oracle 11.2.0.2. mkstore -wrl ./ -createEntry ORACLE.SECURITY.CL.ENCRYPTION.ORACLEGG Supply shared secret for GG ( not wallet password).Last step is to supply wallet password.Copy ewallet.p12 file to other nodes ( if running RAC but not sharing wallet location ). Do not … Read more
Visitors to this site
