ORA-01640: cannot make tablespace read only with active transactions
Cause: Attempting to make a tablespace read only while there are active transactions in the database. All transactions must commit or rollback to insure that there is no undo for a tablespace before it can be made read only. This includes in doubt distributed transactions.
Action: Prevent any more transactions from being started. Putting the database in restricted mode usually helps. If there are any in doubt transactions they must also be resolved.
ORA-01643
Custom Search


More Oracle errors
ORA-16188LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
IMG-00209error parsing metadata
RMAN-00702The command has no syntax errors
SQL*Loader-00624no terminator found after TERMINATED and ENCLOSED field
ORA-28268Exceeded the maximum allowed size for Context information in a session
ORA-29471DBMS_SQL access denied
ORA-14280all rows in table do not qualify for specified subpartition
DGM-16948Unable to switchover, primary database is still "string"
RMAN-20230datafile copy not found in the recovery catalog
DRG-50905invalid score threshold string
ORA-25197an overflow segment already exists for the indexed-organized table
ORA-16060Log file is current
LFI-01005Unable to fill buffer.
LFI-00124No access mode was specified, default is sequential.
ORA-38724Invalid option to the FLASHBACK DATABASE command.
ORA-02727osnpop: access error on orapop executable
QSM-00514the size of must-retain summaries exceeds specified space limit
ORA-13462invalid blocking specification
ORA-31535cannot support change source string in this configuration
TNS-00212Total Pumps Started : number




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-01640cannot make tablespace read only with active transactions