Polymorphic Table Functions in Oracle Database 18c

https://www.youtube.com/watch?v=VPX5MwHeC-4

Oracle Database 18c New Features in one Image

The following map contains a high-level summary of the key Oracle Database 18c new features.Compared to Oracle Database 12.2, 18c has 134 new features in different focus areas. [Please zoom in to see the below image clearly] For detailed information about all new features, please refer to the :Oracle Database 18c New Features Guide We … Continue reading Oracle Database 18c New Features in one Image

Oracle Database 12.2.0.1 Release Updates (RUs) and Release Update Revisions (RURs)

Following is a list of all RU (Release Updates) and RUR (Release Update Revisions) issued for the Oracle Database 12cR2 (12.2.0.1) since Jul-2017 till today 20-Jun-2021. Please zoom-in to see the above picture clearly, or see it partitioned below: Please note that: - Both RU & RUR are released quarterly (Jan, April , Jul & … Continue reading Oracle Database 12.2.0.1 Release Updates (RUs) and Release Update Revisions (RURs)

Oracle Single-Instance Database Creation in a Clustered Environment

https://www.youtube.com/watch?v=LTXFohjMwqY

ORA-38760 While starting an Oracle Database

This is a quick post about an issue that I faced while trying to start one database yesterday. When I was trying to open one 12cR1 database, I got the following error: SYS SQL>alter database open;alter database open*ERROR at line 1:ORA-38760: This database instance failed to turn on flashback database The database status was "mounted": … Continue reading ORA-38760 While starting an Oracle Database

Is it possible to map one Tablespace to many Tablespaces with impdp?

I got this question from one of my clients. He is going to migrate one database from one platform to another. In this database many users are sharing the same tablespace. For example: In the current database, all application users are sharing the tablespaces “USERS” The client wants to change this, so as each schema … Continue reading Is it possible to map one Tablespace to many Tablespaces with impdp?

Loading Data into Oracle Database from text CSV files

In this post we are going to load data from text files (formatted as CSV “comma separated values”) into oracle database (12.1) using 3 different techniques: Oracle SQL LoaderOracle SQL DeveloperOracle sqlcl command line utility. We will just touch the above techniques; you still need to drill down for more options and more details. Environment: … Continue reading Loading Data into Oracle Database from text CSV files

The beauty of Visualization with Oracle Database

https://youtu.be/3N2wgayry4g ThanksAhmed