Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Any woraround for this ....?
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C254D7.829AF390"
------_=_NextPart_001_01C254D7.829AF390
Content-Type: text/plain;
charset="iso-8859-1"
Muths,
What is the purpose of having the table data dumps? If you're just going to use them to load data back into Oracle, why not just use table level export/import.
-----Original Message-----
Sent: Thursday, September 05, 2002 1:58 AM
To: Multiple recipients of list ORACLE-L
Thanks. I did as you said but now with the following error. It writes for the first table and then this error crops.
SQL> exec extract
BEGIN extract; END;
*
ERROR at line 1:
ORA-20001: 1User-Defined Exception ORA-06512: at "SCOTT.EXTRACT", line 119 ORA-06512: at line 1
Am i missing some thing?
Rgds,
Muths
Remove all the dbms_output calls and use utl_file. It should get around this error, and its not possible to get the below error with utl_file so you must have missed something when you tried it the first time.
HTH,
Beth
-----Original Message-----
Sent: Wednesday, September 04, 2002 6:48 AM To: Multiple recipients of list ORACLE-L
Hi,
I'm writing a procedure/script for extract the data of all the tables in a schema. When I am trying to spool/write into a file, I am getting the following error.
ORA-20001: -20000ORA-20000: ORU-10028: line length overflow, limit of 255
bytes per line
ORA-06512: at "SCOTT.EXTRACT", line 115
ORA-06512: at line 1
First I tried to spool to a file.But got the error line length overflow. I
have tried using the UTL_FILE option also. But getting the same error. Can
anyone in the list has any work around for this?
Thanks in Advance,
Muths
------_=_NextPart_001_01C254D7.829AF390
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 5.00.3314.2100" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=028054612-05092002>Muths,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=028054612-05092002></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=028054612-05092002>What
is the purpose of having the table data dumps? If you're just going to use
them to load data back into Oracle, why</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=028054612-05092002>not
just use table level export/import.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=028054612-05092002></SPAN></FONT> </DIV>
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Muthaiah, VSNL
[mailto:muthaiah_at_vsnl.net]<BR><B>Sent:</B> Thursday, September 05, 2002 1:58
AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Re: Any
woraround for this ....?<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Thanks. I did as you said but now with the
following error. It writes for the first table and then this error crops.
</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>SQL> exec extract<BR>BEGIN extract;
END;</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>*<BR>ERROR at line 1:<BR>ORA-20001: 1User-Defined
Exception<BR>ORA-06512: at "SCOTT.EXTRACT", line 119<BR>ORA-06512: at line
1</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Am i missing some thing?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Rgds,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Muths</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A href="mailto:Beth.Seefelt_at_TetleyUSA.com"
title=Beth.Seefelt_at_TetleyUSA.com>Seefelt, Beth</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A href="mailto:ORACLE-L_at_fatcity.com"
title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, September 04, 2002 7:18
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: Any woraround for this
....?</DIV> <DIV><BR></DIV> <DIV><FONT color=#0000ff face=Arial size=2></FONT> </DIV> <DIV><SPAN class=126394412-04092002><FONT color=#0000ff face=Arialsize=2>Remove all the dbms_output calls and use utl_file. It should get around this error, and its not possible to get the below error with utl_file so you must have missed something when you tried it the first time.</FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>I'm writing a procedure/script for extract thedata of all the tables in a schema. When I am trying to spool/write into a file, I am getting the following error. </FONT></DIV> <DIV> </DIV>
<DIV> </DIV> <DIV><FONT face=Arial size=2>Thanks in Advance,</FONT></DIV> <DIV> </DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>Muths</FONT></DIV> <DIV> </DIV> <DIV> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C254D7.829AF390--
------=_NextPartTM-000-4a7600ed-c06e-11d6-8b14-00b0d04949c1--
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley INET: rhuntley_at_mindleaders.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Sep 05 2002 - 08:33:26 CDT
![]() |
![]() |