|
Explanation: The ALTER SYSTEM SWITCH LOGFILE statement is used to manually switch a log file. ALTER DATABASE is not used, nor is ALTER USER. Nor is ALTER REDO LOG, which incidentally isn’t even a real SQL statement. Reference: Oracle 9i: Administrator’s Guide Oracle 9i: Concepts
|