Oracle 常用命令

  1. 查看服务端字符集:select userenv('language') from dual
  2. 建立tablespace:create tablespace test1 datafile '/infowarelab/oradata/test1.dbf' size 10M;
  3. 建立用户: create user tom identified by tom default tablespace test1 ;
  4. 授权:grant connect,resource to smart identified by smart; 
          grant dba to smart;
          grant create any table to tom;
          grant create any trigger to tom;
          grant create any sequence to tom;
          grant create any procedure to tom;
阅读更多

没有更多推荐了,返回首页