Migration of a table partition or sub-partition to a different tablespace no longer requires a complex procedure in Oracle 12c. When an “online” clause is specified, all dml operations can be performed without any interruption on the partition|sub-partition which is involved in the procedure. No dml operations are allowed if the partition|sub-partition is moved offline.…
Leggi tutto
Multiple indexes on the same column Until the release Oracle 11g was not possible to create more indexes on the same column of a table. Starting from release Oracle 12c, you can create multiple indexes on the same column as long as the index type is different. However, only one type of index is usable…
Leggi tutto
There are many articles on the web explaining how to create, duplicate or plug/unplug a Pluggable Database (PDB) into a Container Database (CDB), e remarkable new feature in Oracle 12c Database. A few of them show how to open and use the Oracle 12c Enterprise Manager Express, the new web graphical administration application created “out-of-the-box”…
Leggi tutto
This Article show how to manual upgrade 11.2.0.3 Oracle database ti non-plugged Database 12c Starting from database 11203 SQL> select instance_name,version,statup_time,status from v$instance; INSTANCE_NAME VERSION STARTUP_T STATUS ————- —————————- ———- DB11 11.2.0.3.0 28-JAN-14 OPEN Below Minimum database version that can be directly upgraded to Oracle 12c Release 1 (12.1) Source Database …
Leggi tutto
Oracle Database File System (DBFS) was introduced in 11g R2 release on top of the XML DB (shortly, XDB) features. The concept is simple: DBFS is a tablespace whose contents are documents (specifically LOB columns) directly accessible (i.e. mounted) as an external file system. In Oracle 11g R2 the only way to do it is…
Leggi tutto
The new Oracle SQL Developer 4.0 (released on december 2013) has some great new features for DBAs, as it becomes the main administration platform instead of Oracle Enterprise Manager Database Control for Oracle Database 12c. OEM Database Control is actually disappeared in Oracle Database 12c, because it is substituted by: – Oracle Enterprise Manager Express,…
Leggi tutto
Talking about Cloud means talking about consolidation. This process started with Oracle release 11g virtualization that allowed to share servers and their resources. When the company will shift their mind from a traditional management concept to the Cloud, Oracle 12c with the new multitenant architecture will supply this requirement based on reliability and scalability. The…
Leggi tutto
Below are described installation step of Oracle Database Database 12c on Oracle Enterprise Linux 6. New Pluggable Database Features is chosen below. Install_Oracle_database12c
Commenti recenti