Hi,

Oracle 8.1.7.2

I've issued the command to switch log

> alter system switch logfile;

but its hanging!!

the v$log looks like this

GROUP# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_TIME
------- --------- --------- --------- --- ---------------- ----------
9 22525 10485760 2 NO ACTIVE 28/12/2003
7 22526 10485760 2 NO ACTIVE 28/12/2003
10 22527 52428800 2 NO ACTIVE 28/12/2003
11 22528 52428800 2 NO ACTIVE 28/12/2003
12 22529 52428800 2 NO ACTIVE 28/12/2003
13 22530 52428800 2 NO CURRENT 28/12/2003


The db is not in archivelog mode... I'm importing so I switched it off..

Please help!! URGENT!!

P.S - I was trying to create bigger logfiles and wanted to drop the old (small) ones... but they are ACTIVE.

Kev