Oracle综合数据库管理命令集
sqlplus SANKYU/SANKYU@ORADB_192.168.25.235
cmd: exp .......(最后不要加;号)
--sankyu
exp SANKYU/SANKYU@SUNNY file='D:\data-dmp\dlmp20100926\dlmp20100926.dmp' log='D:\data-dmp\sankyu.log' owner=SANKYU buffer=4096000 feedback=10000;
imp SANKYU/SANKYU@SUNNY file='D:\data-dmp\sankyu2010-10-14.dmp' fromuser=SANKYU touser=SANKYU log=D:\data-dmp\SANKYU.log IGNORE=Y rows=y buffer=100000 feedback=100000 commit=y;
exp SANKYU/SANKYU@ORADB_192.168.25.235 file='D:\data-dmp\sankyu2010-10-14.dmp' log='D:\data-dmp\sankyu.log' owner=SANKYU buffer=4096000 feedback=10000;
--删除用户:
DROP USER SANKYU CASCADE;
--创建用户:
CREATE USER "SANKYU" IDENTIFIED BY "SANKYU"
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON USERS;
--赋予DBA角色
GRANT DBA TO "SANKYU";
ALTER USER "SANKYU" DEFAULT ROLE DBA;
---test111
exp TEST111/TEST111@SANKYUDB_192.168.16.171 file='D:\data-dmp\gzsankyu(9-28-test111).dmp' log='D:\data-dmp\sankyu.log' owner=TEST111 buffer=4096000 feedback=10000;
imp TEST111/TEST111@SUNNY file='D:\data-dmp\gzsankyu(9-25-test111_111).dmp' fromuser=test111 touser=TEST111 log=D:\data-dmp\TEST.log IGNORE=Y rows=y buffer=100000 feedback=100000 commit=y;
imp TEST111/TEST111@SRV200_192.168.0.200 file='D:\data-dmp\sankyu.dmp' fromuser=SANKYU touser=TEST111 log=D:\data-dmp\TEST.log IGNORE=Y rows=y buffer=100000 feedback=100000 commit=y;
imp TEST111/TEST111@SUNNY file='D:\data-dmp\gzsankyu(9-20-000).dmp' fromuser=TEST111 touser=TEST111 log=D:\data-dmp\TEST.log IGNORE=Y rows=y buffer=100000 feedback=100000 commit=y;
imp TEST111/TEST111@SANKYUDB_192.168.16.171 file='D:\data-dmp\gzsankyu(9-25-test111).dmp' fromuser=TEST222 touser=TEST111 log=D:\data-dmp\TEST.log IGNORE=Y rows=y buffer=100000 feedback=100000 commit=y;
--删除用户:
DROP USER TEST111 CASCADE;
--创建用户:
CREATE USER "TEST111" IDENTIFIED BY "TEST111"
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON USERS;
--赋予DBA角色
GRANT DBA TO "TEST111";
ALTER USER "TEST111" DEFAULT ROLE DBA;
---test222
imp TEST222/TEST222@SANKYUDB_192.168.16.171 file='D:\data-dmp\gzsankyu(9-25-test111_111).dmp' fromuser=TEST111 touser=TEST222 log=D:\data-dmp\TEST.log IGNORE=Y rows=y buffer=100000 feedback=100000 commit=y;
imp TEST222/TEST222@SUNNY file='D:\data-dmp\gzsankyu(5-25-test222).dmp' fromuser=TEST111 touser=TEST222 log=D:\data-dmp\TEST.log IGNORE=Y rows=y buffer=100000 feedback=100000 commit=y;
imp TEST222/TEST222@SUNNY file='D:\data-dmp\gzsankyu(5-25-test222).dmp' fromuser=TEST222 touser=TEST222 log=D:\data-dmp\TEST.log IGNORE=Y rows=y buffer=100000 feedback=100000 commit=y;
exp TEST222/TEST222@SRV150_192.168.0.150 file='D:\data-dmp\gzsankyu(9-07-000).dmp' log='D:\data-dmp\sankyu.log' owner=TEST222 buffer=4096000 feedback=10000;
exp TEST222/TEST222@SRV200_192.168.0.200 file='D:\data-dmp\TEST222.dmp' log='D:\data-dmp\sankyu.log' owner=TEST222 buffer=4096000 feedback=10000;
exp TEST222/TEST222@SUNNY file='D:\data-dmp\gzsankyu(9-07-000).dmp' log='D:\data-dmp\sankyu.log' owner=TEST222 buffer=4096000 feedback=10000;
exp TEST111/TEST111@SANKYUDB_192.168.16.171 file='D:\data-dmp\gzsankyu(5-25-test222).dmp' log='D:\data-dmp\sankyu.log' owner=TEST111 buffer=4096000 feedback=10000;
exp TEST222/TEST222@SANKYUDB_192.168.16.171 file='D:\data-dmp\gzsankyu(5-25-test222-111).dmp' log='D:\data-dmp\sankyu.log' owner=TEST222 buffer=4096000 feedback=10000;
exp TEST222/TEST222@SANKYUDB_192.168.16.171 file='D:\data-dmp\gzsankyu(4-27-555).dmp' log='D:\data-dmp\sankyu.log' owner=TEST222 buffer=4096000 feedback=10000;
--删除用户:
DROP USER TEST222 CASCADE;
--创建用户:
CREATE USER "TEST222" IDENTIFIED BY "TEST222"
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON USERS;
--赋予DBA角色
GRANT DBA TO "TEST222";
ALTER USER "TEST222" DEFAULT ROLE DBA;
--TEST333
exp TEST333/TEST333@SUNNY file='D:\data-dmp\gzsankyu(2010-09-06).dmp' log='D:\data-dmp\sankyu.log' owner=TEST333 buffer=4096000 feedback=10000;
exp TEST333/TEST333@SANKYUDB_192.168.16.171 file='D:\data-dmp\gzsankyu(9-20-test333).dmp' log='D:\data-dmp\sankyu.log' owner=TEST333 buffer=4096000 feedback=10000;
imp TEST333/TEST333@SUNNY file='D:\data-dmp\gzsankyu(5-25-test222-111).dmp' fromuser=test222 touser=TEST333 log=D:\data-dmp\TEST.log IGNORE=Y rows=y buffer=100000 feedback=100000 commit=y;
--删除用户:
DROP USER TEST333 CASCADE;
--创建用户:
CREATE USER "TEST333" IDENTIFIED BY "TEST333"
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON USERS;
--赋予DBA角色
GRANT DBA TO "TEST333";
ALTER USER "TEST333" DEFAULT ROLE DBA;
--TEST333
exp TEST333/TEST333@SRV150_192.168.0.150 file='D:\data-dmp\gzsankyu(5-21-000).dmp' log='D:\data-dmp\test.log' owner=TEST buffer=4096000 feedback=10000;
imp TEST555/TEST555@SUNNY file='D:\data-dmp\gzsankyu(8-31-000).dmp' fromuser=TEST222 touser=TEST555 log=D:\data-dmp\TEST.log IGNORE=Y rows=y buffer=100000 feedback=100000 commit=y;
--删除用户:
-- TEST555用于保存9月以前没有更新过的系统,主要针对系统菜单可能存在的更新而导致的错误
-- DROP USER TEST555 CASCADE;
--创建用户:
CREATE USER "TEST555" IDENTIFIED BY "TEST555"
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON USERS;
--赋予DBA角色
GRANT DBA TO "TEST555";
ALTER USER "TEST555" DEFAULT ROLE DBA;
--BTSDBUSER
exp BTSDBTEST/BTSDBTEST@ORADB_192.168.100.114 file='D:\data-dmp\BTSDBTEST(8-12-000).dmp' log='D:\data-dmp\test.log' owner=BTSDBTEST buffer=4096000 feedback=10000;
imp BTSDBTEST/BTSDBTEST@SUNNY file='D:\data-dmp\BTSDBTEST(8-10-000).dmp' fromuser=BTSDBTEST touser=BTSDBTEST log=D:\data-dmp\TEST.log IGNORE=Y rows=y buffer=100000 feedback=100000 commit=y;
--删除用户:
DROP USER BTSDBTEST CASCADE;
--创建用户:
CREATE USER "BTSDBTEST" IDENTIFIED BY "BTSDBTEST"
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON USERS;
--赋予DBA角色
GRANT DBA TO "BTSDBTEST";
ALTER USER "BTSDBTEST" DEFAULT ROLE DBA;
相关文章
- 数据库实战班尚学堂 Oracle 数据库实战,由马士兵教你学!(尚学堂马士兵oracle)
- 管理Oracle表的数据块结构(oracle表数据块)
- Oracle表:行锁技术解析(oracle表锁行锁)
- 和权限利用Oracle角色管理用户权限(oracle中角色)
- Oracle: 数据库的非凡之旅(第一个字符oracle)
- Oracle 数据库:建表与建索引(oracle建表建索引)
- Oracle数据库域名配置详解(oracle数据库域名)
- Oracle数据库中的表结构(oracle有什么表)
- 深入探讨Oracle数据库中的聚集索引设计和应用(聚集索引oracle)
- 探秘Oracle:解析神秘数据库管理系统干什么?(oracle干什么)
- 深入探究Oracle归档文件,解析其作用及管理方法(oracle归档文件)
- 揭秘Oracle数据库的内存结构图(oracle 内存结构图)
- 爱上Oracle,享受Like动态(like动态oracle)
- 库C语言使用Oracle链接类库实现数据库操作(c oracle链接类)
- 挑战自我的机遇A5M2与Oracle的结合(a5m2 oracle)
- Oracle数据库如何对几个字段进行修改(oracle修改几个字段)
- 探索Oracle数据库中查询空表语句(oracle中查空表语句)
- Oracle数据库中根据时间排序的实战指南(oracle中时间排序)
- Oracle中LOB值的应用与深度剖析(oracle中lob值)
- Oracle RVL汲取数据库新技术精髓(oracle rvl)
- Oracle RAC上的新世界开机激发无限动力(oracle rac开机)
- Oracle数据库中PK与外键的完美结合(oracle pk外键)
- Oracle PDB数据库查询实践(oracle pdb查询)
- 深刻理解Oracle数据库的启动和关闭