RE: Does the RECORD option for EXP do anything?

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Tue, 5 Dec 2006 13:50:57 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08918@EXCNYSM0A1AJ.nysemail.nyenet>

Rich,

From the Oracle 8i documentation:

RECORD Default: Y

Indicates whether or not to record an incremental or cumulative export in the system tables SYS.INCEXP, SYS.INCFIL, and SYS.INCVID. For information about these tables, see System Tables.

I'd say this was an obsolete parameter. It still shows up under 10g if you run "exp help=y" but is gone from the documentation.

Tom

---

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jesse, Rich Sent: Tuesday, December 05, 2006 1:19 PM To: ORACLE-L
Subject: Does the RECORD option for EXP do anything?

Hey all,

Helping debug an export (not DP) on 10.1.0 on a Winders 2K3 Server where it has started inexplicably hanging, waiting in "SQL*Net Message from client". It uses conventional path and I was wondering if the defaulted "RECORD=Y" was possibly causing the issue, since I've used RECORD=N. So I went to Tahiti -- the webpage, not the island. There is no record of the RECORD option of exp in the 9.2 nor 10.1 utilities manuals.

Curiousity got me so I started doing trials with DBMS_SUPPORT.START_TRACE(WAITS=>TRUE, BINDS=>TRUE) active in a logon trigger in another 10.1 DB on Linux. The trace outputs are almost exactly the same between traces using RECORD=N and RECORD=Y, save for timing differences, as reported by sdiff and awk.

So is the RECORD option just an obsolete placeholder? I'm not having any luck searching with the ubiquitous "record".

TIA,
Rich
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 05 2006 - 12:50:57 CST