Oracle Database

HomeยปTag: Oracle Database

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 [...]

By |2020-06-05T11:46:18-07:00Modified: June 5, 2020|Published: August 4th, 2007|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 [...]

By |2020-05-22T11:50:06-07:00Modified: May 22, 2020|Published: August 4th, 2007|Categories: Databases|Tags: , |19 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 [...]

By |2020-06-12T04:46:42-07:00Modified: June 12, 2020|Published: March 18th, 2007|Categories: Databases|Tags: , , , |8 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 [...]

By |2019-07-03T19:56:19-07:00Modified: July 3, 2019|Published: December 7th, 2006|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 [...]

By |2020-06-11T10:47:07-07:00Modified: June 11, 2020|Published: November 8th, 2006|Categories: Databases|Tags: |0 Comments
Go to Top