ORA-01682: read-only DB cannot allocate temporary space in
tablespace string
Answer / guest
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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
EXP-00025: dictionary shows no column for constraint string.number
SQL*Loader-00129: Invalid number of rows for direct path column array
NID-00310: Control File string - reverted
imp-00038: could not convert to environment character set's handle error occurs while importing oracle 10g data into oracle 9i database.
ORA-13003: the specified range for a dimension is invalid
RMAN-05501: aborting duplication of target database
CLSS-00200: local node string not listed in configuration
ORA-24265: Insufficient privileges for SQL profile operation
DRG-11866: Please Try `ftp://' Instead Of `file://'
ORA-07849: sllfsk: $GET failure
PLS-00663: the NEW keyword is not allowed in this context
ORA-25271: queue table not found for the given queue