Alter Table in Oracle

1. Create Table 
2. Alter Table

In this second tutorial i'll be explain how to manage created table

     2. Alter Table
             Here there are many way to manage created table.
             Using this statement you can change the table's column, name of column as well as table,
      change the constraint, datatype, etc.
             The table must be in your own schema, or you must have ALTER object privilege on the table, or you must have ALTER ANY TABLE system privilege.

        Syntax :

ALTER TABLE	table_nm [	ADD	(column1 datatype constraint,..,columnn datatype constraint)	|
		MODIFY	(column1 datatype constraint,..,columnn datatype )	|
		DROP	COLUMN   column_name	|
		RENAME	COLUMN column_name TO new_name	]  ;

How to Create Table in Oracle

In this tutorial i'll show you many different type to manage and create the table.

1. Create Table 
2. Alter Table

 1. Create Table
      Table is basic storage unite of data, and oracle table can store data in row column format.     
      Using this statement you can create table in oracle.
      Before you create table you must have CREATE TABLE system privilege, and one more think
you he owner of the table must have a quota for the tablespace that contains the table, or the UNLIMITED TABLESPACE system privilege.

  Syntax :

 CREATE TABLE tbl_name
  (
   ColumnName1 Datatype [Constraint],
   ColumnName2 Datatype [Constraint],
   .
   .
   .
   ColumnNamen Datatype [Constraint]
  );

What is Data Pump in Oracle 11g

In This tutorial i'll be show you how to manage data pump and as well as how many way to many it in oracle 11g R2

  This is server-based facility to manage high speed data and mata-data in oracle database.
  This datapump infrastructure is callable via DBMS_DATAPUMP in PL/SQL package.
  Oracle 11g database provide two tools as below,

•  Through command line.
• EXPDP
• IMPDP
•  Through web based called grid infrastructure.

  The oracle data pump have many benefits and some new features as below,

1. Data selection and Fine-grained.
2. Parallel execution.
3. Explicit specification of database version.
4. Network mode in distributed environment.
5. Estimation of export job space consumption.
6. Remapping capabilities.
7. Compression of data during a data pump export.
8. Data and Metadata compression.
9. Ability to export XML type data as CLOB.
10. Legacy mode to support old import and export files.

What is Flashback Transaction Qurey in oracle 11g r2

In this tutorial i'll show you how Oracle Flashback Technology works and as well as inside how to use flashback version query.

In Oracle there are Seven Technology as given below.
   In the Flashback Technology, It include database related group of features that manage a state of your data in the database.

   This Technology works on the undo data so you can get all those transaction, query as well as data from undo segments thus, your can recovery your data which had been lost or damage as well as you can see the query which had been perform on a specific time or SCN. 

1. Flashback Query.
2. Flashback Transaction.
3. Flashback Transaction Query. 
4. Flashback Version Query.
5. Flashback Table.
6. Flashback Database.
7. Flashback Data Archive [ Total Recall ]. 

 Some few advantages given below,

• See the query had been perform.
• See the transaction information.
• See the past state data.
• You can perform rollback entire table without performing database recovery.
• If you delete or drop the table by mistake and you perform DDL or commit without knowing the previous transaction.  and so on...

Here i'll be show you 3^rd  Flashback Transaction Query as below,

   Using this tool you can view changes to made to the database at transnational level.
The main banifit is that you do not need to audit of your database transaction because of directly you can get the what transaction is perform in this database.
 
   You can get all the view by using FLASHBACK_TRANSACTION_QUERY [ no prefix like V$, GV$ , .. ]  is a dynamic performance view.  

What is Flashback Table in oracle 11g R2

In this tutorial i'll show you how Oracle Flashback Technology works and as well as inside how to use flashback version query.

In Oracle there are Seven Technology as given below.
   In the Flashback Technology, It include database related group of features that manage a state of your data in the database.

   This Technology works on the undo data so you can get all those transaction, query as well as data from undo segments thus, your can recovery your data which had been lost or damage as well as you can see the query which had been perform on a specific time or SCN. 

1. Flashback Query.
2. Flashback Transaction.
3. Flashback Transaction Query. 
4. Flashback Version Query.
5. Flashback Table.
6. Flashback Database.
7. Flashback Data Archive [ Total Recall ]. 

 Some few advantages given below,

• See the query had been perform.
• See the transaction information.
• See the past state data.
• You can perform rollback entire table without performing database recovery.
• If you delete or drop the table by mistake and you perform DDL or commit without knowing the previous transaction.  and so on...

Here i'll be show you 5^th  Flashback Version Query as below,

  This technology can recover your entire table to a specific time without having point in time recovery.
  The database online no required for shutdown or on mount mode.

What is Flashback Version Query In Oracle 11g R2

In this tutorial i'll show you how Oracle Flashback Technology works and as well as inside how to use flashback version query.

In Oracle there are Seven Technology as given below.
   In the Flashback Technology, It include database related group of features that manage a state of your data in the database.

   This Technology works on the undo data so you can get all those transaction, query as well as data from undo segments thus, your can recovery your data which had been lost or damage as well as you can see the query which had been perform on a specific time or SCN. 

1. Flashback Query.
2. Flashback Transaction.
3. Flashback Transaction Query. 
4. Flashback Version Query.
5. Flashback Table.
6. Flashback Database.
7. Flashback Data Archive [ Total Recall ]. 

 Some few advantages given below,

• See the query had been perform.
• See the transaction information.
• See the past state data.
• You can perform rollback entire table without performing database recovery.
• If you delete or drop the table by mistake and you perform DDL or commit without knowing the previous transaction.  and so on...

Here i'll be show you 4^th  Flashback Version Query as below,

    In this Technology you can see all the of two row between two times.
    And you can also see the transaction that change the row.

What Is Flashback Query In Oracle 11g R2

In this tutorial i'll show you how execute Oracle Flashback Technology in Oracle 11g R2.

In Oracle there are Seven Technology as given below.
   In the Flashback Technology, It include database related group of features that manage a state of your data in the database.

   This Technology works on the undo data so you can get all those transaction, query as well as data from undo segments thus, your can recovery your data which had been lost or damage as well as you can see the query which had been perform on a specific time or SCN. 

1. Flashback Query.
2. Flashback Transaction.
3. Flashback Transaction Query. 
4. Flashback Version Query.
5. Flashback Table.
6. Flashback Database.
7. Flashback Data Archive [ Total Recall ].

   Some few advantages given below,

• See the query had been perform.
• See the transaction information.
• See the past state data.
• You can perform rollback entire table without performing database recovery.
• If you delete or drop the table by mistake and you perform DDL or commit without knowing the previous transaction.  and so on...

Here i'll be show you only 1^st Flashback Query as below.
 This Technology provide to you perform a  Recovering lost of data by using timestamp or SCN [ System Change Number ].

Migrating Oracle Single Instance to RAC in Oracle 11g R2

In this tutorial i am show you How to Convert oracle single instance to multipal instance [ RAC ]

You can convert single to multipal instance through may way like

1.  DBCA
2. IMPORT/EXPORT 
3.  Manual
4.  Streams and Datapump
5. Grid Control
6. RConfig  and some more..

Here i am show you 1^st one that is DBCA
  It's some steps as given below

1. Connect with your running database as a sys user with sysdba privileges .
2. Start your database [ If your database is close ].
3. Take a database backup. [ Because of your doing convert your database single instance to multipal instance in this time may be resize any some failure at that time it will be helpful to doing a restore operation and come back ].
4. Start DBCA.
5. Then Create a template of your current running database.

• Start DBCA.

Create Image Copy Backup using RMAN in Oracle 11g R2

In This tutorial i am show you how can we create an Image file backup using RMAN.

There are many method to create a backup as below,

1. IMAGE COPY Backup
2. WHOLE DATABASE Backup
3. INCREMENTAL Backup
4. ARCHIVAL [ HOT ] Backup

  here i am show you IMAGE COPY Backup  

• It is a bit for bit duplication of datafile or tablespace.
• It is a extra copy of datafile, logfile, controlfile.
• It just like operating system [ OS ] command like copy, cp, .. doing any file copy one place to another place.

Configuring Database Backup Using RMAN in Oracle 11g

In This Session I'll be show to how configure a Database Backup using RMAN Utility

    

               1.   First connect with rman with target database

             Some basic steps for connect rman as below.

a.       Set environment variable

b.      Set oracle home

In where your oracle database is running

c.       After use rman command

What is ASM and it's Architecture in Oracle 11g r2

Overview

• This features come since last oracle 10g.
• The first foll ASM (Automatic Storage Management ) is one power-full tool that will help to oracle database file storage management into disk or tap drive. 
• The ASM is really cool way to store database file, it's one of many feature of oracle that me-makes oracle database the premier relational database management system.

   

Description  

• The ASM installed as a separate instance as part of gird infrastructure [ RAC / Standalone ] environment.
• It don't including data-file, data-dictionary but it can read PASSWORD file.
• If you want to connect with ASM instance then super user privilege is required [ SYSASM]  and it use PASSWORD file for authenticate.
• If you want to access this functionality you must create ASM instance before your database start.