ORA-00933: SQL command not properly ended

ORA-00933: SQL command not properly ended

Prior to diving into this error, it’s important we discuss how Oracle processes queries logically and in what order. Oracle has a couple of rules as to how it executes each query in a specific processing order. Oracle processes a query as below: Gathers rows...
How to Create an RMAN Recovery Catalog in Oracle 18c

How to Create an RMAN Recovery Catalog in Oracle 18c

Recovery Catalog Purpose: The RMAN recovery catalog is a schema created inside of a new or existing database that is used to store metadata about Oracle databases. It’s recommended by XTIVIA that the catalog be created in its own dedicated database due to the...
Database vs Instance vs Schema vs User

Database vs Instance vs Schema vs User

Today I wanted to talk about some terminology that applies to multiple database platforms, however, I want to talk specifically to how it relates to the Oracle RDBMS. These four words seem to cause a lot of confusion and are often misused. The specific terminology or...