ORA-00959 Error while trying to drop a tablespace

Scenario: A tablespace has been created in the database through a script using Mixed case.Now we want to drop the tablespace.

We are unable to drop the tablespace even if it is available. The reason is while creating the tablespace the name was specified in mixed case within double quotes as follows


Read More

Recover from a loss of the SYSTEM tablespace on the original location

Recovery is an important process for any kind of organization.   if the database can not recover properly   That is the worst condition of any DBA‘s professional because it causes unlivable loss of an organization.  We have many kinds of solutions to restore the database according to the loss of database. We are going to have […]

Read More

Recover from a loss of a temporary tablespace

This article is about a recovery of temporary tablespace. As we know that Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables. For example, if you join two large tables, and Oracle cannot do the sort in memory (see SORT_AREA_SIZE initialization parameter), space will be allocated in […]

Read More