熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

oracle創建用戶快捷命令

2022-06-13   來源: Oracle 

  create tablespace jfxt datafile E:\oracle\oradata\oradb\jfxtora size m reuse default storage(initial k next k pctincrease );

  create user jfxt identified by jfxt default tablespace jfxt quota m on users;

  grant connectresourcedba to jfxt;


From:http://tw.wingwit.com/Article/program/Oracle/201311/18857.html
    推薦文章
    Copyright © 2005-2022 電腦知識網 Computer Knowledge   All rights reserved.