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