RE: Any woraround for this ....?

[Richard Huntley]

Title: Message

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----- From: Muthaiah, VSNL [mailto:[EMAIL PROTECTED]] 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 1   Am i missing some thing?   Rgds,   Muths ----- Original Message ----- From: Seefelt, Beth To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 04, 2002 7:18 PM Subject: 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:[EMAIL PROTECTED]] 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 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