連接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the OLAP and Data Mining options
SQL> conn as sysDBA
請輸入用戶名: system
輸入口令: *****
已連接。
SQL> create tablespace test datafile 'D:\oracle\kkk\test.dbf' size 50M autoextend on next 50M;
表空間已創建。
SQL> create user test identified by test default tablespace test;
用戶已創建。
SQL> grant connect,resource to test;
授權成功。
SQL>