ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 添加表空间

添加表空间

原创 Linux操作系统 作者:idtbbsb 时间:2011-02-10 14:33:19 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
下一篇: foglight
请登录后发表评论 登录
全部评论

注册时间:2011-02-10

  • 博文量
    6
  • 访问量
    5129