How to drop and recreate TEMP Tablespace in Oracle 9i/10g/11g
How to drop and recreate TEMP Tablespace in Oracle 9i/10g/11g
How to drop and recreate TEMP Tablespace in Oracle 9i/10g/11g
If you cloned a database and need to run both instances with the same db_name from one $ORACLE_HOME i.e.:
To find out the version of MySQL server using command line on localhost run the following:
Following the update of the Oracle databse or running some oracle scripts, an error occurs ORA-27140: attach to post/wait facility failed
ORA-00376: file 17 cannot be read at this time and ORA-01110: data file 17: '/oracle/XXX/sapdata2/prd_14/prd.data14'
This tutorial explains how you can set, change and reset (if you've forgotten the password) MySQL root passwords.
ORA-20000: index "SAPSR3"."/xxxxxxxxxxxx" or partition of such index is in unusable state
How to rename a dataFile in Oracle.
The ALERT_QUE is used by the Grid Control and DB Control Management Agents to monitor server-generated alerts
Query dba_ts_quotas to see users' quota per tablespace
After an instance failure or SHUTDOWN ABORT, you can`t start your database. At startup you`ll get this messages:
Here is a procedure to move PSAPTEMP temporary tablespace. It's for windows, but you can translate for Unix.