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-00261Interchange Name Community Link Down Time Remaining (secs)
PGU-00143variable has not been defined
ORA-10614Operation not allowed on this segment
RMAN-06094datafile string must be restored
ORA-31089schema "string" does not target namespace "string"
NNL-00996OK responses received: number
ORA-38460filtering based on datatype "string" not supported for XML Tags
PGA-20906invalid conversation id: no matching conversation was found
NNC-00052client and server protocol versions are incompatible
ORA-01328only one build operation may occur at one time
ORA-25104UNRECOVERABLE option can only be used with ALTER INDEX REBUILD
AMD-00124dimension #string: analytic workspace GID variable not specified
QSM-03115Cannot tune materialized view ON PREBUILT table
PGU-39607TG %8ls=> a#string string string
ORA-00304requested INSTANCE_NUMBER is busy
ORA-07623smscre: $CRMPSC failure
IMP-00009abnormal end of export file
ORA-22874attribute "string" is not part of the type "string"
TNS-01099string * string * string * string * number
ORA-16236Logical Standby metadata operation in progress




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