Oracle Database

HomeยปTag: Oracle Database

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, 2020August 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, 2020March 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, 2019December 7th, 2006|Categories: Databases|Tags: |2 Comments
Go to Top