DATABASE_LINK PARAMETER A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database system. You can query a table or view…
Read MoreIn this blog, We are going to learn about recovering online redo log files without any backup Step 1: Starting Up the database, SQL> startup ORACLE instance started. Total System…
Read MoreSteps to recover a loss of all online redo log files using RMAN Every instance of an Oracle database has an associated online redo log to protect the database in case of an…
Read MoreHere I am going to explain about how to create a Instance in cloud, Step 1: Provide the instance name as your suitable: Step 2 : Click the change Image…
Read MoreDescription:- 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 MoreDescription:– 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 MoreDescription:- 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 MoreDescription:- 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 MoreDESCRIPTION: 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 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 More