Orcale数据库安装完成之后,需要进行的几个操作
--创建表空间
CREATE TABLESPACE test
datafile 'D:\app\Administrator\oradata\DB\test.dbf'
Size 100M
autoextend on maxsize 10480M
blocksize 8K
--创建用户
create user test
identified by "123"
default tablespace test
temporary tablespace TEMP
profile DEFAULT;
--赋权
grant connect to test;
grant dba to test;
grant unlimited tablespace to test;
--取消密码过期限制
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED
--设置空表可以导出导入
alter system set deferred_segment_creation=false;