AODBA

EXCLUDE/INCLUDE option in expdp - Oracle Database Script EXCLUDE/INCLUDE OPTION: These two OPTIONS can be used IN BOTH expdp OR impdp TO exclude OR include, particular objects OR object_types: Export a schemas AODBA, ...

Table_exists_action option with impdp – oracle database script

September 6, 2019

in Oracle Scripts

by AODBA

TABLE_EXISTS_ACTION option with impdp - Oracle Database Script TABLE_EXISTS_ACTION OPTION IN IMPDP: TABLE_EXISTS_ACTION Action TO take IF imported OBJECT already exists. VALID keywords ARE: APPEND, REPLACE, [SKIP] AND TRUNCATE. TABLE_EXISTS_ACTION=SKIP: This IS the DEFAULT OPTION WITH impdp. I.e IF the the TABLE EXISTS, ...

Sqlfile option with impdp – oracle database script

September 6, 2019

in Oracle Scripts

by AODBA

sqlfile option with impdp - Oracle Database Script It can be used, ONLY WITH impdp. This helps IN generating the DDLs FROM a dumpfile. Suppose We have a DUMP FILE OF TABLE AODBA.DEP_TAB . IF you need the DDL OF...

Expdp with query clause – oracle database script

September 6, 2019

in Oracle Scripts

by AODBA

expdp with query clause - Oracle Database Script --- For exporting table data with query condition ----select * from AODBA.EMP_TAB WHERE created > sysdate -40; -- Parfile cat expdp_query.par dumpfile=test.dmp logfile=test1.log directory=TEST tables=aodba.EMP_TAB QUERY=aodba.EMP_TAB:"WHERE created > sysdate...

Expdp/impdp for tables – oracle database script

September 6, 2019

in Oracle Scripts

by AODBA

expdp/impdp for TABLES - Oracle Database Script -- Create the directory if not present create directory EXPDIR as '/export/home/oracle/ORADUMP' --- Par file for export of multiple tables cat parfile=tables.par dumpfile=tables.dmp logfile=tables.log directory=EXPDIR tables=PROD_DATA.EMPLOYEE, PROD_DATA.DEPT, DEV_DATA.STAGING ...

Expdp/impdp for schemas – oracle database script

September 6, 2019

in Oracle Scripts

by AODBA

expdp/impdp for schemas - Oracle Database Script -- Create the directory if not present create directory EXPDIR as '/export/home/oracle/ORADUMP' -- Par file for export of SCHEMAS(PROD_DATA,DEV_DATA) --cat parfile=schema.par dumpfile=schema.dmp logfile=tables.log directory=EXPDIR schemas=PROD_DATA, DEV_DATA -- Run expdp...

Expdp/impdp with parallel option – oracle database script

September 6, 2019

in Oracle Scripts

by AODBA

expdp/impdp with parallel option - Oracle Database Script -- Create the directory if not present create directory EXPDIR as '/export/home/oracle/ORADUMP' -- Par file for export with parallel degree 4 cat parfile=parallel.par dumpfile=parallel_%U.dmp logfile=tables.log directory=EXPDIR schemas=PROD_DATA parallel=4 ...

Expdp with compression parameter – oracle database script

September 6, 2019

in Oracle Scripts

by AODBA

expdp with compression parameter - Oracle Database Script -- Create the directory if not present create directory EXPDIR as '/export/home/oracle/ORADUMP' -- Below is the parfile for full db export cat parfile=compressed.par dumpfile=schema.dmp logfile=tables.log directory=EXPDIR FULL=Y compression=ALL ...

Enable/disable em express 12c – oracle database script

September 6, 2019

in Oracle Scripts

by AODBA

Enable/disable em express 12c - Oracle Database Script -- Check whether em is enabled or not.(if output 0 means, emexpress disabled) select dbms_xdb.getHttpPort() from dual; select dbms_xdb_config.getHttpsPort() from dual; -- Enable emexpress with https: SQL> exec dbms_xdb_config.sethttpsport(5500); -- Enable emexpress...

Change sysman pwd in oem cloud – oracle database script

September 6, 2019

in Oracle Scripts

by AODBA

change sysman pwd in oem cloud - Oracle Database Script -- Syntax to update sysman password in oms repository ./emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd -new_pwd -- Example (need only existing sys password) ./emctl config oms -change_repos_pwd -use_sys_pwd...

Plugins installed on oms server – oracle database script

September 6, 2019

in Oracle Scripts

by AODBA

Plugins installed on OMS server - Oracle Database Script -- Run from OMS server -- List of plugins installed on OMS server. ./emcli list_plugins_on_server -- List of plugins installed on the target agents. ./emcli list_plugins_on_agent -- List plugins deployed on...

Target list monitored by oem – oracle database script

September 6, 2019

in Oracle Scripts

by AODBA

target list monitored by OEM - Oracle Database Script -- Run from oms server($OMS_HOME/bin) -- List all the target ./emcli get_targets -- List the target types present: ./emcli get_target_types -- List targets of particular target_type(say oracle_database) ./emcli get_targets -targets="oracle_database"...