oracle 停止导出命令,oracle 导入导出命令(Oracle导入导出命令).doc

[摘要]oracle 导入导出命令(Oracle导入导出命令) Export and import of Oracle data Preface: about Oracle9i data export and import problems, toss me for a long time, especially import. Today, under the guidance of a colleague, I finally succeeded. In order to remember the help of this colleague, I only use "Kun" as a mark here. Text: Oracle data export: If you export the native Oracle database: Exp pcisv62/11@ORCL file= "d:\pcisdmp" full=y (ORCL listens for the local database) If you export Oracle data from the server side: Exp teller/tccb@orcl file= "d:\DMP eller.dmp" full=y (tnsname is COREV6_DBSERVER, SID is COREV6, host is DBSERVER.) Note: DBA must be able to perform a full database or table space export operation. Oracle data import, the following steps: In the first 1. Oracle9i Enterprise Manager Console, with sys/sys and SYSDBA identity landing, create table space in the "COREV6 store" -- > "table space", at the same time to the appropriate allocation of space. 2. in the "safety" -- > "user" create user pcisv62 user default tablespace COREV6, at the same time in the "role" in CONNECT, DBA, EXP_FULL_DATABASE, to IMP_FULL_DATABASE, RESOURCE. 3. import.Dmp files, start - > Run CMD, import command: Imp pcisv62/11@ORCL file= "d:\pcisdmp" ignore=y Note: if the backup.Dmp file exports data from the COREV6 space to the user pcisv62, then 1., the new user is best pcisv62, otherwise the command is: Imp, pcisv62/11@ORCL, file=, pcisdmp, fromuser=pcisv62, touser=, new user, ignore=y 2. the new namespace name associated with the new user must be COREV6, otherwise the Oracle could not find an error in the COREV6 space. Imp, teller/tccb@orcl, file=, d:\DMP eller.dmp, fromuser=teller, touser=teller, ignore=y Imp, TELLDEV/tccb@orcl, file=, D:\ORACLE elldev33_1.dmp, fromuser=TELLDEV, touser=TELLDEV, ignore=y Imp, TELLDEVsec/tccb@orcl, file=, D:\ORACLE elldev33_1.dmp, fromuser=TELLDEVsec, touser=TELLDEVsec, ignore=y Imp, teller/tccb@orcl, file=, d:\DMP eller.dmp, fr

e1a73b12533003fb711a46855373d53c.png

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值