Home » Page 7

FNDLOAD command

INTRODUCTION TO FNDLOAD CONFIGURATION FILE The contents of the configuration file are at the heart of the loader operation since they specify the structure of the data and the access methods to use to move the data between the data file and a database. A configuration file has the form: configuration_file ::= item { item …

FNDLOAD command Read More »

How to check Tablespace in Oracle -Size,Free space,datafiles ,growth

How to check tablespace in Oracle To list the names and various other parameters of all tablespace in a database, use the following query on the DBA_TABLESPACES view: SELECT TABLESPACE_NAME “TABLESPACE”, EXTENT_MANAGEMENT,FORCE_LOGGING,BLOCK_SIZE,SEGMENT_SPACE_MANAGEMENTFROM DBA_TABLESPACES; With CDB Databases, you need to connect to individual PDB and execute the query to check the tablespace. If you want to …

How to check Tablespace in Oracle -Size,Free space,datafiles ,growth Read More »

How to perform Installation of an EBS 12.2 Vision Instance

Step-by-Step Installation of an EBS 12.2 Vision Instance R12.2 is the latest release in Oracle applications. Here we will be giving the snapshots and steps for the R12.2.0 installation. I will be giving here steps for multi-node installation of an EBS 12.2 Vision Instance The installation is similar to the previous release except for some …

How to perform Installation of an EBS 12.2 Vision Instance Read More »

Steps to clear Production credential in cloned EBS instance

Invalidating all the passwords in the database (1) Start the database clone for the first time startup restrict (2) Clear all production credentials from the cloned database( This step is not mandatory, we can avoid it also) update SYS.user$ setpassword = translate(password,’0123456789ABCDEF’,’0000000000000000′)where type#=1 and length(password) = 16/update APPLSYS.FND_ORACLE_USERID setENCRYPTED_ORACLE_PASSWORD=’INVALID’/update APPLSYS.FND_USER setENCRYPTED_FOUNDATION_PASSWORD=’INVALID’,ENCRYPTED_USER_PASSWORD=’INVALID’/commit; (3)Shutdown the database shutdown …

Steps to clear Production credential in cloned EBS instance Read More »

How to perform DML operations on Oracle View: Insert, Update, delete

DML operations like insert, update, and delete are allowed in Oracle views with certain restrictions. Let’s check in this post to update the view in Oracle, insert into view Oracle, delete from view in Oracle DML on view in Oracle For example, Let’s first create the TEST view. Create view emp_data  as select e.empno,e.ename,e.sal,e.deptno,d.dname From …

How to perform DML operations on Oracle View: Insert, Update, delete Read More »

Scroll to Top