资源描述:
《手把手教你怎样导入oracle10g的dmp格式数据》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、网上有很多关于oracle导入的日志,但写的都不详细,新手需要的一步一步指导。本文是oracle10g版本的导入dmp格式的数据。超详细的步骤,新手只要照着做就好了。MicrosoftWindowsXP[版本5.1.2600](C)版权所有1985-2001MicrosoftCorp.C:DocumentsandSettingsAdministrator>impImport:Release10.2.0.1.0-Productionon星期三9月2623:36:312012Copyright(c)1982,2005,
2、Oracle.Allrightsreserved.用户名:system(指的是你导出oracle数据的用户名)口令:(指的是你导出oracle数据的密码,dos下不会显示)连接到:OracleDatabase10gRelease10.2.0.1.0-Production导入文件:EXPDAT.DMP>d:a.dmp(最好把导出的数据放在根目录下)输入插入缓冲区大小(最小为8192)30720>1024(不要管提示,就写1024)经由常规路径由EXPORT:V10.02.01创建的导出文件警告:这些对象由FLOWERU
3、SER导出,而不是当前用户已经完成ZHS16GBK字符集和AL16UTF16NCHAR字符集中的导入只列出导入文件的内容(yes/no):no>yes导入整个导出文件(yes/no):no>yes.正在将FLOWERUSER的对象导入到FLOWER"BEGIN""sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','""CURRENT_SCHEMA'),export_db_name=>'ORCL.REGRESS.RDBMS.
4、DEV.US.ORACLE.COM',i""nst_scn=>'2758006');""COMMIT;END;""CREATESEQUENCE"SEQ_UID"MINVALUE1MAXVALUE999999999999999999999999999I""NCREMENTBY1STARTWITH21CACHE20NOORDERNOCYCLE""CREATESEQUENCE"MEMBERS_S"MINVALUE1MAXVALUE999999999999999999999999999""INCREMENTBY1STARTWI
5、TH1CACHE20NOORDERNOCYCLE""CREATESEQUENCE"ORDER2_S"MINVALUE1MAXVALUE999999999999999999999999999"20currencydeposit,weprescribeapassonaregularbasis,qilucardaccountonaregularbasis),certificatebondsandsavingsbonds(electronic);3.notdrawnonabanksavingscertificate,certi
6、ficatebondsapplyformortgageloans,acceptingonlythelender"INCREMENTBY1STARTWITH1CACHE20NOORDERNOCYCLE""CREATESEQUENCE"FLOWER_S"MINVALUE1MAXVALUE999999999999999999999999999""INCREMENTBY1STARTWITH1CACHE20NOORDERNOCYCLE""CREATETABLE"COMMEN"("COMMENTID"NUMBERNOTNULLEN
7、ABLE,"ORDERID"NUMBER"","FLOWERID"NUMBER,"MEMBERID"NUMBER,"RANK"VARCHAR2(100),"COMM"VARCHA""R2(500),"COMMENTTIME"DATE)PCTFREE10PCTUSED40INITRANS1MAXTRANS255""STORAGE(INITIAL65536FREELISTS1FREELISTGROUPS1BUFFER_POOLDEFAULT)T""ABLESPACE"FLOWER"LOGGINGNOCOMPRESS"..正
8、在跳过表"COMMEN""CREATEUNIQUEINDEX"COMMEN_PK"ON"COMMEN"("COMMENTID")PCTFREE10INIT""RANS2MAXTRANS255STORAGE(INITIAL65536FREELISTS1FREELISTGROUPS1BUF""FER_POOLDEFAULT)TABLE