--多看点基础的书 SQL> edi 已写入 file afiedt.buf 1 create tablespace tt 2 datafile 'F:\oracle\product\10.2.0\oradata\orcl\tt01.dbf' size 200M 3 autoextend on next 1M maxsize 1024M 4 logging 5* extent management local SQL> /表空间已创建。SQL> create user test identified by sys 2 default tablespace tt 3 /用户已创建。SQL> grant dba to test 2 /授权成功。
SQL> edi
已写入 file afiedt.buf 1 create tablespace tt
2 datafile 'F:\oracle\product\10.2.0\oradata\orcl\tt01.dbf' size 200M
3 autoextend on next 1M maxsize 1024M
4 logging
5* extent management local
SQL> /表空间已创建。SQL> create user test identified by sys
2 default tablespace tt
3 /用户已创建。SQL> grant dba to test
2 /授权成功。