How to drop the oracle database

Rameshdba.com

 The contents are of my own testing and deployments. Not guaranteed that these might work in your environment. Please test before usage.


Summary: In this session, I will teach you How to drop the oracle database.

Login to the server;

Check the services and confirm the DB name from the application owner.

Set the environment and confirm the DB:

Note: Before dropping the database please confirm the output 

SELECT NAME FROM V$DATABASE 




Down the database 



Startup nomount restrict 



Now drop the database 


                                                    Thanks for your time!!






0 Comments

DELETE Statement in ORACLE DB— Step by Step Internal Flow with classroom example.

by
Imagine your Oracle database like a school, and you’re Teacher decides to remove a student (row) from the classroom(table). Let’s see how the journey works step by step: 1)Classroom = Oracle Table 2)Students = Rows (Records) 3)Class Teacher = Oracle Server Process 4)Attendance Register = Data Dictionary User fires DELETE statement: DELETE FROM students WHERE grade = 'D'; Internal Processing Steps: Client Process Sends DELETE Statement to Server Process The teacher receives a request to remove a student from the classroom. Syntax Check (Parsing) The teacher checks if the request is grammatically correct — proper command, keywords, and a semicolon. Semantic Check Teacher verifies if the classroom exists and whether the condition (like grade = 'D') makes sense. Object Resolution Teacher confirms that the ‘students’ classroom (table) exists in the school records (data dictionary). Optimization Decides the fastest way to find those students — by roll number, grade, or al...
Image