We have invisible indexes in oracle 11g. But in oracle 12c we invisible column was introuduced. DEMO: Lets create a normal table: SQL> create table dbatest ( empno number, name varcha...
12c
views_as_tables parameter in datapump of oracle 12c
VIEWS_AS_TABLES parameter has been introduced in datapump of 12c. With this we can export a view at source database and import as table in target database. Create a view: SQL> create view dba_vie...
How to Import data with nologgin option in oracle 12c
A new feature has been added in datapump of oracle 12c. We can import data with nologgin option i.e without generating logs. We sometimes face issue while importing big tables, as it generates lot of ...
How to archive table rows in oracle 12c
In oracle 12c a new feature called In-Database Archiving has been introduced. With this we can archive specific rows of a table as per our requirement. This is very helpful,when table contains lot of ...