How to Find and repair Corrupt block in database Step 1: Below query will show if there is any corrupted block SELECT *  FROM   v$database_block_corruption — will show if any corruped block  Step 2: Below query can give you …

RMAN backup and logical backup With Different User Step 1: Create the user CREATE USER bkp_user IDENTIFIED BY bkp_user DEFAULT TABLESPACE users TEMPORARY  TABLESPACE temp PROFILE DEFAULT;  GRANT CONNECT TO bkp_user;  GRANT exp_full_database TO bkp_user;  GRANT imp_full_database TO bkp_user;  GRANT recovery_catalog_owner TO bkp_user;  GRANT select_catalog_role TO bkp_user;  GRANT CREATE SESSION TO bkp_user;  Step 2: Connect RMAN with the Above Created User …

ERROR Solution : ORA-01442: column to be modified to NOT NULL is already NOT NULL sql> alter table HR.employees modify UID not null; ORA-01442: column to be modified to NOT …

How To Move Table to Different TableSpace   SYNTAX ALTER TABLE table_name move TABLESPACE tablespace_name (INITIAL=64k MINEXTENTS=1 MAXEXTENTS=UNLIMITED);   EXAMPLE ALTER TABLE hr.employee_details move TABLESPACE hr; OR ALTER TABLE hr.employee_details move TABLESPACE hr (INITIAL=64k MINEXTENTS=1 MAXEXTENTS=UNLIMITED);  

What’s New in EBS 12.2.7? By: Steven Chan| Senior Director EBS 12.2.7 is the latest update to E-Business Suite 12.2. It includes functionality enhancements, error corrections, and statutory and regulatory updates in a …

What is Oracle E-Business Suite on Oracle Cloud? By: Nadia Bendjedou| Vice President – EBS Strategy You can think of running Oracle E-Business Suite on Oracle Cloud as running exactly the same Oracle E-Business …

Oracle’s Booming Cloud Business Could Rip And Replace SAP As #1 In Apps Bob Evans , CONTRIBUTOR  Opinions expressed by Forbes Contributors are their own. Oracle founder and chairman Larry Ellison believes …

How To Trace Concurrent Programs CASE 1 : Concurrent Program Tracing without bind variables 1)   Follow the following navigation to enable logging for Concurrent Program Goto Sysadmin > Concurrent > …

Fixing a “Failed” worker  Whenever  a job fails for the 1st time, the job is deferred at the end of the phase and another job is assigned to that worker. …

RapidWiz log files for Oracle Applications Release 12   During installation of Release 12 using RapidWiz, the following log files are created. In case of any errors during the installation, …