添加表空间

SQL> create tablespace ybtest datafile '/oradata/ybtest/ybtest/ybttest01.dbf' size 8192M,'/oradata/ybttest/ybttest/ybttest02.dbf' size 8192M;
create tablespace ybtest datafile '/oradata/ybtest/ybtest/ybttest01.dbf' size 8192M,'/oradata/ybttest/ybttest/ybttest02.dbf' size 8192M
*
ERROR at line 1:
ORA-01119: error in creating database file '/oradata/ybttest/ybttest/ybttest02.dbf'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory


SQL> alter tablespace ybttest add datafile '/oradata/ybtest/ybtest/ybttest02.dbf' size 8192M;
alter tablespace ybttest add datafile '/oradata/ybtest/ybtest/ybttest02.dbf' size 8192M
*
ERROR at line 1:
ORA-00959: tablespace 'YBTTEST' does not exist


SQL> create tablespace ybtest datafile '/oradata/ybtest/ybtest/ybttest01.dbf' size 8192M;

Tablespace created.

SQL> alter tablesapce ybtest add datafile '/oradata/ybtest/ybtest/ybttest02.dbf' size 8192m;
alter tablesapce ybtest add datafile '/oradata/ybtest/ybtest/ybttest02.dbf' size 8192m
      *
ERROR at line 1:
ORA-00940: invalid ALTER command


SQL> ALTER TABLESAPCE ybtest add datafile '/oradata/ybtest/ybtest/ybttest02.dbf' size 8192M;
ALTER TABLESAPCE ybtest add datafile '/oradata/ybtest/ybtest/ybttest02.dbf' size 8192M
      *
ERROR at line 1:
ORA-00940: invalid ALTER command


SQL> alter tablespace ybtest add datafile '/oradata/ybtest/ybtest/ybttest02.dbf' size 8192M;

Tablespace altered.

SQL> create tablespace v6ybt datafile '/oradata/ybtest/ybtest/v6ybt01.dbf' size 8192M;

Tablespace created.

SQL> create user ybttest identified by ybttest deafult tablespace ybtest;
create user ybttest identified by ybttest deafult tablespace ybtest
                                          *
ERROR at line 1:
ORA-00922: missing or invalid option


SQL> create user ybttest identified by ybttest default tablespace ybtest;

User created.

SQL> create user v6ybttest identified by v6ybttest default tablespace v6ybt;

User created.

SQL> grant connect,resource to ybtest;
grant connect,resource to ybtest
                          *
ERROR at line 1:
ORA-01917: user or role 'YBTEST' does not exist

SQL> grant connect,resource to ybttest;

Grant succeeded.

SQL> grant connect,resource to v6ybttest;

Grant succeeded.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10985515/viewspace-686960/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10985515/viewspace-686960/