ORA-01682: read-only DB cannot allocate temporary space in tablespace string
Cause: Temporary space (usually for sorting) could not be allocated in either main storage or a tempfile. An attempt was made to allocate the space from the tablespace named, but the database is opened read-only. The database open requires a sort work space.
Action: Either allow sufficient workspace in main storage (SORT_AREA_SIZE initialization parameter), or create a temporary tablespace before making the database read-only. Use ALTER TABLESPACE ADD TEMPFILE statement to add temporary files to the temporary tablespace.
ORA-01683
Custom Search


More Oracle errors
TNS-00001INTCTL: error while getting command line from the terminal
PLS-00370OTHERS handler must be last among the exception handlers of a block
TNS-00015INTCTL: error while closing terminal input channel
ORA-00750database has been previously mounted and dismounted
PGU-41045missing call name in DEFINE TRANSACTION
ORA-06516PL/SQL: the Probe packages do not exist or are invalid
LPX-01073[XQST0073] Cyclic import sequence
ORA-09214sfdone: I/O error detected
PLS-00666Only index by binary_integer/pls_integer associative arrays allowed here
OCI-22307type to alter is not a user-defined type
LSX-00292value "~1S" is greater than maximum "~2S" (~3S)
ORA-01136specified size of file string (string blocks) is less than original size of string blocks
ORA-12075invalid object or field
IMG-00902VIR signature free failed
ORA-06440ssaio: the asynchronous read returned incorrect number of bytes
LSX-00135invalid min/max Occurs for <all> element, must be 0/1
ORA-02398exceeded procedure space usage
NNL-00994Responses received: number
ORA-38783Instance recovery required.
ORA-46065Attribute value not specified




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
ORA-01682read-only DB cannot allocate temporary space in tablespace string