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

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

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