Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Any woraround for this ....?
----- Original Message -----From: Richard HuntleySent: Thursday, September 05, 2002 7:03 PMSubject: RE: Any woraround for this ....?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, whynot just use table level export/import.-----Original Message-----
From: Muthaiah, VSNL [mailto:muthaiah@vsnl.net]
Sent: Thursday, September 05, 2002 1:58 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Any woraround for this ....?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 1Am i missing some thing?Rgds,Muths----- Original Message -----From: Seefelt, BethSent: Wednesday, September 04, 2002 7:18 PMSubject: RE: Any woraround for this ....?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-----
From: Muthaiah, VSNL [mailto:muthaiah@vsnl.net]
Sent: Wednesday, September 04, 2002 6:48 AM
To: Multiple recipients of list ORACLE-L
Subject: Any woraround for this ....?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 1First 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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muthaiah, VSNL INET: muthaiah_at_vsnl.net 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 - 23:38:20 CDT