RE: ORA-01459

select * from V$NLS_PARAMETERS;

or ( to be more selective ) : select VALUE from V$NLS_PARAMETERS where PARAMETER='NLS_CHARACTERSET';
> ----------
> From: Weerd de E.C. Kirsten[SMTP:Kirsten.deWeerd_at_Oranjewoud.nl]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Monday, May 15, 2000 13:27
> To: Multiple recipients of list ORACLE-L
> Subject: RE: ORA-01459
>
> Maybe a silly question, but where can I check the characterset ?
>
> > -----Original Message-----
> > From: Rahul [SMTP:rahul_at_ratelindo.co.id]
> > Sent: Monday, May 15, 2000 9:59 AM
> > To: 'ORACLE-L_at_fatcity.com'
> > Cc: 'Kirsten.deWeerd_at_oranjewoud.nl'
> > Subject: RE: ORA-01459
> >
> > could be a characterset difference between two DBs
> >
> > > ----------
> > > From: Weerd de E.C. Kirsten[SMTP:Kirsten.deWeerd_at_oranjewoud.nl]
> > > Reply To: ORACLE-L_at_fatcity.com
> > > Sent: 15 Mei 2000 16:44
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: ORA-01459
> > >
> > > We copied everything from our main system to a test system.
> > >
> > > Everything meaning the complete database and all required
> > > application-software.
> > >
> > > While everything is working fine in our main system, we are now
> getting
> > > errors within a form (master - detail) :
> > >
> > > ORA-01459: invalid length for variable character string
> > >
> > > Any clues is to what fault I am looking for ?
> > >
> > > Greets,
> > >
> > > Kirsten
> > > --
> > > Author: Weerd de E.C. Kirsten
> > > INET: Kirsten.deWeerd_at_Oranjewoud.nl
> > >
> > > 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: Weerd de E.C. Kirsten
> INET: Kirsten.deWeerd_at_Oranjewoud.nl
>
> 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).
>

                                                          
Visit us at http://www.clearstream.com           
                                                          

IMPORTANT MESSAGE Internet communications are not secure and therefore Clearstream International does not accept legal responsibility for the contents of this message.

The information contained in this e-mail is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any views expressed in this e-mail are those of the individual sender, except where the sender specifically states them to be the views of Clearstream International or of any of its affiliates or subsidiaries. Received on Mon May 15 2000 - 06:16:44 CDT