How to take the particular table backup using expdp utility

Rameshdba.com

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


In this blog, I will teach you how to take a particular table backup in Linux environments using the Expdp utility.


Step1:logon to the server 

Step2:check all mount points  which location you are going to export

[oracle@oracle backup]$ df -h /u01/schema/backup

Filesystem      Size  Used Avail Use% Mounted on

/dev/sda5        53G   13G   40G  25% /u01

Step 3:find the directory else create the directory

if not You should create one like below

SQL>create directory schema '/u01/schema/backup';


Step4:Enter the below commands at OS level

expdp directory=RAMESH dumpfile=scoot1.dmp logfile=scoot1.log tables=SCOTT.DEPT

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