Robin, I did check and I do have sec_id_seq as you described...and I turned on verbose (Don's suggestion). Further analysis led me to discover that the dual table is missing stuff. I can't do:
select sysdate from dual;
I get "(0 rows)" rather than
sysdate
------------------------
2001-08-08 21:46:47-04
(1 row)
So where do I get the .sql code to restore the dual table?
and Robin, where did you find the code to restore the sequence?
I didn't find it in ~/www/doc/sql/
Thank you.