Oracle Forensics
By: Ashwani Kumar
Pages
(Move to ...)
Home
▼
Pages
(Move to ...)
Home
▼
Sunday, September 14, 2025
Daily DBA Task related queries
›
###############Grep Ora- error from Alert log:################# grep 'Ora-' alert_db.log |tail Only 5 lines with timings grep -A5 ...
Sunday, August 31, 2025
SQL script that retrieves all privileges of a specific user.
›
Below SQL script that retrieves all privileges of a specific user in an Oracle database, including: System privileges Object privile...
How to find the priveleges under the role.
›
Below statement find the roles created by DBA. select * from dba_roles where ORACLE_MAINTAINED !='Y'; ROLE PASSWORD ...
Thursday, August 14, 2025
User Management : How to create user "ASHWANI" who has full access to all objects in a specific schema, "METALS", in your Oracle database.
›
How to create user " ASHWANI " who has full access to all objects in a specific schema, " METALS" , in your Oracle dat...
Saturday, June 14, 2025
How to copy files from multiple servers to staging server and merge them into one consolidated file using shell script (Pull Method)
›
Below script can be used to scp all the csv files to staging server and merge them into single csv file. servers=("srv1" "sr...
›
Home
View web version