Blue
  • Archives

  • Pages

  • Enter your email address to follow this blog and receive notifications of new posts by email.

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