theusingofimpandexpoforacle.mht
来自「ORACLE的exp、imp的具体使用方法」· MHT 代码 · 共 1,421 行 · 第 1/5 页
MHT
1,421 行
9i=E4=B8=AD=E7=9A=84EXP/IMP=E7=9A=84=E4=B8=80=E4=BA=9B=E6=83=85=E5=86=B5=EF=
=BC=8C=E5=AF=B9=E4=BA=8E=E4=B9=8B=E5=89=8D=E7=9A=84=E7=89=88=E6=9C=AC=EF=BC=
=8C=E5=9C=A88.0.X=E4=B8=AD=EF=BC=8C=E9=99=A4=E4=BA=86QUERY=E5=8F=82=E6=95=
=B0=E4=B8=8D=E8=83=BD=E7=94=A8=E5=A4=96=EF=BC=8C=E5=85=B6=E5=AE=83=E5=B7=AE=
=E5=88=AB=E4=B8=8D=E5=A4=A7=E3=80=82=E9=92=88=E5=AF=B9=E6=B2=A1=E6=9C=89Q=
UERY=E7=9A=84=E6=83=85=E5=86=B5=EF=BC=8C=E6=88=91=E4=BB=AC=E5=8F=AF=E4=BB=
=A5=E5=85=88=E5=9C=A8=E6=95=B0=E6=8D=AE=E5=BA=93=E4=B8=AD=E4=BD=BF=E7=94=A8=
=E6=9F=A5=E8=AF=A2=E6=9D=A1=E4=BB=B6=E5=BB=BA=E7=AB=8B=E4=B8=B4=E6=97=B6=E4=
=B8=AD=E9=97=B4=E8=A1=A8=EF=BC=8C=E7=84=B6=E5=90=8E=E4=BD=BF=E7=94=A8EXP=E5=
=AF=BC=E5=87=BA=E8=BF=99=E4=B8=AA=E4=B8=AD=E9=97=B4=E8=A1=A8=E5=8D=B3=E5=8F=
=AF=E3=80=82=E8=87=B3=E4=BA=8EOracle7=E5=9B=A0=E4=B8=BA=E7=9B=AE=E5=89=8D=
=E4=BD=BF=E7=94=A8=E7=9A=84=E4=BA=BA=E8=BE=83=E5=B0=91=EF=BC=8Cgototop=E4=
=B8=8D=E6=89=93=E7=AE=97=E5=9C=A8=E6=AD=A4=E5=81=9A=E8=AF=A6=E7=BB=86=E8=A7=
=A3=E9=87=8A=E4=BA=86=EF=BC=8C=E5=A6=82=E6=9E=9C=E8=AF=BB=E8=80=85=E6=9C=8B=
=E5=8F=8B=E6=9C=89=E9=9C=80=E6=B1=82=EF=BC=8C=E4=BD=A0=E5=8F=AF=E4=BB=A5=E5=
=8F=82=E8=80=83Metalink=E6=96=87=E6=A1=A3=EF=BC=9A=E2=80=9COverview=20
of Export and Import in =
Oracle7=E2=80=9D=EF=BC=88=E6=96=87=E6=A1=A3=E5=8F=B7=EF=BC=9A61949.1=EF=BC=
=89=E3=80=82=E5=85=B3=E4=BA=8EEXP/IMP=E7=9A=84=E8=AF=A6=E7=BB=86=E5=8F=82=
=E6=95=B0=E4=BF=A1=E6=81=AF=E4=BD=A0=E5=8F=AF=E4=BB=A5=E9=80=9A=E8=BF=87E=
XP/IMP=20
HELP=3DY=E6=9D=A5=E8=8E=B7=E5=BE=97=E3=80=82</P>
=
<P>=E5=8F=A6=E5=A4=96=E5=85=B3=E4=BA=8E=E4=BC=A0=E8=BE=93=E8=A1=A8=E7=A9=BA=
=E9=97=B4=E7=9A=84=E6=9B=B4=E5=A4=9A=E4=BF=A1=E6=81=AF=E5=8F=AF=E4=BB=A5=E5=
=8F=82=E8=80=83=E4=B8=8B=E9=9D=A2=E7=9A=84Metelink=E6=96=87=E6=A1=A3=EF=BC=
=8C=E6=9C=AC=E6=96=87=E4=B8=8D=E5=86=8D=E8=AF=A6=E8=BF=B0=E3=80=82</P>
<P>[NOTE:77523.1] Transportable Tablespaces -- An Example to setup =
and=20
use. </P>
<P>[NOTE:100698.1] Perform tablespace point-in-time recovery using =
Transportable Tablespace. </P>
=
<P>=E5=9C=A8=E8=BF=9B=E8=A1=8C=E5=B9=B6=E8=A1=8CEXP/IMP=E7=9A=84=E6=97=B6=
=E5=80=99=EF=BC=8C=E5=A6=82=E6=9E=9CIMP=E8=BF=87=E7=A8=8B=E5=BB=BA=E7=B4=A2=
=E5=BC=95=E7=9A=84=E8=AF=9D=E4=B8=8D=E5=BB=BA=E8=AE=AE=E5=90=8C=E6=97=B6=E8=
=BF=90=E8=A1=8C5=E4=B8=AA=E4=BB=A5=E4=B8=8A=E7=9A=84IMP=EF=BC=8C=E5=A6=82=
=E6=9E=9C=E4=BD=A0=E6=83=B3=E5=8A=A0=E5=BF=AB=E9=80=9F=E5=BA=A6=EF=BC=8C=E5=
=8F=AF=E4=BB=A5=E5=9C=A8IMP=E7=9A=84=E6=97=B6=E5=80=99=E4=B8=8D=E5=BB=BA=E7=
=B4=A2=E5=BC=95=EF=BC=8C=E8=BF=99=E6=A0=B7=E5=8F=AA=E8=A6=81=E5=86=85=E5=AD=
=98=E5=85=81=E8=AE=B8=EF=BC=8C=E5=8F=AF=E4=BB=A5=E5=A4=9A=E8=B7=91=E5=87=A0=
=E4=B8=AA=EF=BC=8C=E7=84=B6=E5=90=8E=E6=98=AFSQL=E8=84=9A=E6=9C=AC=E5=88=9B=
=E5=BB=BA=E9=9C=80=E8=A6=81=E7=9A=84=E7=B4=A2=E5=BC=95=E3=80=82<BR></P></=
DIV></DIV>
<SCRIPT type=3Dtext/javascript>
//<![CDATA[
Sys.WebForms.PageRequestManager._initialize('AjaxHolder$scriptmanager1', =
document.getElementById('Form1'));
Sys.WebForms.PageRequestManager.getInstance()._updateControls(['tAjaxHold=
er$UpdatePanel1'], [], [], 90);
//]]>
</SCRIPT>
<DIV id=3DAjaxHolder_UpdatePanel1>
<STYLE>TD {
FONT-SIZE: 12px
}
.commentTextBox {
FONT-SIZE: 13px; FONT-FAMILY: Verdana
}
</STYLE>
<!--Beging Temp Save-->
<STYLE>.userData {
BEHAVIOR: url(#default#userdata)
}
</STYLE>
<DIV class=3DuserData id=3DCommentsPersistDiv></DIV>
<SCRIPT type=3Dtext/javascript>
function pageLoad()
{
=
Sys.WebForms.PageRequestManager.getInstance().add_initializeRequest(handl=
eInitializeRequest);
=
//Sys.WebForms.PageRequestManager.getInstance().add_endRequest(handleEndR=
equest);
}
function handleInitializeRequest(sender, args)
{
var prm =3D Sys.WebForms.PageRequestManager.getInstance();
var eid =3D args.get_postBackElement().id;
if (eid.indexOf("DeleteLink")>0)=20
{
args.get_postBackElement().innerHTML =3D "<font =
color=3D'red'>=E6=AD=A3=E5=9C=A8=E5=88=A0=E9=99=A4...</font>"; =20
} =20
else if (eid.indexOf("btnSubmit")>0)=20
{
=
document.getElementById("AjaxHolder_PostComment_ltSubmitMsg").innerHTML=3D=
"=E6=AD=A3=E5=9C=A8=E6=8F=90=E4=BA=A4...";
=
document.getElementById("AjaxHolder_PostComment_btnSubmit").disabled =3D =
true; =20
} =20
else if(eid.indexOf("refreshList")>0)
{
=
document.getElementById("AjaxHolder_PostComment_refreshList").innerHTML=3D=
"<font color=3D'red'>=E6=AD=A3=E5=9C=A8=E5=88=B7=E6=96=B0...</font>";
}
=20
}=09
function TempSave(ElementID)
{
try
{
=
CommentsPersistDiv.setAttribute("CommentContent",document.getElementById(=
ElementID).value);
CommentsPersistDiv.save("CommentXMLStore");
}
catch(ex)
{
}
=09
}
function Restore(ElementID)
{
CommentsPersistDiv.load("CommentXMLStore");
=
document.getElementById(ElementID).value=3DCommentsPersistDiv.getAttribut=
e("CommentContent");
}=09
=09
=09
</SCRIPT>
<!--Ene TempSave-->
<DIV id=3DdivRefreshComments=20
style=3D"FONT-SIZE: 12px; MARGIN-BOTTOM: 5px; MARGIN-RIGHT: 10px; =
TEXT-ALIGN: right"><A=20
id=3DAjaxHolder_PostComment_refreshList=20
=
href=3D"javascript:__doPostBack('AjaxHolder$PostComment$refreshList','')"=
>=E5=88=B7=E6=96=B0=E8=AF=84=E8=AE=BA=E5=88=97=E8=A1=A8</A> </=
DIV>
<DIV class=3Dcommentform><SPAN =
id=3DAjaxHolder_PostComment_ltSubmitMsg=20
style=3D"COLOR: red"></SPAN><BR><A name=3DFeedback></A>
<TABLE cellSpacing=3D1 cellPadding=3D1 border=3D0>
<TBODY>
<TR>
<TD width=3D75></TD>
<TD></TD>
<TD></TD></TR>
<TR>
<TD width=3D55>=E6=A0=87=E9=A2=98</TD>
<TD><INPUT class=3Dcommenttb =
id=3DAjaxHolder_PostComment_tbTitle=20
style=3D"WIDTH: 320px" value=3D"re: =
oracle=E7=9A=84exp=E3=80=81imp=E4=BD=BF=E7=94=A8=E6=8C=87=E5=8D=97"=20
name=3DAjaxHolder$PostComment$tbTitle></TD>
<TD><SPAN id=3DAjaxHolder_PostComment_RequiredFieldValidator1=20
style=3D"VISIBILITY: hidden; COLOR: =
red">=E8=AF=B7=E8=BE=93=E5=85=A5=E6=A0=87=E9=A2=98</SPAN></TD></TR>
<TR>
<TD>=E5=A7=93=E5=90=8D</TD>
<TD><INPUT class=3Dcommenttb =
id=3DAjaxHolder_PostComment_tbName=20
style=3D"WIDTH: 320px" =
name=3DAjaxHolder$PostComment$tbName></TD>
<TD><SPAN id=3DAjaxHolder_PostComment_RequiredFieldValidator2=20
style=3D"VISIBILITY: hidden; COLOR: =
red">=E8=AF=B7=E8=BE=93=E5=85=A5=E4=BD=A0=E7=9A=84=E5=A7=93=E5=90=8D</SPA=
N></TD></TR>
<TR>
<TD>=E4=B8=BB=E9=A1=B5</TD>
<TD><INPUT class=3Dcommenttb id=3DAjaxHolder_PostComment_tbUrl =
style=3D"WIDTH: 320px" =
name=3DAjaxHolder$PostComment$tbUrl></TD>
<TD><FONT face=3D=E5=AE=8B=E4=BD=93></FONT></TD></TR>
<TR>
<TD align=3Dleft colSpan=3D3>
<TABLE class=3DCommentForm =
id=3DAjaxHolder_PostComment_tbCaptchaImage=20
cellSpacing=3D0 cellPadding=3D0 border=3D0>
<TBODY>
<TR>
<TD colSpan=3D3><SPAN=20
id=3DAjaxHolder_PostComment_Requiredfieldvalidator4=20
style=3D"DISPLAY: none; COLOR: =
red">=E8=AF=B7=E8=BE=93=E5=85=A5=E9=AA=8C=E8=AF=81=E7=A0=81</SPAN> <SPAN =
id=3DAjaxHolder_PostComment_lblImage=20
style=3D"FONT-WEIGHT: bold; COLOR: =
red"></SPAN></TD></TR>
<TR>
<TD width=3D78>=E9=AA=8C=E8=AF=81=E7=A0=81</TD>
<TD><INPUT id=3DAjaxHolder_PostComment_CodeNumberTextBox =
=
name=3DAjaxHolder$PostComment$CodeNumberTextBox>* <IMG=20
=
src=3D"http://www.blogjava.net/Modules/CaptchaImage/JpegImage.aspx?cachei=
d=3D20071107231118"></TD>
<TD align=3Dleft></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD =
colSpan=3D3>=E5=86=85=E5=AE=B9(=E8=AF=B7=E4=B8=8D=E8=A6=81=E5=8F=91=E8=A1=
=A8=E4=BB=BB=E4=BD=95=E4=B8=8E=E6=94=BF=E6=B2=BB=E7=9B=B8=E5=85=B3=E7=9A=84=
=E5=86=85=E5=AE=B9) <SPAN=20
id=3DAjaxHolder_PostComment_RequiredFieldValidator3=20
style=3D"VISIBILITY: hidden; COLOR: =
red">=E8=AF=B7=E8=BE=93=E5=85=A5=E8=AF=84=E8=AE=BA=E5=86=85=E5=AE=B9</SPA=
N><BR><TEXTAREA class=3DcommentTextBox =
id=3DAjaxHolder_PostComment_tbComment =
onkeydown=3D"ctlent(event,'AjaxHolder_PostComment_tbComment')" =
style=3D"WIDTH: 480px; HEIGHT: 220px" =
name=3DAjaxHolder$PostComment$tbComment rows=3D10 =
cols=3D50></TEXTAREA></TD></TR>
<TR>
<TD colSpan=3D3><SPAN id=3DAjaxHolder_PostComment_Message=20
style=3D"COLOR: red"></SPAN></TD>
<TR>
<TD colSpan=3D3><INPUT id=3DAjaxHolder_PostComment_chkRemember =
tabIndex=3D-1 type=3Dcheckbox CHECKED=20
name=3DAjaxHolder$PostComment$chkRemember><LABEL=20
for=3DAjaxHolder_PostComment_chkRemember>Remember =
Me?</LABEL></TD></TR>
<TR>
<TD height=3D23><INPUT class=3DcommentButton =
id=3DAjaxHolder_PostComment_btnSubmit =
onclick=3D"TempSave('AjaxHolder_PostComment_tbComment');WebForm_DoPostBac=
kWithOptions(new =
WebForm_PostBackOptions("AjaxHolder$PostComment$btnSubmit", =
"", true, "", "", false, false))" =
type=3Dsubmit value=3D=E6=8F=90=E4=BA=A4 =
name=3DAjaxHolder$PostComment$btnSubmit>=20
</TD>
<TD colSpan=3D2 height=3D23> <A =
id=3DAjaxHolder_PostComment_lnkLogin=20
=
href=3D"http://www.blogjava.net/login.aspx?ReturnURL=3Dhttp://www.blogjav=
a.net/huanghuizz/articles/157687.html&SourceURL=3D/huanghuizz/article=
s/157687.html">=E7=99=BB=E5=BD=95</A> <A=20
id=3DAjaxHolder_PostComment_linkLoginComment=20
=
onclick=3D"if(document.getElementById('AjaxHolder_PostComment_tbComment')=
.value !=3D '') return =
confirm('=E6=9C=AA=E6=8F=90=E4=BA=A4=E7=9A=84=E8=AF=84=E8=AE=BA=E5=86=85=E5=
=AE=B9=E5=B0=86=E4=BC=9A=E4=B8=A2=E5=A4=B1, =
=E4=BD=A0=E7=9C=9F=E7=9A=84=E8=A6=81=E8=BF=9B=E5=85=A5=E9=AB=98=E7=BA=A7=E8=
=AF=84=E8=AE=BA=E5=90=97?');"=20
=
href=3D"http://www.blogjava.net/huanghuizz/articles/157687.html?login=3D1=
#Post">=E4=BD=BF=E7=94=A8=E9=AB=98=E7=BA=A7=E8=AF=84=E8=AE=BA</A> &n=
bsp;<A=20
=
href=3D"http://www.blogjava.net/RequireRegister.aspx">=E6=96=B0=E7=94=A8=E6=
=88=B7=E6=B3=A8=E5=86=8C</A> <A=20
=
href=3D"http://www.blogjava.net/huanghuizz/articles/157687.html#Top">=E8=BF=
=94=E5=9B=9E=E9=A1=B5=E9=A6=96</A> <A=20
id=3DAjaxHolder_PostComment_lbRestore=20
onclick=3D"Restore('AjaxHolder_PostComment_tbComment'); =
return false;"=20
=
href=3D"http://www.blogjava.net/huanghuizz/articles/157687.html#Post">=E6=
=81=A2=E5=A4=8D=E4=B8=8A=E6=AC=A1=E6=8F=90=E4=BA=A4</A> =
=20
</TD></TR>
<TR>
<TD colSpan=3D3><LABEL=20
=
class=3DCtrlEnter>[=E4=BD=BF=E7=94=A8Ctrl+Enter=E9=94=AE=E5=8F=AF=E4=BB=A5=
=E7=9B=B4=E6=8E=A5=E6=8F=90=E4=BA=A4]</LABEL></TD></TR>
<TR>
<TD colSpan=3D3></TD></TR>
<TR>
<TD colSpan=3D3 height=3D5> </TD></TR>
<TR>
<TD colSpan=3D3 height=3D5></TD></TR>
<TR>
<TD colSpan=3D3 height=3D5> </TD></TR>
<TR>
<TD colSpan=3D3 height=3D5>
<DIV =
id=3DdivRelativePosts>=E7=9B=B8=E5=85=B3=E6=96=87=E7=AB=A0:=20
<UL style=3D"MARGIN-TOP: 0px">
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?