What is Audit Trail? Audit Trail (Oracle EBS Auditing) is a way of keeping track of changes made to important data in Oracle Application tables. Audit Trail keeps a history of the following three questions:1. What changed2. Who changed it3. When did the change take placeThis can be done on a row by row basis […]
How to Setup Oracle EBS Auditing Read More »
Oracle allows you to rename existing columns in a table. Use the RENAME COLUMN clause of the ALTER TABLE statement to rename column i,e alter table rename column in oracle Syntax ALTER TABLE table_name RENAME COLUMN old_name to new_name; Let’s see this example SQL> CREATE TABLE DEPT_MASTER ( dept_nr NUMBER UNIQUE, dept_name varchar2(100) NOT NULL, dept_status NUMBER(1,0) NOT NULL,
alter table rename column in oracle database Read More »
We often need to check the status of Workflow Agent listener , WF Java Deferred Agent Listeners in Oracle EBS environment. Sometime a transaction might be struck somewhere and we need to trouble shoot. The queries given in the below post will help in checking about workflow related settings SQL to check the AQ setup
SQL to check Workflow Agent Listeners are running Read More »
Oracle Database 19c, is the long term support release of the Oracle Database 12c. It belongs to the family Oracle Database 12.2.0.x and 19c is basically Oracle Database 12.2.0.3.Premier and Extended Support for the Oracle 19c is through to March 2023 and March 2026 respectively. You can download Oracle database 19c from the below linkDownload
Oracle Database 19c new features Read More »
Remote Desktop Protocol (RDP), developed originally by Microsoft, is a network protocol that provides a way for people to get access to a computer remotely with a nice lightweight user interface along with input devices like keyboard and mouse. Both Windows 7 and 8 come with a native Remote Desktop Client that lets you connect
Awesome Free Remote Desktop Manager Read More »
Critical data are stored in database and data leaks can jeopardize the organization. So database security is very important. Database Security has always been a concern for a Database Administrator. However, Oracle Database is very much secure, even then there are gaps which has to be filled by DBA to make Oracle Database Secure. Oracle
Top 10 Oracle Database Security Best Practices Read More »
