Re: SQL Function

From: Venugopal V V S <venug_at_cse.iitb.ernet.in>
Date: Fri, 14 Jul 2000 17:59:30 +0530 (IST)
Message-Id: <10558.112060@fatcity.com>

Hi,
Just follow the acompanying messages with this error. "show error" can help and also try
select * from user_errors;
Rgds..

---

Venu Gopal VVS.
Software Engineer.
Project SMARS.
Dept. of Comp. Sc. & Engg.
IIT Bombay, Powai
Mumbai, INDIA, 4000076
Lab.Phone.5782545 X 8913
Direct Ph. 5768703
Tansa Room# 331 Ph.5612                  

		URL         http://venug.8m.com/index.htm
                Resume      http://venug.8m.com/resume.htm
_____________________________________________________________________________

On Fri, 14 Jul 2000, Uma Sankara_Sivadanam wrote:

> Hi All,
>
> When i create a new SQL function, while compiling it it is giving a message
> telling input truncated to 1 character.what is this error?Any idea?
>
> Thanx
> Uma Shankar
>
>
>
>
> > ----------
> > From: blair_at_pjm.com[SMTP:blair_at_pjm.com]
> > Reply To: ORACLE-L_at_fatcity.com
> > Sent: Friday, July 14, 2000 6:20 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Snapshot too old
> >
> > We are having trouble exporting a database with several large,
> > insert-active
> > tables. Exporting these tables causes a 1555 "Snapshot too old" error.
> > The
> > error message says use larger rollback segments. I doubled the size of
> > our
> > rollback segs but I don't want to make them all bigger just for one
> > occasional
> > export.
> >
> > Is there a way to create a and use a very large rollback segment just for
> > the
> > export? How would you approach solving this problem - this is a
> > production
> > database and taking it off-line is probably not possible.
> >
> > tia,
> >
> > ..tom
> >
> >
> >
> >
> > --
> > Author:
> > INET: blair_at_pjm.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 Fri Jul 14 2000 - 07:29:30 CDT