Navicat Premium配置Oracle11

管理员登录

sys as sysdba

创建表空间

create TABLESPACE PREPOLICY logging DATAFILE 'D:\app\Administrator\oradata\orcl\PREPOLICY_LOCAL.DBF' SIZE 500M;

创建用户

create user prepolicy profile default identified by prepolicy account unlock default tablespace PREPOLICY temporary tablespace temp;

授权

grant resource,connect,dba to prepolicy; 

D:\app\Administrator\product\11.2.0\dbhome_1\bin\oci.dll