1. 首先在本地硬盘安装oracle数据库的创建本地实例链接,例如我电脑安装路径为D:\oracle\ora92\network\admin中,找到tnsnames.ora文件并打开编辑,增加本地实例,我电脑实例为
LIUGE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC-20110216UVQH)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = liuge)
)
)
2. 创建临时表空间
SYS用户在CMD下以DBA身份登陆:
在CMD中打sqlplus /nolog
然后再
conn / as sysdba
//创建临时表空间
create temporary tablespaceuser_temp
tempfile 'D:\S2SH\S2SH_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
(首先手动在D盘下创建S2SH文件夹)
(也可以创建数据表空间
create tablespace test_data
logging
datafile ' D:\S2SH\S2SH_temp.dbf '
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
)
3. 创建用户并指定表空间
createuser s2sh identified by s2sh
(default tablespace user_data)
temporarytablespace S2SH_temp;
4. 给用户授予权限
Grantconnect,reource to s2sh;
好了,现在就可以通过PlSql客户端输入用户名和密码登录了
用户名为s2sh,密码也是s2sh,数据库选择LIUGE,链接为Normal。