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;