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
PCC-02103Password:
ORA-02836Unable to create temporary key file
ORA-01493invalid SAMPLE size specified
DIA-48220Too Many Keys Defined [string] [string]
OCI-31069Cannot apply typed changes to non-schema-based XMLType nodes
ORA-41206Session capture or restore internal error KPCSFR-string
ORA-01178file string created before last CREATE CONTROLFILE, cannot recreate
KUP-03001fatal error during library cache pre-loading
RMAN-05534WARNING: LOG_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.
PCB-00217OCCURS INDEXED clause not allowed for host variable "string"
PLS-00634type with NOT INSTANTIABLE methods must be declared NOT INSTANTIABLE
ORA-55601The table "string"."string" cannot be enabled for Flashback Archive
ORA-07601spguno: $GETJPIW failure
ORA-19669proxy copy functions cannot be run on DISK channel
ORA-40230invalid transformation expression
PCC-02333SQL identifier was not declared as a statement
ORA-01584unable to get file size of control file to be backed up
ORA-00977duplicate auditing option
RMAN-06126skipping offline file string
O2I-00132Unable to close a Java file




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
ORA-00000normal, successful completion
RMAN-08132WARNING: cannot update recovery area reclaimable file list
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