Monthly Archives: December 2012

DATA PUMP: EXCLUDE / INCLUDE TABLE IMPORT

EXCLUDING TABLES DURING DATA_PUMP IMPORT: impdp USERNAME/PASSWORD schemas=USERNAME directory=backup dumpfile=full.dmp EXCLUDE=TABLE:\”IN \(\’TABLE1\’,\’TABLE2\’,\’TABLE3\’,\’TABLE4\’,\’TABLE5\’,\’TABLE6\’\)\” impdp ultimus/ultimus schemas=ultimus directory=db_back dumpfile=AFT_EOD.dmp EXCLUDE=TABLE:\”IN \(\’IMG_SIGNATORY_IMAGE\’,\’IMG_SIGNATORY_IMAGE_DEL_LOG\’,\’IMG_SIGNATORY_INFO\’,\’IMG_SIGNATORY_VERIFY_LOG\’,\’IMG_BACH_CLG_HIST_IN\’,\’IMG_BRM_INST\’,\’IMG_NFT_AUTH_LOG\’\)\” EXCLUDING TABLES DURING DATA_PUMP IMPORT – USING “LIKE ” COMMAND: impdp USERNAME/PASSWORD schemas=USERNAME directory=backup dumpfile=full.dmp EXCLUDE=TABLE:\”like ‘IMG_%%’\” EXCLUDE=TABLE:\”IN \(\’EMP\’,\’DEPT\’\)\” INCLUDING TABLES … Continue reading

Posted in Oracle backup & recovery | Leave a comment

How To Display Iconic Images Using Forms

How to display images/icons on the buttons Steps are Example 1: Using a jar file =====================1] Gather all the icon files in a directory. For this copy all the icons files (gif or jpg) to a folder e.g c:\icons or … Continue reading

Posted in Oracle Application server | 1 Comment

Configure a Reports Server *without* SSO Authentication

. Back up the following files first     $ORACLE_HOME/reports/conf/rwservlet.properties     $ORACLE_HOME/reports/conf/<Reports Server>.conf     2. Assume SINGLESIGNON=YES in rwservlet.properties 3. Modifiy the $ORACLE_HOME/reports/conf/<Reports Server>.conf file to disable this specific Reports Server’s authentication. FROM     <security id=”rwSec”>         <!–property name=”securityUserid”   value=”%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%” confidential=”yes” … Continue reading

Posted in Oracle Application server | Leave a comment

In RAC environment from 11.2 onwards Backup Or Snapshot controlfile needs to be in shared location

Hdr: 13780443 11.2.0.3 RDBMS 11.2.0.3 RMAN PRODID-5 PORTID-46 Abstract: CONTROLFILE BACKUP MUST RESIDE ON SHARED DEVICE WITH RAC DATABASE PROBLEM: ——– Controlfile backup, even using sql ‘alter database backup controlfile…’ must create a backup on a shared device, otherwise will … Continue reading

Posted in Oracle backup & recovery | Leave a comment