In Oracle 12.2, We can split partitions or subpartitions online without impacting the DML statements. SQL> select partition_name,read_only,high_value from dba_tab_partitions where table_name=’ORDER_TAB’; PARTITION_NAME READ HIGH_VALUE ——————————– —- ——————————————————————————– CREATED_2105_P10 NO TO_DATE(‘ 2015-11-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIA CREATED_2105_P11 NO TO_DATE(‘ 2015-12-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIA CREATED_2105_P12 NO TO_DATE(‘ 2016-01-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIA CREATED_2105_P8 NO TO_DATE(‘ […]
Articles Tagged: ORACLE 12C2
Local/Shared Undo mode in oracle 12.2 multitenant database
There are two undo modes in oracle 12.2 Multitenant database 1. Local undo mode 2. Shared undo mode Local undo mode: In this mode, each container ( i.e PDB ) in multitenant will have their own active undo tablespace. Share Undo mode: In this mode, There will be only one undo tablespace for the instance. […]
Creating Oracle Database 12cR2 with DBCA in text mode
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. A database is a collection of information that is organized so that it can be easily accessed, managed and updated.Data is organized into rows, columns, and tables, and it is indexed to make it easier to find relevant information. Data […]
Creation of Listener via NETCA in text mode
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. We know NetCA Oracle command line for configuring the Oracle listener. NetCA stands for (Network Configuration Assistant). NetCA is used as a configuration assistant launched by the OUI at install time. It is more suitable for a batch mode for silent installations. I […]
Installing Oracle Database 12cR2 in text mode
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. This is an article about Installing Oracle Database 12cR2 in text mode using the response file. Oracle Database 12cR2 Installation Process via response file This is the response file I used, feel free to download it: db_install.rsp. Adjust the response file according to […]
Physical Backup
What is physical Backup? The operating system saves the database files onto tape or some other media. This is useful to restire the system to an earlier point whenever needed. In its simplest form, a physical backup is the movement of all data from one raw device to another; in the context of file system […]
Logical Backup
What is a logical backup? Logical backups are backups in which the export utility (for example Exp) uses SQL to read database data and then export it into a binary file at the operating system level. You can then import the data back into a database using the import utility (Imp).The Oracle Export Utility can […]
Index In Oracle
We are living on the planet with the seven billion population.Each and every human being’s have some information. Data is an important factor in the business’s world. Every day in business’s operation we deal with data. It can be structure and un-structure data. All the report of business prepare with the help of data. We take a […]
Upgrading Oracle Grid Infrastructure 11gR2 to 12cR2
Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) Grid Infrastructure to Oracle 12cR2 (12.2.0.1) on the same server. This upgrade process was done on Linux 6 (x86_64). 1. Before the GI upgrade backup the OCR manually. This could be used in downgrading the GI from 12.2.0.1 to 11.2.0.4 later one. If you […]
How to check Cluster Name
To check the cluster name use, $ORA_CRS_HOME/bin/cemutlo -n