📄 strms.htm
字号:
<!DOCTYPE html public "-//w3c//dtd html 3.2 transitional//en.us"><HTML lang="en.us"><HEAD><META NAME="Generator" CONTENT="Quadralay WebWorks Publisher 5.0.4"><META NAME="Page" CONTENT="DefaultSingle"><META NAME="Title" CONTENT=" Oracle9i Streams "><TITLE> Oracle9i Streams </TITLE> <LINK REL="home" HREF="../../products.htm" TITLE="Library"><LINK REL="toc" HREF="toc.htm" TITLE="Contents"><LINK REL="index" HREF="index.htm" TITLE="Index"><LINK REL="copyright" HREF="../dcommon/html/cpyr.htm" TITLE="Copyright"><LINK REL="up" HREF="toc.htm" TITLE="Up"><LINK REL="next" HREF="arpls.htm" TITLE="Next"><LINK REL="previous" HREF="sqlrf.htm" TITLE="Previous"></HEAD> <BODY BGCOLOR="#ffffff"><A NAME="top"></A><TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%"><TR> <TD ALIGN="LEFT" VALIGN="TOP"><FONT COLOR="#330099" FACE="Helvetica, Arial, sans-serif"><B>Oracle9<i>i</i> Database Generic Documentation Addendum<BR>Release 2 (9.2)</B><BR>Part Number A97283-01</FONT></B></TD><td valign="BOTTOM" align="RIGHT" width="144"><table cellspacing="0" cellpadding="0" width="50%"><TR><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"><A HREF="toc.htm"><IMG SRC="conticon.gif" ALT="Go To Table Of Contents" BORDER="0" HEIGHT="30"WIDTH="30"><BR><FONT SIZE="-2">Contents</FONT></A></TD><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"><A HREF="index.htm"><IMG SRC="indxicon.gif" ALT="Go To Index" BORDER="0" HEIGHT="30"WIDTH="30"><BR><FONT SIZE="-2">Index</FONT></A></TD></TR></TABLE></TD></TR></TABLE><HR><P><A HREF="sqlrf.htm"><IMG SRC="larrow.gif" ALT="Go to previous page" BORDER="0" HEIGHT="30" WIDTH="40"></A><A HREF="arpls.htm"><IMG SRC="rarrow.gif" ALT="Go to next page" BORDER="0" HEIGHT="30" WIDTH="40"></A> <DIV CLASS="IND"><!-- End Header --><A NAME="1005227"></A><!--TOC=Title-"1005227"--><H1 CLASS="Title"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">10<BR> Oracle9<EM CLASS="Italic">i</EM> Streams </FONT></H1><!--/TOC=Title--><A NAME="1005603"></A><P CLASS="BP">This chapter lists additions and corrections to <EM CLASS="Italic">Oracle9i Streams</EM>, Release 2 (9.2).</P><A NAME="1005614"></A><P CLASS="BP">This chapter contains the following topics:</P><UL CLASS="LB1"><LI CLASS="LB1" TYPE="DISC"><A NAME="1005232"></A><A HREF="strms.htm#1005285">NOLOGGING and UNRECOVERABLE Keywords</a><P><LI CLASS="LB1" TYPE="DISC"><A NAME="1005331"></A><A HREF="strms.htm#1004625">Performing Full Database Export/Import on a Database Using Streams</a><P><LI CLASS="LB1" TYPE="DISC"><A NAME="1005366"></A><A HREF="strms.htm#1005360">Documentation Corrections</a><P></UL><A NAME="1005285"></A><!--TOC=h1-"1005285"--><H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> NOLOGGING and UNRECOVERABLE Keywords</FONT></H2><!--/TOC=h1--><A NAME="1005286"></A><P CLASS="BP">If you use the <CODE>NOLOGGING</CODE> or <CODE>UNRECOVERABLE</CODE> keyword for a SQL operation, then the changes resulting from the SQL operation cannot be captured by a capture process. Therefore, if the changes resulting from a SQL operation should be captured by a capture process, then do not use these keywords.</P><A NAME="1005354"></A><P CLASS="BP">If the object for which you are specifying the logging attributes resides in a database or tablespace in <CODE>FORCE</CODE> <CODE>LOGGING</CODE> mode, then Oracle ignores any <CODE>NOLOGGING</CODE> or <CODE>UNRECOVERABLE</CODE> setting until the database or tablespace is taken out of <CODE>FORCE</CODE> <CODE>LOGGING</CODE> mode. You can determine the current logging mode for a database by querying the <CODE>FORCE_LOGGING</CODE> column in the <CODE>V$DATABASE</CODE> dynamic performance view.</P> <A NAME="1005287"><DIV ALIGN="CENTER"><P><TABLE CLASS="Note" BORDER="0" WIDTH="80%" CELLPADDING="0" CELLSPACING="0" dir="ltr"><TR CLASS="Note"><TD CLASS="Note"><HR><A NAME="1005290"></A><FONT FACE="Arial, Helvetica, sans-serif"><STRONG CLASS="NH">Note:</STRONG></FONT><A NAME="1005291"></A><P CLASS="NB">The <CODE>UNRECOVERABLE</CODE> keyword is deprecated and has been replaced with <CODE>NOLOGGING</CODE>. Although <CODE>UNRECOVERABLE</CODE> is supported for backward compatibility, Oracle Corporation strongly recommends that you use the <CODE>NOLOGGING</CODE> keyword, when appropriate. <HR></TD></TR></TABLE><TABLE CLASS="TableNote" CELLPADDING="3" dir="ltr"><TR CLASS="TableNote" ALIGN=LEFT VALIGN=TOP><TD CLASS="TableNote"></TD></TR></TABLE></DIV></A><A NAME="1005292"><DIV ALIGN="CENTER"><P><TABLE CLASS="NoteAlso" BORDER="0" WIDTH="80%" CELLPADDING="0" CELLSPACING="0" dir="ltr"><TR CLASS="NoteAlso"><TD CLASS="NoteAlso"><A NAME="1005295"></A><FONT FACE="Arial, Helvetica, sans-serif"><STRONG CLASS="NH">See Also:</STRONG></FONT><A NAME="1005296"></A><P CLASS="NB"><EM CLASS="Italic">Oracle9i SQL Reference</EM> for more information about the <CODE>NOLOGGING</CODE> and <CODE>UNRECOVERABLE</CODE> keywords, and for more information about <CODE>FORCE</CODE> <CODE>LOGGING</CODE> mode </TD></TR></TABLE><TABLE CLASS="TableNote" CELLPADDING="3" dir="ltr"><TR CLASS="TableNote" ALIGN=LEFT VALIGN=TOP><TD CLASS="TableNote"></TD></TR></TABLE></DIV></A> <A NAME="1004625"></A><!--TOC=h1-"1004625"--><H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Performing Full Database Export/Import on a Database Using Streams</FONT></H2><!--/TOC=h1--><A NAME="1005564"></A><P CLASS="BP">This section describes how to perform a full database export/import on a database that is running one or more Streams capture processes, propagation jobs, or apply processes. These instructions pertain to a full database export/import where the import database and export database are running on different computers, and the import database replaces the export database. The global name of the import database and the global name of the export database must match.</P> <A NAME="1004989"><DIV ALIGN="CENTER"><P><TABLE CLASS="Note" BORDER="0" WIDTH="80%" CELLPADDING="0" CELLSPACING="0" dir="ltr"><TR CLASS="Note"><TD CLASS="Note"><HR><A NAME="1004992"></A><FONT FACE="Arial, Helvetica, sans-serif"><STRONG CLASS="NH">Note:</STRONG></FONT><A NAME="1004993"></A><P CLASS="NB">If you want to add a database to an existing Streams environment, then do not use the instructions in this section. Instead, see the "Configuring a Streams Environment" chapter in <EM CLASS="Italic">Oracle9i Streams</EM>. <HR></TD></TR></TABLE><TABLE CLASS="TableNote" CELLPADDING="3" dir="ltr"><TR CLASS="TableNote" ALIGN=LEFT VALIGN=TOP><TD CLASS="TableNote"></TD></TR></TABLE></DIV></A><A NAME="1004680"><DIV ALIGN="CENTER"><P><TABLE CLASS="NoteAlso" BORDER="0" WIDTH="80%" CELLPADDING="0" CELLSPACING="0" dir="ltr"><TR CLASS="NoteAlso"><TD CLASS="NoteAlso"><A NAME="1004675"></A><FONT FACE="Arial, Helvetica, sans-serif"><STRONG CLASS="NH"><STRONG CLASS="Bold">See Also</STRONG>:</STRONG></FONT><A NAME="1004679"></A><P CLASS="NB"><EM CLASS="Italic">Oracle9i Database Utilities</EM> for more information about performing a full database export/import </TD></TR></TABLE><TABLE CLASS="TableNote" CELLPADDING="3" dir="ltr"><TR CLASS="TableNote" ALIGN=LEFT VALIGN=TOP><TD CLASS="TableNote"></TD></TR></TABLE></DIV></A> <A NAME="1004661"></A><P CLASS="BP">Complete the following steps to perform a full database export/import on a database that is using Streams:</P>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -