Anuj Singh Oracle DBA
Tuesday, 16 July 2024
show_dumpfile_info
›
from Web CREATE OR REPLACE PROCEDURE show_dumpfile_info( p_dir VARCHAR2 DEFAULT 'DATA_PUMP_DIR', p_file VARCHAR2 DEFAULT ...
Wednesday, 3 July 2024
Oracle 23ai impotent Link
›
----- DBA Masterclass Links ----- Sign up for the upcoming DBA Masterclass Sessions, and watch past replays on-demand: https://bit.ly/db...
Saturday, 22 June 2024
Oracle new oratab --
›
From web vi aoratab #!/bin/ksh # To view / change current Oracle SID and ORALCE_HOME, PATH # # Biju Thomas - 10/15/97 # Modified ...
Wednesday, 5 June 2024
Oracle partition export and import using datapump
›
Oracle partition export and import using datapump via parfile .... SQL> create user user1 identified by user1; SQL> create user ...
Thursday, 30 May 2024
Listener log data mining with SQL
›
Listener log data mining with SQL ref .. https://connor-mcdonald.com/2019/12/16/listener-log-data-mining-with-sql/ https://www.pythi...
Tuesday, 28 May 2024
Oracle oraset script
›
#!/bin/bash # Sets Oracle environment variables. # Setup: 1. Put oraset file in /etc (Linux), in /var/opt/oracle (Solaris) # 2. Ensure /etc ...
Thursday, 23 May 2024
Oracle sqlplus unix Prompt with colour
›
red export PS1='\[\033[0;91m\]\T \d $(echo $ORACLE_SID ) $\[\033[0m\]' blue export PS1='\[\033[1;46m\]\T \d $(echo $ORACLE_SID...
‹
›
Home
View web version