Query(Row) Level Export data pump and Import data pump
Description:- Allows you to specify a query clause that is used to filter the data that gets export and import.When the query is to be applied to a specific table,…
Read MoreSchema Level Export data pump and Import data pump
Description:– Performing the import of Schemas of your database is as simple as exporting them. Similar to expdp Schema export, we use SCHEMAS parameter to perform the import of the…
Read MoreRecover User and Table using Flashback Database
Description:- Oracle Flashback Technology provides a set of features that support viewing and rewinding data back and forth in time. The flashback features offer the capability to query past versions…
Read MoreHow to Create and Manage Partition Tables in Oracle
Description:- Partitioning is powerful functionality that allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer…
Read MoreOracle Database Cloning
DESCRIPTION: In this blog,we are going to learn Oracle Database Cloning. INTRODUCTION: The cloning operation creates a copy of the database data files, and creates new online redo log files…
Read MoreRECOVER THE LOST DATAFILE USNIG FLASHBACK SCN CONCEPT
RECOVER THE LOST DATAFILE USNIG FLASHBACK SCN CONCEPT In this blog we are going to learn about how to recover the lost data file by using flashback database in SCN method You can restore any lost or dropped datafile with flashback and rman after a tablespace is dropped. First of all, create a tablespace, user a table and insert data as your wish. CONNECT TO THE DATABASE AND…
Read MoreBackup files through using to create Database in Oracle 12c
Description:- Backup your databases and use the restore and recover features to restore a database to the same or another system or to recover database files.It is important to create…
Read MoreEXPORT AND IMPORT DATAPUMP IN REMAP_DATA & REMAP_SCHEMA
EXPORT AND IMPORT DATA PUMP IN REMAP_DATA & REMAP_SCHEMA In this blog we are going to learn about EXPORT AND IMPORT in data pump using remap data and remap schema…
Read MoreORA-01157: CANNOT IDENTIFY/LOCK DATA FILE %S – SEE DBWR TRACE FILE
DESCRIPTION: In this blog,we are going to resolve ORA-01157 error in database. Cause: The background process was either unable to find one of the data files or failed to lock…
Read MoreORA – 19809 & ORA – 19804
DESCRIPTION: In this article, we are going to see how to resolve ORA – 19809 & ORA – 19804. CAUSE: By default RMAN backup goes to Flash Recovery Area if…
Read More