Re: ora-01458

From: Kimberly Smith <KSMITH1_at_gmd.fujitsu.com>
Date: 27 Apr 2000 07:45:20 -0700
Message-Id: <10480.104321@fatcity.com>

--=_ORCL_5869630_0r0
Content-Type:text/plain; charset="iso-8859-1" Content-Transfer-Encoding:quoted-printable

Read up on longs. Can't do that. There is a whole list of things that just cannot be done when dealing with longs. You may be able to write some Pro*C code to do what you want. Well maybe even some PL/SQL as long as the biggest long you have is 32k or less.

Kimberly Smith
EDS/Fujitsu
Gresham, Oregon
Work: 503-669-6050
Email: kimberly.smith_at_gmd.fujitsu.com

kimberly.smith_at_eds.com

--=_ORCL_5869630_0r0
content-type:message/rfc822

Date: 26 Apr 2000 17:28:05
From:Alex Hillman <alex_hillman_at_physia.com> To:Multiple recipients of list ORACLE-L <ORACLE-L> Subject:ora-01458
Reply-to:UNIX.IOGMD:ORACLE-L_at_fatcity.com Return-Path:root_at_fatcity.cts.com

Message-ID:<F001.00151C8B.20000426162805_at_fatcity.com> X-Comment:Oracle RDBMS Community Forum
X-Sender:Alex Hillman <alex_hillman_at_physia.com> Sender:root_at_fatcity.com
Errors-To:ML-ERRORS_at_fatcity.com
Organization:Fat City Network Services, San Diego, California X-ListServer:v1.0f, build 68; ListGuru (c) 1996-2000 Bruce A. Bergman Precedence: bulk
MIME-Version: 1.0
Content-Type:multipart/alternative;

boundary="=_ORCL_5864031_0r2.0"

--=_ORCL_5864031_0r2.0
Content-Type:text/plain; charset=iso-8859-1 Content-Transfer-Encoding:quoted-printable

I am trying to execute script in sqlplus

set long 80000

delete from ref_cpt;
commit;

copy from demo01/demo_at_sdedbs02 insert ref_cpt using select * from ref_cpt;

exit

It gives me error ora-01458.

Cause: An attempt was made to bind or define a variable character string with a buffer length less than the minimum requirement.

Action: Increase the buffer size or use a different type.

This table has one column with long datatype.

Any ideas pleas

--=_ORCL_5864031_0r2.0
Content-Type:text/html; charset=iso-8859-1 Content-Transfer-Encoding:quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Diso-8859-1=
">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version 5.5.2448.0">
<TITLE>ora-01458</TITLE>
</HEAD>
<BODY>

I am trying to execute script in sqlplus</F=
ONT>


set long 80000


delete from ref_cpt;
 commit;


copy from demo01/demo_at_sdedbs02 insert ref_c=
pt using select * from ref_cpt;


exit


It gives me error ora-01458.


Cause: An attempt was ma=
de to bind or define a variable character string with a buffer length less t= han the minimum  requirement.

  Action: Increase =
the buffer size or use a different type. 


This table has one colum=
n with long datatype.

 

Any ideas pleas


</BODY>
</HTML>

--=_ORCL_5864031_0r2.0--

--=_ORCL_5869630_0r0--

From: blair_at_pjm.com
Date: Thu, 27 Apr 2000 10:55:15 -0400
Subject: RE: Archiver Tunning ? [RE: dbms_job question ??]

We are using SQLBacktrack and like it on our non-OPS servers. This problem however is with an OPS server and Backtrack does not support OPS.

..tom

> -----Original Message-----
> From:	renato.huliganga_at_au1.ibm.com [SMTP:renato.huliganga_at_au1.ibm.com]
> Sent:	Thursday, April 27, 2000 10:48 AM
> To:	Multiple recipients of list ORACLE-L
> Subject:	Re: Archiver Tunning ? [RE: dbms_job question ??]
> 
> You might want to look at SQLBackTrack (www.bmc.com) for your backup
> solution. It works with V7x, RMAN works only from V8x. Both products works
> in similar principles, i.e. quick backup window, block level copying, use
> of catalog, etc.
> 
> - Renato
> 
> 
> 
> "Deshpande, Kirti" <Kirti.Deshpande_at_gtedc.gte.com> on 27/04/2000 02:56:20
> 
> Please respond to ORACLE-L_at_fatcity.com
> 
> To:   Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc:    (bcc: Renato Huliganga/Australia/IBM)
> 
> 
> 
> 
> If you have not already done so, please take a look at Note # 45042.1 on
> Metalink (Archiver Best Practices). It offers some suggestions that may be
> of some help to you.  Also, have you considered upgrading to Oracle 8.x and
> take advantage of RMAN for your backups?
> - Kirti
> 
> > -----Original Message-----
> > From:   blair_at_pjm.com [SMTP:blair_at_pjm.com]
> > Sent:   Wednesday, April 26, 2000 8:55 AM
> > To:     Multiple recipients of list ORACLE-L
> > Subject:     RE: dbms_job question ??
> >
> > We are running Oracle 7.3.2.3 OPS on AIX 4.2.1
> >
> > Our database is 600G and extremely insert-intensive (330M per 15
> minutes).
> >
> > During hot backup (which takes 10 hours) all 23 on-line redo logs usually
> > fill
> > and the database stops
> > because they are filling faster than the archive process can copy them to
> > the
> > archive filesystem.
> >
> > Can anyone suggest any Oracle tuning that may help?  I cant think of
> > anything.
> > Is there a way (in Unix) to give the archiver an exclusive lock on the
> > archive
> > filesystem during a redo log write?
> >
> > ..tom
> > --
> > Author:
> >   INET: blair_at_pjm.com
> >
> >
> --
> Author: Deshpande, Kirti
>   INET: Kirti.Deshpande_at_gtedc.gte.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).
> 
> 
> 
> -- 
> Author: 
>   INET: renato.huliganga_at_au1.ibm.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).


------------------------------

From: "Deshpande, Kirti" <Kirti.Deshpande_at_gtedc.gte.com> Date: Thu, 27 Apr 2000 09:49:51 -0500
Subject: dbx related [ was : Segmentation Fault w/ 8.1.6 Pro*C programs]

It is a symbolic debugger on some UNIX platforms. What I know about 'dbx' is very basic. Enough to get by during 'crunch' time. Your best bet to learn more about it, is starting with the man pages. To investigate and run a program I use 'dbx progname core'. There is a 'help' command to assist you with the available directives from then on.

Kirti

> -----Original Message-----
> From:	Srinivasan Subramanian kandallu [SMTP:srinivasan.kandallu_at_wipro.com]
> Sent:	Thursday, April 27, 2000 12:33 AM
> To:	Multiple recipients of list ORACLE-L
> Subject:	RE: Segmentation Fault w/ 8.1.6 Pro*C programs
> 
> Could you please tell me how to use dbx command when core dump occurs.
> 
> Srini
> 
> 
> -----Original Message-----
> Kirti
> Sent: Wednesday, April 26, 2000 7:44 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi,
>  Has anyone come across Segmentation Fault error with 8.1.6 Pro*C
> programs?
> The fault appears when a full path name of the Pro*C executable is longer
> than 54 characters. However, anything shorter than that, works fine. When
> I
> used 'dbx' to check the generated core, it pointed to a failure in
> 'libclntsh.a' shared liabrary (This is on an AIX 4.3.3 machine). This used
> to work in the previous versions of Oracle (7.x and 8.x). Any known
> workarounds? Using shorter path names is not an option at this time. 
> 
> Thanks.
> 
> - Kirti    
> 
> 
> -- 
> Author: Deshpande, Kirti
>   INET: Kirti.Deshpande_at_gtedc.gte.com
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

Received on Thu Apr 27 2000 - 09:45:20 CDT