Oracle Drop/Delete User with All tables and files

Hi All,

Today I am going to explain the procedure to delete/drop a user in Oracle database along with tables and mapped files for that user tablespace.

Pre-requisites

Oracle database with the following

1. User
2. Tablespace of the user
3. Datafile of the tablespace

Procedure

Drop the user

Syntax: DROP USER CASCADE;
Example: DROP USER sampleuser CASCADE;

Make the tablespace offline

Syntax: ALTER TABLESPACE OFFLINE;
Example: ALTER TABLESPACE sampletablespace OFFLINE;

Drop the tablespace with mapped datafile[s]

Syntax: DROP TABLESPACE INCLUDING CONTENTS AND DATAFILES
Example: DROP TABLESPACE sampletablespace INCLUDING CONTENTS AND DATAFILES

With the above 3 commands, you can make sure that, user and user related data has been completed removed from database.

Hope, it will help to resolve your issue.

Please send your feedback and comments to psrdotcom@gmail.com

Completely uninstall openjdk in RedHat Enterprise Linux (RHEL)

Hi all,

Today, I'll explain how to uninstall completely the openjdk from the RedHat Enterprise Linux (RHEL) machine.

Some of the softwares requires only the Oracle Java and having the openjdk, sometimes causes an issue. So, some users wants to remove the openjdk from the linux machine.

Pre-requisites

• openjdk installed on the machine
• Check for java alternatives, when multiple java versions installed
• #> /usr/sbin/alternatives --config java
• Result with + is the currently selected java for the machine

Procedure

1. Find out the installed openjdk versions

#> rpm -qa | grep java
#> rpm -qa | grep jdk

Sample Output:

java-1.8.0-openjdk-1.8.0.191.b12-1.el7_6.x86_64

java-1.8.0-openjdk-headless-1.8.0.191.b12-1.el7_6.x86_64

2. Remove the all openjdk versions

#> yum remove <>

Example:
#> yum remove java-1.8.0-openjdk-1.8.0.191.b12-1.el7_6.x86_64

#> yum remove java-1.8.0-openjdk-headless-1.8.0.191.b12-1.el7_6.x86_64

Hope, it is useful for you to configure java on your linux machine.

Please send your feedback and comments to psrdotcom@gmail.com