Transport Tablespace from Linux to Windows in ORACLE 11g & 10g.

Transport tablesapce from Linux to windows

Transport tablespace from Linux to windows platform step by step. In this tutorial i’m going to show you how Transport tablesapce from Linux to windows platform, in oracle Database we can transport tablespace and Database from one platform to another platform. In this topic i’m using Redhat Linux 6 (64 bit) and Microsoft Windows 7 … Read more Transport Tablespace from Linux to Windows in ORACLE 11g & 10g.

Create Table in SQL

How to create table

What is Table in Database? Tables is a basic unit of data storage created by executing CREATE TABLE statement, this statement comes under in DDL statements. To run create table command the user must have the CREATE TABLE privileges. What is the Naming Rules for Table Creation? Following are the naming rules for table creation. … Read more Create Table in SQL

Restore the SPFILE from the Controlfile Autobackup

How to Restore SPFILE from autobackup? If you have lost the SPFILE (server parameter file), and your Database abnormally shutdown then you will be try to startup you Database but you got an error regarding spfile not found. You can restore spfile from autobackup using RMAN. NOTE:- Database must be in archivelog mode and must … Read more Restore the SPFILE from the Controlfile Autobackup

Share this
Share

How to create DML Trigger

DML trigger

How to create a DML trigger In ORACLE step by step? Here i’m going to show you create a DML trigger for restricting UPDATE statement on “emp” table, After creating trigger if anybody want to change value using update statement then trigger will be automatically fire and showing warning  massage which is you specify inside … Read more How to create DML Trigger

SQL CONSTRAINTS

SQL Constraints

What is SQL Constraints? The SQL Constraints always enforce the rules and prevent invalid data in a table. If Constraint not satisfy it’ll be violated, that means Constraint condition always satisfy for the DML operations, and it’ll be prevent deletion if there are any dependency from another table. Click here to read how to create … Read more SQL CONSTRAINTS

Share this
Share

SQL Statements

SQL STATEMENTS

Hello friends in this article i’m going to discuss about SQL statements. Click here to learn about SQL CONSTRAINTS SQL Statements types? There are five types of SQL Statements, listed below. 1. DR (Data retrieve) SELECT 2. DML (Data Manipulation Language) INSERT UPDATE DELETE MERGE 3. DDL (Data Definition Language) CREATE ALTER DROP TRUNCATE 4. … Read more SQL Statements

Share this
Share

What is SQL, DBMS and RDBMS

What is DBMS and RDBMS

Hello friends, in this article we going to discus what is SQL ( Structure Query Language), DBMS (Database Management System) and RDBMS (Relational Database Management System), also you understand what is the difference between DBMS and RDBMD. You must read about how to use SQL select statements? What is SQL? SQL (Structure Query Language) it … Read more What is SQL, DBMS and RDBMS

Share this
Share

Oracle Data Pump Utility

Data Pump Utility

What is Data Pump Utility? Oracle Data Pump is very fast and high speed utility. Through Data Pump utility we can move data and metadata from one database to another database very fast. Oracle Data Pump flexible, faster and latest alternative to the ‘exp’ and ‘imp’ which is old utilities and used in previous versions. … Read more Oracle Data Pump Utility

Share this
Share

How to create manually Database?

Manually Database Creation

Manually Database Creation. In this post i’m going to show you how to create manually Database step by step and how to create password file and how to configure Enterprise Manager (EM). For manually Database creation we have need a directory structure which is mandatory for every Database. In Oracle every Database have a separate Directory … Read more How to create manually Database?

Share this
Share

How to install VMware tools

install VMware tools

In this article we are going to discus, how to install vmware tools on Linux environment, the vmware tools allow us to make a unity with parent operating system also enable copy & past. So just follow the below steps. STEP 1. Move your cursor upside and click on vm tab then select Install vmware … Read more How to install VMware tools

Share this
Share
Share