Category: Oracle Database 12 c
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. some examples … SQL> ALTER TABLE table_name MOVE PARTITION|SUBPARTITION partition_name TO tablespace tablespace_name; Move a table partition|sub-partition to a new tablespace offline. SQL> ALTER TABLE table_name MOVE PARTITION|SUBPARTITION partition_name TO tablespace tablespace_name UPDATE INDEXES ONLINE; Move a table partition or sub-partitioning online maintaining any local/global...
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 / visible at a given time. To test the indexes invisible, you must set the init.ora parameter: optimizer_use_use_invisible_indexes = true; Not using INVISIBLE clause will result in the error: ORA-01408: such column list already indexed An example: create unique index test_idx1 on test_tab (id1); index...
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” in every Oracle 12c database. When you create a CDB during SW installation or using DBCA, Oracle automatically configures Oracle EM Express on port 5500, so you can access it typing in your browser: https://porfirio.localdomain:5500/em where “porfirio.localdomain” is the name of your host. Well, although...
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 Target Database 10.2.0.5 12.1.x 11.1.0.7 12.1.x 11.2.0.2 or higher 12.1.x The following database versions will require an indirect upgrade path: Source Database Intermediate Upgrade Path for Target Database Target Database 11.2.0.1 —-> 11.2.0.2 or higher —-> 12.1.x 11.1.0.6 ...
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 via FUSE (Filesystem in Userspace) software, only available for Linux and Solaris platforms. Moreover, the DBFS configuration and mount was a bit complex. Oracle 12c introduces support for HTTP, FTP and WebDAV protocols, simplifying the setup process and widening its accessibility. The DBFS creation process...
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, web-based basic administration tool completely integrated into the DB – Oracle SQL Developer 4.0, java client full administration tool, automatically installed in any Oracle client and server installation Oracle SQL Developer 4.0 has a new DBA tab (Menu View -> DBA) from which you can...
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 multitenant architecture simplifies consolidation process in the Cloud. Starting from Oracle 12c it is possible to manage many databases as one, without any change in the application management. Perform an upgrade or database patching has the advantage of being able to be made one for...
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