How to take particular tablesapce export in oracle

Rameshdba.com

Summary: This tutorial will teach you how to take a particular tablespace in the Oracle DB. 


1)Connect the Oracle database and confirm which tablespace you will export.



2)Fine the size of the tablespace and verify the mount point. 

3)we are going to take USERS tablespaces.

PS C:\Users\priya> expdp dumpfile=user.dmp logfile=user.log tablespaces=USERS;


4)Verifed the logs there are no issues were found. since we are done.


Thanks

Rameshbabu DBA







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