1 2 Previous Next 19 Replies Latest reply: Apr 5, 2013 6:25 AM by 1001257 RSS

    databas enot open; must use reset logs


      I am novice to pl/sql, can you please help with this problem

      SQL> create table man(name varchar2(20));
      create table man(name varchar2(20))
      ERROR at line 1:
      ORA-01109: database not open

      SQL> shut immediate
      ORA-01109: database not open

      Database dismounted.
      ORACLE instance shut down.
      SQL> startup
      ORACLE instance started.

      Database mounted.
      ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

      I dont know how to reset logs. I also dont know why it is saying database not open

      Thank you.
        1 2 Previous Next