DATABASE CREATION Oracle Database can create by using the following 3 methods Manual database creation OMF method (Oracle Managed database Files) DBCA method (Database Configuration Assistance) Steps to create database in manual method. Declare or specify variables or set up environmental variables:… Read More
Introduction Clustering adds high availability to your database by distributing changes to different servers. In the event that one of the instances fails, others are already available to continue serving. Clusters come in two general configurations, active-passive and active-active. In active-passive clusters, all writes are… Read More
About MySQL replication MySQL replication is a process that allows you to easily maintain multiple copies of a MySQL data by having them copied automatically from a master to a slave database. Advantages of replication in MySQL include: Scale-out solutions – spreading the load among… Read More
TRANSPORTABLE TABLESPACE IN ORACLE Transportable Tablespace is used to move large amount of data between… Read More
Hadoop has many distributions and every distribution has a stack or you can say a collection of technologies/framework that work in conjunction with Hadoop and is knows as HADOOP ECOSYSTEM. Below is the hadoop ecosystem. Please note there are a plethora of technologies and distributions… Read More
MySQL Replication Setup Replication in MySQL. You will have to setup Master and Slave server. All read-writes to the DB could go to your Slave Server. Advantage of having Replication is you can take a backup from your slave server without interrupting Master server,… Read More
Installing Multiple MySQL The need to have multiple instances of MySQL (the well-known mysqld process) running in the same server concurrently in a transparent way, instead of having them executed in separate containers/virtual machines. MySQL provides a tool to facilitate the execution of… Read More
Oracle provides a trial cloud account worth USD 300 to individuals and organizations to test the cloud services. This is a good starting point to be familiar and have a hands on with oracle cloud services. The trial account provides complete spectrum of services to play with. Sign up… Read More
Different options in Export and Imports Schema export and import using remap_schemas. 1) create directory dpump as ‘/u02/dpump’; 2) grant read,write on directory dpump to system;
|
1 |
expdp user/password directory=dpump dumpfile=export.dup logfile=export.log schemas=scott |
For importing schema : 1) Cretae directory dpump as ‘/u02/DATAPUMP’; 2) grant read,write on directory… Read More
MySQL MySQL belongs to relational database management system (RDBMS Software). MySQL is one of the most widely using open source relational database. MySQL was started developing by Michael Widenius “Monty” in the year 1979. At that time it named as UNIREG. It’s an in-house database tool… Read More
