DATABASE

Step by Step Drop Database Manually in Oracle 5 (2)

December 30, 2020

Step by Step Drop Database Manually in Oracle Sometimes we need to drop/delete the database, especially for the test and development databases. Usually, we drop test or development database once…

Loading

📌
0💬 read more

How to Find User’s Privileges in Oracle 3 (2)

December 27, 2020

How to Find User’s Privileges in Oracle In this article, we are going to find all forms of privileges of users in Oracle.  Commonly users have the below types of access in databases which are…

Loading

📌
0💬 read more

Important Technical Links Powered by DBsGuru 5 (5)

December 22, 2020

Important Technical Links Powered by DBsGuru About Us DBsGuru is a group of experienced DBA professionals and serves the database and its related community by providing technical blogs, projects, training….

Loading

📌
4💬 read more

How To Recover Table from Drop/Truncate/Delete done on Primary using Flashback on a Standby 5 (3)

Recover a Table from Drop/Truncate/Delete done on Primary using Flashback on a Standby In this article, we will learn steps needed to perform recovery of User wrong operation like delete/drop/truncate…

Loading

📌
0💬 read more

Solving ORA-00742 Log read detects lost write in Oracle 4.9 (9)

December 21, 2020

Solving ORA-00742 Log read detects lost write in thread 1 sequence 149 block 38233 In this post we will see how to solve ORA-00742: Log read detects lost write-in thread…

Loading

📌
0💬 read more

Oracle Database 21c is Available Innovation Release 5 (2)

December 17, 2020

Oracle Database 21c Available Innovation Release Oracle Database 21c is the most latest version released by Oracle which is an innovation release where it’s available only for Premier Support (PS) till…

Loading

📌
2💬 read more

How to Find Last Analyzed date on Tables, Partition, and Subpartition in Oracle 5 (1)

December 14, 2020

Find Last Analyzed date on Tables, Partitions, and Subpartitions in Oracle Here we are going to demonstrate how to find the last analyzed date on tables in Oracle. Some time…

Loading

📌
0💬 read more

Step by Step manually creation of an Oracle 19c Database 5 (5)

December 12, 2020

Step by Step manually creation of an Oracle 19c Database on Linux 7 In the previous article, we have demonstrated Step by step silent installation of oracle 19c on Linux 7, …

Loading

📌
4💬 read more

How to check the last 10 startup times of the database along with timezone in Oracle 5 (1)

December 11, 2020

The last 10 startup times of the database along with timezone in Oracle Sometimes we have to find when the database is started with which timezone especially when the database…

Loading

📌
0💬 read more

Step by step silent installation of Oracle 19c on Linux 7 5 (3)

December 2, 2020

Step by step silent installation of Oracle 19c on Linux 7 As everyone is aware of the oracle database installation. oracle database installation can be done through 2 methods. Here…

Loading

📌
6💬 read more