《手把手教你怎样导入oracle10g的dmp格式数据》由会员分享,可在线阅读,更多相关《手把手教你怎样导入oracle10g的dmp格式数据(8页珍藏版)》请在金锄头文库上搜索。
1、网上有很多关于 oracle 导入的日志,但写的都不详细,新手需要的一步一步指导。本文是oracle10g 版本的导入 dmp 格式的数据。超详细的步骤,新手只要照着做就好了。Microsoft Windows XP 版本 5.1.2600(C) 版权所有 1985-2001 Microsoft Corp.C:Documents and SettingsAdministratorimpImport: Release 10.2.0.1.0 - Production on 星期三 9 月 26 23:36:31 2012Copyright (c) 1982, 2005, Oracle. All r
2、ights reserved.用户名: system(指的是你导出 oracle 数据的用户名)口令: (指的是你导出 oracle 数据的密码, dos 下不会显示 )连接到: Oracle Database 10g Release 10.2.0.1.0 - Production导入文件: EXPDAT.DMP d:a.dmp(最好把导出的数据放在根目录下)输入插入缓冲区大小 (最小为 8192) 307201024(不要管提示,就写 1024)经由常规路径由 EXPORT:V10.02.01 创建的导出文件警告: 这些对象由 FLOWERUSER 导出, 而不是当前用户已经完成 ZHS16
3、GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入只列出导入文件的内容 (yes/no): no yes导入整个导出文件 (yes/no): no yes. 正在将 FLOWERUSER 的对象导入到 FLOWERBEGIN sys.dbms_logrep_imp.instantiate_schema(schema_name=SYS_CONTEXT(USERENV,CURRENT_SCHEMA), export_db_name=ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM, inst_scn=2758006);COMMIT; END;CREATE SE
4、QUENCE SEQ_UID MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLECREATE SEQUENCE MEMBERS_S MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLECREATE SEQUENCE ORDER2_S MINVALUE 1 MAXVALUE 9999999999999
5、99999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLECREATE SEQUENCE FLOWER_S MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLECREATE TABLE COMMEN (COMMENTID NUMBER NOT NULL ENABLE, ORDERID NUMBER, FLOWERID NUMBER, MEMBERID NUMBER, RAN
6、K VARCHAR2(100), COMM VARCHAR2(500), COMMENTTIME DATE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE FLOWER LOGGING NOCOMPRESS. . 正在跳过表 COMMENCREATE UNIQUE INDEX COMMEN_PK ON COMMEN (COMMENTID ) PCTFREE 10 INITRANS 2
7、 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE FLOWER LOGGINGALTER TABLE COMMEN ADD CONSTRAINT COMMEN_PK PRIMARY KEY (COMMENTID) USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
8、TABLESPACE FLOWER LOGGING ENABLE CREATE TABLE FLOWER (FLOWERID NUMBER NOT NULL ENABLE, FLOWERNAME VARCHAR2(100), TYPEID NUMBER, MATERIAL VARCHAR2(200), PACKAGE VARCHAR2(500), FLOWERLA VARCHAR2(500), SEND VARCHAR2(500), EXPLAIN VARCHAR2(500), IMG VARCHAR2(50), PRICE VARCHAR2(20), CURR NUMBER(9, 2), K
9、EY VARCHAR2(500), PRODUCT CLOB, SALES NUMBER, TRAFFIC NUMBER, ISCOMMENT NUMBER(1, 0) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE FLOWER LOGGING NOCOMPRESS LOB (PRODUCT) STORE AS (TABLESPACE FLOWER ENABLE STORAGE IN
10、 ROW CHUNK 8192 PCTVERSION 10 NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT). . 正在跳过表 FLOWERCREATE UNIQUE INDEX FLOWER_PK ON FLOWER (FLOWERID ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLES
11、PACE FLOWER LOGGINGALTER TABLE FLOWER ADD CONSTRAINT FLOWER_PK PRIMARY KEY (FLOWERID) USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE FLOWER LOGGING ENABLE CREATE TABLE MANAGER (MANAGEID VARCHAR2(20) NOT NULL ENABLE,
12、MANAGEPWD VARCHAR2(20) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE FLOWER LOGGING NOCOMPRESS. . 正在跳过表 MANAGERCREATE TABLE MEMBER (MEMBERID NUMBER NOT NULL ENABLE, EMAIL VARCHAR2(50) NOT NULL ENABLE, USERNAME VARCHA
13、R2(50) NOT NULL ENABLE, USERPWD VARCHAR2(20) NOT NULL ENABLE, SEX VARCHAR2(2) NOT NULL ENABLE, TELEPHONE VARCHAR2(20), ADDRESS VARCHAR2(50), REGTIME DATE NOT NULL ENABLE, USERSTATUS VARCHAR2(10) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST
14、 GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE FLOWER LOGGING NOCOMPRESS. . 正在跳过表 MEMBERCREATE UNIQUE INDEX MEMBER_PK ON MEMBER (MEMBERID ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFF ER_POOL DEFAULT) TABLESPACE FLOWER LOGGINGALTER TABLE MEMBER ADD CONSTRAI
15、NT MEMBER_PK PRIMARY KEY (MEMBERID) USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE FLOWER LOGGING ENABLE CREATE TABLE MESSAGE (USERNAME VARCHAR2(20), TEL VARCHAR2(20), MAIL VARCHAR2(50), SUBJECT VARCHAR2(200), CONTENT VARCHAR2(500) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE F