When attempting to use TOAD to look at tablespaces as user SYSTEM, I got the following error:
SELECT privileges on the following are required: DBA_DATA_FILES, DBA_FREE_SPACE, V$TEMP_SPACE_HEADER, V$TEMP_EXTENT_POOL, DBA_TEMP_FILES.
Connect as SYS resulted in the same errors.
Alert log show ORA-01187: cannot read from file xxx because it failed verification tests, where file xxx was the temporary tablespace tempfile.
Alert log also showed: ORA-1187 signalled during: alter database backup controlfile to trace ...
Solution turned out to be dropping and recreating the temporary tablespace(s). Obviously, if there is only one temporary tablespace, you'll have to create a interim temporary tablespace as you cannot drop the default tablespace.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment