RE: Any woraround for this ....?

-----Original Message-----
From: Muthaiah, VSNL [mailto:muthaiah@vsnl.net]
Sent: Friday, September 06, 2002 10:08 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Any woraround for this ....?

Richard,

 

You are right. But for me, the organization for which I work, has around 20 branches and not all the branches has support person. So It will be difficult for us to get the DMP's on a regular basis. The requirement is that, we are in the process of making a sort of global db of all our branches by automating this. The script that I aim will be run and able to gather the data entered for the day and send it by mail. The other station can just run the same to store the data.

 

Muths

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

From: Richard Huntley

To: Multiple recipients of list ORACLE-L

Sent: Thursday, September 05, 2002 7:03 PM

Subject: 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, why

not 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 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: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 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

 

 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Naveen Nahata
  INET: naveen_nahata_at_mindtree.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).