How to create the Database using DBCA method?

Rameshdba.com

  Summary: in this tutorial, you will learn how to Create the Oracle Database using DBCA methods.


Step1:To Login to the server set the Oracle Variable then fire the DBCA (Database Configuration assistant) command to enable the dbca process.


Step 2:

You have to select the Create database option in the first point.



Step3:

Here You have to select the database name and set the password for database. 

Note: if you want containers database you have to select the "Create As Container Database" Option and provide the Pluggable database name as well! 



Step4:

Check the all the information then proceeds the oracle database installation! 



Step5:

Once All done its showing like this then click on close!


Step6:

Once Completed Need to verify like this below.


 

                                                   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