Jun 30, 2013
Oracle Database 12c installation on linux
1.1K

Oracle Database 12c installation on linux

Oracle 12c Database installation step by step procedure on Linux: 1) Install OEL 5.7 Linux using the following link Oracle Enterprise Linux 5.7 Installation Here my hostname [root@12cdb ~]# hostname 12cdb.oracle.com 2) create user and group [root@12cdb /]# groupadd dba [root@12cdb /]# useradd -g dba oracle 3) Create required directory structure [root@12cdb /]# mkdir -p /u01/app/oracle/product/12.1.0 4) Copy...
Jun 28, 2013
Oracle Database 12c New Features
599

Oracle Database 12c New Features

Hi Guys, Oracle 12C Database has Released.  You can download it from edelivery.oracle.com. It comes with plug and play concept. Pluggable database: – Oracle provided metadata and data is kept in the container database (CDB). – User metadata and data is kept in the plugable database (PDB) . – One container...
Jun 10, 2013
export empty tables in oracle 11g using datapump
902

export empty tables in oracle 11g using datapump

Export empty tables in oracle 11g using datapump Allocate an extent to an empty table using below command then do the export and import. ALTER TABLE <table_name> ALLOCATE EXTENT;