How to change Oracle Database NLS DATE FORMAT
Here is the below statement. alter system set nls_date_format=’dd.mm.yyyy hh24:mi:ss’ scope=spfile
Read MoreHow to Run sql statements in all PDBS
Oracle catcon.pl program is used to run a SQL scripts or SQL statements in all PDBS . $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -u SYS/****AhAhpassword-changed*** -d /export/home/oracle/scripts -l /export/home/oracle/scripts/logs -b give-write_ps give-write_ps.sql -u username/password…
Read MoreHow to find last modified table in oracle.
Here is the query below. set linesize 500; select TABLE_OWNER, TABLE_NAME, INSERTS, UPDATES, DELETES, to_char(TIMESTAMP,’YYYY-MON-DD HH24:MI:SS’) from all_tab_modifications where table_owner<>’SYS’ and EXTRACT(YEAR FROM TO_DATE(TIMESTAMP, ‘DD-MON-RR’)) > 2010 order by 6;…
Read MoreHow to catch DDL statements oracle database.
CREATE TABLE AUDIT_DDL ( DDL_DATE date, OSUSER varchar2(255), CURRENT_USER varchar2(255), HOST varchar2(255), TERMINAL varchar2(255), IP_ADDRESS VARCHAR2(100), module varchar2(100), owner varchar2(30), type varchar2(30), name varchar2(30), sysevent varchar2(30), sql_txt varchar2(4000) ) tablespace…
Read More