select name from v$datafile;
1、创建表空间
create tablespace test_db datafile 'D:\ORACLE\ORADATA\ORCL\test_db.dbf' size 3000m;
2、创建用户
create user test_db identified by test_db default tablespace test_db;
3、给用户赋权
grant dba, connect to test_db;
1、创建表空间
create tablespace test_db datafile 'D:\ORACLE\ORADATA\ORCL\test_db.dbf' size 3000m;
2、创建用户
create user test_db identified by test_db default tablespace test_db;
3、给用户赋权
grant dba, connect to test_db;