创建表空间 ----表空间名:TEST_TABS 位置是:数据库安装的位置/opt/app下的/oradata/orcl/里。 空间大小:200M
CREATE SMALLFILE TABLESPACE "TEST_TABS" DATAFILE '/opt/app/oradata/orcl/MONITOR_TABS'
grant connect to test with admin option;
CREATE SMALLFILE TABLESPACE "TEST_TABS" DATAFILE '/opt/app/oradata/orcl/MONITOR_TABS'
SIZE 200M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
创建用户 用户名:test 密码:test
create user test identified by "test " default tablespace TEST_TABS temporary tablespace TEMP profile DEFAULT;
grant connect to test with admin option;
grant resource to test with admin option;
grant
dba
to
user_name;