Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Problem: When attempting to pull data from sql server with db link in Oracle database, ORA-600 error occurs. Reason: Setting the cursor_sharing parameter to force …
Read More »
ORACLE
ORA-04052: error occured when looking up remote object
When using dblink in Oracle 11.2.04, we get ORA-04052 error when we want to create an object with the query result from dblink. To …
Read More » Oracle Memory Components(SGA and PGA)
Oracle stores the following components in Memory. Program Code Connected sessions even if not active Information required during Query Execution. For example, if the query …
Read More »How To Run Backup Job Manually On Oracle
First, We connect to the node that the database is running with ssh. We see a list of backup jobs with the following command. …
Read More »How To Change Backup Retention AND Delete Obsolete Backup On RMAN
First, we connect to the node where the database is located with ssh. After loading the database’s profile, we connect to RMAN with the …
Read More »How To Check If There Is a Dictionary-Managed Tablespace On Oracle Database(Extent Management Control)
Extent Management Control can be LOCAL or Dictionary Based. If local, the information in the bitmaps in the datafile is used. If Dictionary Based, …
Read More »How To Move The Temp Tablespace to Another Diskgroup On Oracle
In some cases, you may need to move the TEMP tablespace to another diskgroup if there is no space left in the ASM or because …
Read More »How To Create a Restore Point On Oracle
With the flashback database we can use the restore point to return the database to a time in the past. For more detailed information …
Read More »What is FLASBACK DATABASE And How To FLASHBACK
Using the FLASHBACK database, we can return the database to a time or a SCN number in the past. You can think of FLASHBACK …
Read More »What is logging_clause On Oracle(LOGGING or NOLOGGING)
With the logging_clause parameter, we can specify whether the database objects are to be logged in the redo log when they are created, using …
Read More »