1、启动数据库,检查数据库现有数据文件
SQL> startup
ORACLE instance started.
Total System Global Area 413372416 bytes
Fixed Size 2253784 bytes
Variable Size 314575912 bytes
Database Buffers 92274688 bytes
Redo Buffers 4268032 bytes
Database mounted.
Database opened.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl/system01.dbf
/u01/app/oracle/oradata/orcl/sysaux01.dbf
/u01/app/oracle/oradata/orcl/undotbs01.dbf
/u01/app/oracle/oradata/orcl/users01.dbf
2、创建测试表空间及测试数据
SQL> create tablespace test datafile '/u01/app/oracle/oradata/orcl/test.dbf' size 5m;
Tablespace created.
SQL> create user a identified by aaa default tablespace test;
User created.
SQL> grant dba,connect,resource to a;
Grant succeeded.
SQL> conn a/aaa
Connected.
SQL> create table a (id int);
Table created.
SQL> insert into a values (1);
1 row created.