数据库的准备
--新建表空间
CREATE tablespace pdrepertory
DATAFILE'F:/Project/project_test/pdrepertory/DB/pdrepertory.dbf'
SIZE 100M
--新建用户
CREATE user pd
IDENTIFIED by pd
DEFAULT tablespace pdrepertory
TEMPORARY tablespace temp
--赋予权限
GRANT dba to pd
--给pd这个角色create session权限
GRANT create session to pd
Powerdesigner上建立数据源连接
--新建表空间
CREATE tablespace pdrepertory
DATAFILE'F:/Project/project_test/pdrepertory/DB/pdrepertory.dbf'
SIZE 100M
--新建用户
CREATE user pd
IDENTIFIED by pd
DEFAULT tablespace pdrepertory
TEMPORARY tablespace temp
--赋予权限
GRANT dba to pd
--给pd这个角色create session权限
GRANT create session to pd