我的世界手机版龙蛋怎么孵化 养个末影龙当宠物
天龙私服
私服家族
技术文章
下载中心
私服小偷
发布天龙
发布家族
广告联系
更多天龙
当前位置:天部私服>>技术文章列表>>oracle数据库正确导入方法
oracle数据库正确导入方法
文章作者:admin文章来源:新开天龙私服,国外最大的天部私服教程网更新时间:2009-4-16 9:17:26
如果已经存在其他端的数据库 用system命令方式登陆数据库运行下边的语句
drop user tlbb cascade;
drop user tlbb_reda cascade;
drop user tl_gameuser cascade; (作用是清除tlbb用户,包括这个用户对象下的,存储过程、试图、索引......等等只要是这个用户下的东西全清除干净
了)
为了安全起见 运行完 drop user tlbb cascade;
commit; (在提交一下)
好了接下来可以运行下边的 东西了
create user tlbb IDENTIFIED BY iernei37d;
create user tl_gameuser IDENTIFIED BY iernei37d;
create user tlbb_read IDENTIFIED BY iernei37d;
-- Grant/Revoke role privileges
grant connect to TLBB;
grant resource to TLBB;
-- Grant/Revoke system privileges
grant alter session to TLBB;
grant create cluster to TLBB;
grant create database link to TLBB;
grant create sequence to TLBB;
grant create session to TLBB;
grant create synonym to TLBB;
grant create table to TLBB;
grant create view to TLBB;
-- Grant/Revoke role privileges
grant connect to tl_gameuser;
grant resource to tl_gameuser;
-- Grant/Revoke system privileges
grant alter session to tl_gameuser;
grant create cluster to tl_gameuser;
grant create database link to tl_gameuser;
grant create sequence to tl_gameuser;
grant create session to tl_gameuser;
grant create synonym to tl_gameuser;
grant create table to tl_gameuser;
grant create view to tl_gameuser;
-- Grant/Revoke role privileges
grant connect to tlbb_read;
grant resource to tlbb_read;
-- Grant/Revoke system privileges
grant alter session to tlbb_read;
grant create cluster to tlbb_read;
grant create database link to tlbb_read;
grant create sequence to tlbb_read;
grant create session to tlbb_read;
grant create synonym to tlbb_read;
grant create table to tlbb_read;
grant create view to tlbb_read;
tl_gameuser.seq_user_basic_uin yes
tl_gameuser.user_basic yes yes yes yes
下边是导入库的 直接复制粘贴就可以(主意tlbbnew.dmp 这个文件要放在c盘根目录下。)
impsystem/iernei37d@ora10gfromuser=tlbb touser=tlbb file=c:\tlbbnew.dmp log=c:\tlbb.log
impsystem/iernei37d@ora10gfromuser=tl_gameuser touser=tl_gameuser file=c:\tlbbnew.dmp log=c:\tl_gameuser.log
impsystem/iernei37d@ora10gfromuser=tlbb_read touser=tlbb_read file=c:\tlbbnew.dmp log=c:\tlbb_read.log...
13561