Re: cannot create table

you're in archive log mode?

is the archiver stuck?

can you issue
ALTER SYSTEM SWITCH LOGFILE; try that a few times..if you can't do that the archiver is likely stuck...perhaps the archive log dest is full or you fo not have archive_log_start= true in your init.

steve

srivenu_at_hotmail.com (srivenu) wrote in message news:<1a68177.0208122017.432ba152_at_posting.google.com>...
> Give this query in an other session and see what your session is waiting for.
>
> set feedback on
> set head on
> col event form a13 trunc head "Event| Waiting For"
> col p2 form 99999 trunc
> col wait_time form 999 trunc head "Last|Wait|Time"
> col program form a13 trunc
> col command form a7 trunc head "Command"
> col username form a8 trunc
> col state form a10
> col sid form 999 trunc
> col last_call_et form 9999999 trunc head "Last Call|In Secs"
> select a.sid,username,b.program program,
> decode(command,0,'None',2,'Insert',3,'Select',
> 6,'Update',7,'Delete',10,'Drop Index',12,'Drop Table',
> 45,'Rollback',47,'PL/SQL',command) command,
> last_call_et,
> event,p1,p2,state,wait_time
> from v$session_wait a,V$session b
> where b.sid=a.sid
> order by 1
> /
Received on Tue Aug 13 2002 - 14:27:12 CDT