Introduction: Temporary tablespaces hold temporary data when we perform join or sorting operations. Sometimes these temp tablespaces become full, which ...
Article
Oraask Latest Articles
Article
How to Create Directory in Oracle
How to Create Directory in Oracle
2 mins read
An Oracle database directory is a logical object mapping of a physical folder on the database server file system. We often need to ...
Article
How to Move Table to Another Tablespace in Oracle Database
How to Move Table to Another Tablespace in Oracle Database
4 mins read
This article will explain how to move a table from one tablespace to another in the Oracle database. In some ...
Article
How to Drop and Recreate Tempfile in Oracle Database
How to Drop and Recreate Tempfile in Oracle Database
3 mins read
This article will give examples of how to drop and recreate a tempfile in oracle that is associated with a temporary tablespace.
Article
How to Resolve ORA-00904 invalid identifier
How to Resolve ORA-00904 invalid identifier
4 mins read
This tutorial will explain what is causing the ORA-00904 error to occur and how to resolve the ORA-00904 invalid identifier error in Oracle.
Article
Decoding ORA-06512 at Line Num: The Ultimate Troubleshooting Guide
Decoding ORA-06512 at Line Num: The Ultimate Troubleshooting Guide
4 mins read
Introduction "ORA-06512 at line num" is a common error message that Oracle Database users encounter while executing PL/SQL code. In ...
Article
How to Print ref cursor Output in SQL Developer
How to Print ref cursor Output in SQL Developer
3 mins read
In this tutorial, we will explain how to display ref cursor output in Oracle using SQL Developer step by step. We will use ...
Article
How to Generate DDL Scripts for All Tables in SQL Developer
How to Generate DDL Scripts for All Tables in SQL Developer
2 mins read
In this tutorial, we will list all the steps to generate a DDL script for all tables using SQL Developer.
Article
Import Data from CSV file into Oracle Database Table using (SQL*Loader)
Import Data from CSV file into Oracle Database Table using (SQL*Loader)
7 mins read
One of the most common tasks is loading data into a database, specifically the Oracle database in our case. There are many different ...
Article
What is the meaning of i, g, and c in Oracle Database Version
What is the meaning of i, g, and c in Oracle Database Version
2 mins read
Starting from Oracle Database version 8, Oracle has introduced one character that came up with the version number of its databases, e.g., Oracle ...