3
回答
oracle: ORA-01109: database not open
注册华为云得mate10,2.9折抢先购!>>>   

创建表空间的时候出现:



SQL> @create_tsscdb_tabspace.sql
CREATE TABLESPACE tssc_tab DATAFILE '/home/oracle/oradata/tssc_tab.dbf' SIZE 512M AUTOEXTEND ON NEXT 256M MAXSIZE 2048M
*
ERROR at line 1:
ORA-01109: database not open




CREATE TEMPORARY TABLESPACE tssc_tmp_tab TEMPFILE '/home/oracle/oradata/tssc_tmp_tab.dbf' SIZE 64M AUTOEXTEND ON
*
ERROR at line 1:
ORA-01109: database not open




CREATE user tssc IDENTIFIED BY tssc Default tablespace tssc_tab TEMPORARY tablespace tssc_tmp_tab
                               *
ERROR at line 1:
ORA-01109: database not open




GRANT connect,resource,create session TO tssc
*
ERROR at line 1:
ORA-01109: database not open

举报
jize
发帖于3年前 3回/3K+阅
顶部