Introduction Oracle user is the base of Oracle EBS ERP; Like creating a user from the front-end (Application), sometimes ...
Post
Oraask Latest Articles
Post
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 ...
Post
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.
Post
How to Create Profile Option in Oracle APPS R12
How to Create Profile Option in Oracle APPS R12
2 mins read
This article will explain the steps to create a profile option in oracle apps r12. Sometimes we need a custom ...
Post
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.
Post
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 ...
Post
How to Create VCN in OCI
How to Create VCN in OCI
3 mins read
In this article, we will list the steps needed to create a new VCN (Virtual Cloud Network) in Oracle Cloud Infrastructure - OCI.
Post
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 ...
Post
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.
Post
How to Create a Compartment in OCI
How to Create a Compartment in OCI
1 mins read
When we start working on Oracle Cloud Infrastructure (OCI), we begin with a root compartment, which holds all the cloud resources underneath. However, ...