Dear Readers, In this article, we will see the following Datapump in Oracle 12c. Oracle Datapump was introduced in Oracle 10g. This article provides an overview of the main Data Pump enhancements in Oracle Database 12c Release 1. Oracle Datapump have two utilities They are 1.EXPDP… Read More
SQL*Loader in Oracle 12c SQL*Loader is a utility provided by the Oracle to load the data into Oracle databases from various files like ascii files,textfiles,external files and csv files etc.., SQL*Loader provides two methods for loading data: conventional path load direct path load CONVENTIONAL… Read More
Dear Readers, In this article, we will see the following Difference b/w Common user and Local user in Oracle 12c. Oracle has Introduced Multitenant architecture in the version 12c and also new terminologies for users in container database called LOCAL USER and COMMON USER. Common… Read More
How to perform DATAPUMP operations on standby database by converting SNAPSHOT standby. Data Guard is the name for Oracle’s standby database solution, used for disaster recovery and high availability. This article contains an updated version of 12cR1 Converting physical standby into snapshot standby and… Read More
Hello Readers I Standardized and customized the SecureCRT to group and link the frequently used commands. It will make the Oracle DBA job easy and fast. Download SecureCRT Software binaries using below link. https://www.vandyke.com/cgi-bin/account_login.php?pid=scrt_x64_870 Or Download SecureCRT binaries from Google Drive https://drive.google.com/file/d/1jfGtmKKwPwmOcjO1t5BJoN_b77V09a_q/view?usp=sharing Let me know… Read More
What are the Oracle 12c Pluggable databases? How does a pluggable database work? These are the databases that are stored within the CDB. A PDB is a portable collection of schemas, schema objects, and non schema objects that appears to an Oracle Net client… Read More
How to build ACTIVE STANDBY DATABASE using RMAN DUPLICATE command in ORACLE DATABASE 12c. Data Guard is the name for Oracle’s standby database solution, used for disaster recovery and high availability. This article contains an updated version of the 12cR1 active standby setup… Read More
Dear Readers, In this article, we will see the following Multi-tenant Architecture & Creating database manually in Oracle 12c. Containers in Multitenancy Oracle Database 12c introduced a new feature called “multitenant.” The multitenant feature provides the ability for a single instance to manage multiple databases.… Read More
When to Use MongoDB Is MongoDB right for your application? That depends on the kind of data you have, and what you want to do with that data. NoSQL databases have risen to the occasion when it comes to unstructured data and the kind… Read More
1. Backup the current Stats For Database stats: SQL> Exec dbms_stats.export_database_stats(statown => ‘SYSTEM’, stattab => ‘prod_stats_database_03282018’); For System stats: SQL> Exec dbms_stats.export_SYSTEM_stats(statown => ‘SYSTEM’, stattab => ‘prod_stat_system_03282018’); For Dictionary stats: SQL> Exec dbms_stats.export_Dictionary_stats(statown => ‘SYSTEM’, stattab => ‘prod_stats_dictionary_03282018’); For Fixed Tables stats: SQL> Exec dbms_stats.export_FIXED_OBJECTS_stats(statown… Read More
