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
Script – How to find table inside PL/SQL
SELECT owner, object_type, object_name, object_id, status FROM sys.DBA_OBJECTS WHERE object_id IN ( SELECT object_id FROM public_dependency CONNECT BY PRIOR object_id = referenced_object_id START WITH referenced_object_id = (SELECT object_id FROM sys. DBA_OBJECTS WHERE owner = ‘<owner_name>’ AND object_name =’<table>’ AND object_type … Read more
Installing OEM Agent version 11.1.0.1
Oracle is always changing.It never ends.. The other day I was trying to install new OEM agent version 11.1.0.1. And of course, like in the past I just started ./runInstaller command . That did not work and I decided to dig into some documentation ( what I should have done before ) and found it … Read more
Oracle Data Pump vs Update
Here is simple scenario: First I am going to create simple table with two rows and pouplate it with 10000 records: SQL> create table demo.test ( a number, b number); Table created. SQL> begin for i in 1..10000 loop insert into demo.test values (i,1); end loop; end; / 2 3 4 5 6 PL/SQL procedure … Read more
Red Hat Enterprise Virtualization (RHEV)
If you haven’t heard Red Hat released Red Hat Enterprise Virtualization (RHEV). It has a lot of advantages over proprietary virtualization solutions. http://www.redhat.com/virtualization/rhev/ http://www.redhat.com/v/swf/rhev/demo.html
