新建脚本语句:
-----------------SYS创建用户
CREATE USER dandeliondshtest PROFILE "DEFAULT" IDENTIFIED BY dandeliondshtest DEFAULT
TABLESPACE "USERS" TEMPORARY
TABLESPACE "TEMP" ACCOUNT UNLOCK
GRANT SELECT ON "SYS"."V_$SESSION" TO dandeliondshtest
GRANT "CONNECT" TO dandeliondshtest
GRANT "DBA" TO dandeliondshtest
GRANT "RESOURCE" TO dandeliondshtest
GRANT CREATE ANY sequence TO dandeliondshtest
CREATE USER dandelionids IDENTIFIED BY dandelionids
grant create session to dandelionids--授予zhangsan用户创建session的权限,即登陆权限
grant unlimited tablespace to dandelionids--授予zhangsan用户使用表空间的权限
grant create table to dandelionids--授予创建表的权限
grant drop table to dandelionids--授予删除表的权限
导入dmp文件是在dos命令窗口中来执行的,impdp 用户名/密码@IP/pdborcl dumpfile=bak_dir:文件名.DMP nologfile=Y (单击回车)
如果是64位的话,用这个使用PL/SQL Developer连接OracleX64版本:
1. 下载32位Oracle InstantClient,并展开到某目录,例如C:\instantclient-basic-nt-11.2.0.2.0;
2. 将系统的tnsnames.ora拷贝到该目录下;
3. 在PLSQL Developer中设置Oracle_Home和OCI Library:
ToolsPreferencesOracleConnection:
Oracle_Home:C:\instantclient-basic-nt-11.2.0.2.0
OCI Library:C:\instantclient-basic-nt-11.2.0.2.0\oci.dll
4. 在PLSQL Developer目录下编辑如下bat文件,替换其快捷方式,启动PLSQL Developer:
@echo off
set path=C:\instantclient-basic-nt-11.2.0.2.0
set ORACLE_HOME=C:\instantclient-basic-nt-11.2.0.2.0
set TNS_ADMIN=C:\instantclient-basic-nt-11.2.0.2.0
set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
start plsqldev.exe
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)