How to drop all object from Schema in Oracle Database. In this scenario., we are going to drop all the objects under the schema Check the status of database. [oracle@ora21cdb ~]$ sqlplus / as sysdba SQL*Plus: Release 21.0.0.0.0 – Production on Wed Apr 26 16:43:19 2023 Version 21.3.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights Read More

How to generate the ramdon User Password in Oracle Database Note: – Password should be 12 characters in length or as per the organization. – Password should include at least one uppercase letter, one lower case letter, one number and one special character (&*(){}|[]+<>!@#$%^?). SQL> select translate(dbms_random.string(‘a’,… Read more..

Overview of Profile Management with real-time scenario in Oracle Database 11gR2 (11.2.0.4) A Profile is a database object & it’s named set of resource limits to such as restrict database usage by a system user. Examples of resources that need to be managed are Disk storage space, I/O bandwidth to run queries, CPU power, CPU Read More

How to login another database user without knowing a password in Oracle database 11gR2 This operation can perform by DBA, if & only if it’s approved from higher management & it’s not a good practice to break the Oracle Security rule. Consider we want to perform the activity with different user but you don’t have Read More

How to login a database user without knowing a password in Oracle database 11gR2 This method also try to login into the MIR1 user without knowing the password, after completion of the task later we can restore the same password for MIR1. [oracle@testdb ~]$ !sq sqlplus / as sysdba sys@TESTDB> sho user USER is “SYS”

Query to delete all Objects from specific user in Oracle database 11gR2 Database Status sys@TESTDB>select instance_name,status,version from V$instance; INSTANCE_NAME STATUS VERSION —————- ———— —————– testdb OPEN 11.2.0.4.0 Connect to specific user “MIR” sys@TESTDB>connect… Read more..