I must thank my fellow DBA Franky Weber Faust for his publication in Portuguese OTN. Apply the PSU in Standby with RAC database using the standby-first patch apply method. In this article, I introduce how to apply the patch using the standby-first patch apply the method in a DataGuard environment with Oracle RAC 12c, where […]
Articles Tagged: ORACLE 12C
Index (B-tree)
B-tree Index B-tree stands for Balanced Tree in RDBMS. It is commonly used in database and filesystem.The B-tree enables the database to find a leaf node quickly. It is a good example of a data structure for external memory. Telephone directory, library are the best example of B-tree index. Why do we use B-tree? keeps keys in […]
Oracle Database 12c Release 2 (12.2) Installation On Redhat Linux 6
In this post, I’m installing the Oracle Database 12c Release 2 (12.2.0.1.0) software on Oracle Linux 6.4. Only the software is being installed at this point, in preparation for a single database installation which I’ll create later on using the DBCA tool. First and foremost, before you start, make sure your Linux server meets the minimum […]
Long Identifiers In Oracle 12.2
SQL*Plus now supports object lengths of 128 bytes. In previous releases, the object length limit was 30 bytes and if you try to create object with length more than 30, it will throw error as ORA-00972: identifier is too long. Oracle 12.2 increases the maximum size of most identifiers from 30 to 128 bytes, which […]
spool CSV in Oracle 12.2
Now we can spool spool CSV or JSON from Oracle Database. Prior to 12.2 , we can spool as text or html, but from 12.2 onward, the SET MARKUP command now has a CSV option to output data in CSV format. Syntax CSV {ON|OFF} [DELIMI[TER] character] [QUOTE {ON|OFF}] Traditionally you wiill get formatted output (without […]
Display the columns related to redaction in Oracle 12c
SELECT object_owner, object_name, column_name, function_type, function_parameters, regexp_pattern, regexp_replace_string, regexp_position, regexp_occurrence, regexp_match_parameter, column_description FROM redaction_columns WHERE object_owner = DECODE(UPPER(‘&1’), ‘ALL’, object_owner, UPPER(‘&1’)) AND object_name = DECODE(UPPER(‘&2’), ‘ALL’, object_name, UPPER(‘&2’)) ORDER BY 1, 2, 3;
How to make a table read only in Oracle
Oracle 11g allows tables to be marked as read-only using the ALTER TABLE command. ALTER TABLE table_name READ ONLY; ALTER TABLE table_name READ WRITE; Let’s create a table and make it read-only. CREATE TABLE Skant (id NUMBER); INSERT INTO Skant VALUES (1); ALTER TABLE Skant READ ONLY; Any DML statements that affect the table data […]