1.先登录进去:sqlplus / as sysdba
2.连接:conn / as sysdba
3.查看例程状态:select status from v$instance;
发现是MUOUNT的状态时输入下面两个命令:
shutdown immediate
startup nomount
4.查看例程状态:select status from v$instance;发现是STARTED
5.输入命令:
alter database mount;
alter database open;
6.然后就能创建表