SQL> ALTER DATABASE DROP LOGFILE GROUP 4; Database altered. SQL> SQL> set lines 333 col GROUP# for 9999 col TYPE for a30 col MEMBER for a45 select GROUP#,TYPE,MEMBER from v$logfile; prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$SQL> SQL> SQL> SQL> GROUP# TYPE MEMBER ------ ------------------------------ --------------------------------------------- 1 ONLINE /oradata/lab03/redo01a.log 1 ONLINE /u01/lab03/redo01b.log 2 ONLINE /oradata/lab03/redo02a.log 2 ONLINE /u01/lab03/redo02b.log 3 ONLINE /oradata/lab03/redo03a.log 3 ONLINE /u01/lab03/redo03b.log 5 ONLINE /oradata/lab03/redo05a.log 5 ONLINE /u01/lab03/redo05b.log 8 rows selected. SQL> $$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$