How to create Matrix report / Pivot Report using Oracle BI Publisher

Step by step instruction:

1. Make data model using Oracle Reports Developer

2. Generate a XML output

3. Create a blank document in MSWord 

4. Load the XML file from BI Publisher tab

5. Create a simple report using the Table Wizard

6. Change the Properties of the column as per instruction


<?for-each-group:G_DNAME;./DNAME?><?variable@incontext:DNAME_;DNAME?>

<?for-each-group@column:G_DNAME;./JOB?> 

<?for-each-group@cell://G_DNAME;./JOB?><?if:count(current-group()[DNAME=$DNAME_])?><?end if?>

<?current-group()[DNAME=$DNAME_]/EMP?>

Uninstall all Oracle components using the Oracle Universal Installer (OUI).

Run regedit.exe and delete the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE key. This contains registry entires for all Oracle products.

Delete any references to Oracle services left behind in the following part of the registry: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Ora* It should be pretty obvious which ones relate to Oracle.

Reboot your machine.

Delete the "C:\Oracle" directory, or whatever directory is your ORACLE_BASE.

Delete the "C:\Program Files\Oracle" directory.

Empty the contents of your "C:\temp" directory.

Empty your recycle bin.

Calling additional attention to some great comments that were left here:


Be careful when following anything listed here (above or below), as doing so may remove or damage any other Oracle-installed products.

For 64-bit Windows (x64), you need also to delete the HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE key from the registry.

Clean-up by removing any related shortcuts that were installed to the Start Menu.

Clean-up environment variables:

Consider removing %ORACLE_HOME%.

Remove any paths no longer needed from %PATH%.

This set of instructions happens to match an almost identical process that I had reverse-engineered myself over the years after a few messed-up Oracle installs, and has almost always met the need.


Note that even if the OUI is no longer available or doesn't work, simply following the remaining steps should still be sufficient.


https://stackoverflow.com/questions/8450726/how-to-uninstall-completely-remove-oracle-11g-client

 

How to exclude tables during import using impdp 


grant dba to labserp identified by labserp;

CREATE TABLESPACE LABSERP_TS
   DATAFILE 'LABSERP_TS.dbf'
    SIZE 100M
    REUSE
    AUTOEXTEND ON NEXT 10M ;

CREATE OR REPLACE DIRECTORY test_dir1 AS 'E:\personal\';

GRANT READ, WRITE ON DIRECTORY test_dir1 TO labserp;

impdp labserp/labserp  exclude=TABLE:\"IN (\'DO_AUDIT_DETAIL\', \'PR_DAY_WISE_ATTENDENCE_040720\', \'PR_DAY_WISE_ATTENDENCE_070720\', \'PR_DAY_WISE_ATTENDENCE_090720\', \'PR_DAY_WISE_ATTENDENCE_07073PM\', \'AC_DATA_LOG_BK\')\" directory=TEST_DIR1 dumpfile=expdp_28-07-Tue_23.00_PM.dmp logfile=impdpEMP_DEPT.log