This article will give examples of how to drop and recreate a tempfile in oracle that is associated with a temporary tablespace.
Oraask Latest Articles

How to Create Profile Option in Oracle APPS R12
This article will explain the steps to create a profile option in oracle apps r12. Sometimes we need a custom ...

How to Resolve ORA-00904 invalid identifier
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.

How to Resolve ORA-06512: at line
Introduction In this tutorial, we are going to explain how to resolve ORA-06512: at line num error in Oracle.

How to Create VCN in OCI
In this article, we will list the steps needed to create a new VCN (Virtual Cloud Network) in Oracle Cloud Infrastructure - OCI.

How to Print ref cursor Output in SQL Developer
In this tutorial, we will explain how to display ref cursor output in Oracle using SQL Developer step by step. We will use ...

How to Generate DDL Scripts for All Tables in SQL Developer
In this tutorial, we will list all the steps to generate a DDL script for all tables using SQL Developer.

How to Create a Compartment in OCI
When we start working on Oracle Cloud Infrastructure (OCI), we begin with a root compartment, which holds all the cloud resources underneath. However, ...

Import Data from CSV file into Oracle Database Table using (SQL*Loader)
One of the most common tasks is loading data into a database, specifically the Oracle database in our case. There are many different ...

What is the meaning of i, g, and c in Oracle Database Version
Starting from Oracle Database version 8, Oracle has introduced one character that came up with the version number of its databases, e.g., Oracle ...