12c

Invisible column in oracle 12c

We have invisible indexes in oracle 11g. But in oracle 12c we invisible column was introuduced.   DEMO:   Lets create a normal table: [crayon-5cbb7fed09f85705412705/] Make a column invisible...

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: [crayon-5cbb7fed0a882922582...

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 ...

Page 2 of 212
Skip to toolbar