0 Comments

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

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 the application team’s testing completed and this database seems not to be in use.    Key Points to remember before dropping the databases.   => […]

 1,488 Total Views

0 Comments

How to Mount Windows Share on Linux using CIFS 5 (1)

How to Mount Windows Share on Linux using CIFS In this article, we will perform steps on How we can mount the Windows Shared folder on Linux Server using CIFS rpm or use smbclient command to get (for download) or put (for upload) files between Windows and Linux Server. Please note we will be using […]

 913 Total Views,  1 Views Today

0 Comments

How to Find User’s Privileges in Oracle 0 (0)

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 important to perform day-by-day activities according to their roles & responsibilities. System Privileges Role PrivilegesObject Privileges  Privileges are authentication to execute any activities in the database […]

 722 Total Views,  1 Views Today

0 Comments

How to Setup Passwordless SAMBA Share in Linux for Windows Server Access 0 (0)

Setup Passwordless SAMBA Share in Linux for Windows Server Access In this article, we will perform the required steps to setup Passwordless SAMBA Share on Linux Server. This can permit everyone on a windows machine to get entry to this without a set off for password. This form of requirement generally comes from the Window […]

 807 Total Views,  1 Views Today

0 Comments

Database MySql 8 Installation using Yum Repository Method 4 (1)

Database MySql 8 Installation using Yum Repository Method Database MySql can be installed using the below 3 different methods. 1) Yum Installation – The easiest and fastest method to install MySql but provide no control over the installation. 2) RPM Bundle – Need to download RPM Bundle and install MySql rpm manually. 3) Using Binaries […]

 1,067 Total Views,  2 Views Today

2 Comments

Important Technical Links Powered by DBsGuru 5 (4)

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. Technical blogs are the source of vast information not about databases but its related product like middleware, PL/SQL, replication methodology, and so on. We are […]

 2,968 Total Views,  2 Views Today

0 Comments

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 action on the production table without using Restore and Recover command on PRIMARY DATABASE.Recovering the table from the standby database will also eliminate any required […]

 1,522 Total Views

0 Comments

Solving ORA-00742 Log read detects lost write in Oracle 5 (4)

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 1 sequence, You can encounter this error if your Oracle Database machine was suddenly stopped without proper shutdown command due to some unavoidable problem like […]

 3,030 Total Views,  1 Views Today

2 Comments

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

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 30th Jun 2023. In the currently available release, Oracle 19c is a long-term supported database by Oracle where it will support till 30th April 2027  […]

 1,506 Total Views,  1 Views Today

0 Comments

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

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 due to performance issues, statistics locked on the table, disable statistics in the database, before/after manual analyze on tables or gather statistics, before/after migration, etc. […]

 1,777 Total Views,  1 Views Today