When doing a whole database export from a read-only Oracle 8i database, got the following error near the end of exporting:
......
. about to export USERA's tables via Conventional Path ...
. exporting referential integrity constraints
. exporting synonyms
EXP-00008: ORACLE error 1682 encountered
ORA-01682: read-only DB cannot allocate temporary space in tablespace TEMP
EXP-00000: Export terminated unsuccessfully
Oracle exp uses TEMP tablespace while doing the export. So the solution is to open the database in normal mode, change tablespaces to read only except SYSTEM, RBS, RBSBIG and TEMP. Then perform the export.
No comments:
Post a Comment