Oracle PL/SQL ORA-00947 Not Enough Values Error
In Oracle database, the following error message may appear when an incorrect SQL statement is used, in SQL [...]
How to Rename or Move Oracle Tablespace Datafile to Another Location
Oracle database does not provide an easy user interface to rename a datafile of tablespace, nor database administrator [...]
How Drop Tablespace and Recover Oracle Database When Accidentally Delete Datafile
Accident may happens, even though it's costly one. This is especially the case in Oracle database, which stores [...]
How to Remove and Drop Datafiles from Tablespace in Oracle Database
Oracle RDBMS databases stores data logically in the form of tablespaces and physically in the form of data [...]
How to Escape Characters in Oracle PL/SQL Queries
Oracle databases reserve some special characters with specific meaning and purpose within Oracle environment. These reserved characters include [...]
Duplicate, Copy or Backup Tables in MySQL, MariaDB, Oracle, PostgreSQL, DB2 and SQLite with Create Table As SQL
In Oracle, PostgreSQL, DB2, MySQL, MariaDB and SQLite database system, there is a nice command feature called Create [...]
Delete, Remove or Drop Oracle Stored Packages with Drop Package
Oracle Package is an object in Oracle database that allows developers and designers to group procedures and functions [...]
ORA-00942 Table or View Does Not Exist Oracle Error
Sometime when you compile an object or package or view in Oracle, or execute some PL/SQL statements on [...]
Oracle ORA-01658 Unable to Create INITIAL Extent for Segment in Tablespace Error
When inserting records into Oracle database by SQL statements, creating new tables, importing backup dump into Oracle database [...]
Create, Add or Split Oracle Database Partition Fails with ORA-14080 Error
Oracle table partitioning is important for optimum performance of the database, as it allows Oracle to process the [...]