Oracle Database

ยปTag:Oracle Database

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 Plus or in anywhere that send SQL queries to the databases such as stored procedure or external programs. PL/SQL: [...]

By | 2017-01-11T16:38:26+00:00 January 11th, 2017|Categories: Databases|Tags: |1 Comment

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 can easily move or relocate the datafile to another location or directory that different from original location on creation [...]

By | 2016-12-09T08:39:39+00:00 December 9th, 2016|Categories: Databases|Tags: , |2 Comments

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 the database objects physically in data files on hard disk. Fast hand administrators may accidentally delete some of the [...]

By | 2016-12-09T08:39:39+00:00 December 9th, 2016|Categories: Databases|Tags: , |19 Comments

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 files. The datafiles are added to the tablespaces as database space requirement grows bigger. However, there are several reasons [...]

By | 2016-12-09T08:39:39+00:00 December 9th, 2016|Categories: Databases|Tags: , |0 Comments

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 _ (underscore) wild card character which used to match exactly one character, % (percentage) which used to match zero [...]

By | 2016-12-09T08:40:15+00:00 December 9th, 2016|Categories: Databases|Tags: , |2 Comments

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 Table As which allows easy duplicating of a table with data from another or a few other tables. The [...]

By | 2016-12-09T08:40:19+00:00 December 9th, 2016|Categories: Databases|Tags: , , , |8 Comments

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 into common groups, typically based upon their functionality. Package can be treated as the container for functions and procedures. [...]

By | 2016-12-09T08:40:41+00:00 December 9th, 2016|Categories: Databases|Tags: |0 Comments

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 table, or when running an Oracle program or application, the following error my occurs: ORA-00942: table or view [...]

By | 2016-12-09T08:40:41+00:00 December 9th, 2016|Categories: Databases|Tags: |6 Comments

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 or when manipulating tables or data in the Oracle database, the following error may occurs: ORA-01658: unable to create [...]

By | 2016-12-09T08:40:57+00:00 December 9th, 2016|Categories: Databases|Tags: |2 Comments

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 specific and independat partition or part that is smaller in size, instead of entire full table or database. However, [...]

By | 2016-12-09T08:41:07+00:00 December 9th, 2016|Categories: Databases|Tags: |0 Comments

Pin It on Pinterest