How to move Oracle database datafiles to another path on Oracle LinuxBelow is how to move Oracle database datafiles to another filesystem on Oracle Linux.Apr 23, 2021Apr 23, 2021
How to use batch scripts in Oracle GoldenGate command promptWe can use batch scripts to run series of commands in Oracle GoldenGate command prompt. See the example below.Apr 23, 2021Apr 23, 2021
How to install Oracle GoldenGate 12c on Oracle ExadataBelow is “How to install Oracle GoldenGate 12c on Oracle Exadata”.Apr 23, 2021Apr 23, 2021
How to install vnc server on Oracle LinuxThis is how to install vnc server on Oracle Linux.Apr 22, 2021Apr 22, 2021
How to remove an Oracle database manuallyThis is how to remove an Oracle database manually.Apr 22, 2021Apr 22, 2021
How to use Active Session History in Oracle databaseOracle database keeps track of the what is going on database. It captures the SQL commands consuming database time with snaps taken during…Apr 22, 2021Apr 22, 2021
Automatically give grants to a database role after creating a table in Oracle databaseYou can use the below database trigger to automatically give grants to a database role after creating a table in Oracle database.Apr 20, 2021Apr 20, 2021
ORA-20000: Unable to analyze TABLE “USER_0001”.”TABLE_0001",ORA-20000: Unable to analyze TABLE “USER_0001”.”TABLE_0001", insufficient privileges or does not exist.Apr 20, 2021Apr 20, 2021
How to schedule an export job in the crontabBelow is how to create and schedule an export job in the crontab.Apr 20, 2021Apr 20, 2021
How to take a compressed export in Oracle databaseThis is how to take a compressed export in an Oracle database.Apr 19, 2021Apr 19, 2021