Request from Application team do the schema refresh in 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.

In this blog, I will teach you how to Schema refresh activity 

Step1:logon to the server 


Step2:check all mount points and archive location before going to start to refresh


Step3:Check the export log which is the dump we will use.

Note:1 I hope No error in that export log.

Note:2 In this case I am going to use full db backup (expdp)

Step4:

Find the directory name and source and target schema name!

Source: SCOOT

Target: RAMESH

We should take the output of this source schema for validation purposes. 



[oracle@oracle backup]$ impdp  directory=babu dumpfile=fulldatabase1.dmp logfile=import_schemas.log1 remap_schema=SCOTT:RAMESH


Import: Release 12.1.0.2.0 - Production on Fri Apr 14 23:58:26 2023


Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.


Username: system

Password:

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/******** directory=babu dumpfile=fulldatabase1.dmp logfile=import_schemas.log1 remap_schema=SCOTT:RAMESH

Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER

Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER


Once Completed the import we need to cross-check the validation in target as well!


                                                    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