摘要: 1、创建tablespaceSQL> col name format a60SQL> set line 200SQL> select name,status from v$datafile;NAME STATUS------------------------------------------------------------ -------/u01/app/oracle/oradata/testdb/system01.dbf SYSTEM/u0... 阅读全文
posted @ 2013-07-12 23:54 ArcerZhang 阅读(320) 评论(0) 推荐(0) 编辑
摘要: 1、CONNECT privilegsSQL> select * from dba_sys_privs where grantee='CONNECT';GRANTEE PRIVILEGE ADM------------------------------ ---------------------------------------- ---CONNECT CREATE SESSION NO... 阅读全文
posted @ 2013-07-12 23:13 ArcerZhang 阅读(215) 评论(0) 推荐(0) 编辑