Saturday, February 1, 2025

MoidIITDocID-646: How to create 19c database using “create database” command? --Moid

›
Click here for the 19c document. Moid
Tuesday, November 12, 2024

Dynamic

›
select (select 'Space_GIVEN_to_DB' from dual) as Note, round(sum(d.bytes)/1024/1024/1024 + (sum(t.bytes)/1024/1024/1024),2) as Siz...

MoidIITDocID-640: Steps to get Oracle Certified (SQL Fundamentals, OCA / OCP)? --Moid Muhammad

›
As of 11/12/2024 Oracle Database SQLExam Number: 1Z0-071 Oracle Database Administration I Exam Number: 1Z0-082 Oracle Database Administratio...
Friday, August 23, 2024

MoidIITDocID-634: How to start GUI tools on Linux when you sudo to other user? --Moid Muhammad

›
Click here for the document. Moid Muhammad kewords: GUI, xclock, xming, dbca
Monday, August 5, 2024

MoidIITDocID-633: How to check the patch level of an oracle database? --Moid

›
Click here for the document.   Moid Muhammad
Sunday, July 7, 2024

MoidIITDocID-632: How to use tmux (instead of screen) in Linux? --Arshia Jabeen

›
tmux list-sessions tmux new-session -s MMpatching tmux attach-session -t  MMpatching Click here for the full document Thanks, Arshia Jabeen
Friday, December 15, 2023

MoidIITDocID-629: How To Get Table Growth History Information? --Moid Muhammad

›
Click here for the document. Moid table size segment size 
Wednesday, September 27, 2023

MoidIITDocID-628: How to upgrade 12c database to 19c using Autoupgrade? --Arshia Jabeen

›
Click here for the link. by Arshia Jabeen. Keywords: Moid oracle 19c autoupgrade rac data guard ASM

MoidIITDocID-627: How to upgrade 12c standalone database to 19c using DBUA? --Arshia Jabeen

›
Click here for the document. Arshia Jabeen Keywords: Moid oracle 19c upgrade Arshia  migration export import data pump tesla MyTravelsPro.co...
Saturday, September 16, 2023

MoidIITDocID-625: How to load Scott Schema in Oracle database? --Arshia Jabeen

›
Click here for the document, Thanks, Arshia Jabeen. Keywords: create scott schema, run script
Sunday, August 27, 2023

MoidIITDocID-624: How to start xclock (GUI tools) after switching user to oracle in Linux? --Moid Muhammad

›
Click here for the document. Moid
Wednesday, August 23, 2023

MoidIITDocID-623: Shell script that loop through tnsnames.ora to execute SQL script in multiple databases --Moid Muhammad

›
Click here for the document.   Moid Muhammad Keywords: .sql run SQL Script multiple databases servers parameter change across 

MoidIITDocID-622: How to schedule sql script on Linux DB server? --Moid Muhammad

›
Click here for the link. Moid Muhammad Keywords: crontab execute schedule oracle sqlplus