Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP - Oracle Schema Import problem

Re: HELP - Oracle Schema Import problem

From: Johne_uk <edgarj_at_tiscali.co.uk>
Date: Fri, 27 Jul 2007 07:34:23 -0700
Message-ID: <1185546863.685277.116350@g4g2000hsf.googlegroups.com>


PLEASE IGNORE THE POSTING AT THE BOTTOM - i was looking at session parameters. All servers are setup as below :-

NLS_LANGUAGE  =  AMERICAN
NLS_TERRITORY  =  AMERICA
NLS_CURRENCY  =  $
NLS_ISO_CURRENCY  =  AMERICA
NLS_NUMERIC_CHARACTERS  =  .,
NLS_CHARACTERSET  =  WE8ISO8859P1
NLS_CALENDAR  =  GREGORIAN
NLS_DATE_FORMAT  =  DD-MON-RR
NLS_DATE_LANGUAGE  =  AMERICAN
NLS_SORT  =  BINARY
NLS_TIME_FORMAT  =  HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT  =  DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT  =  HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT  =  DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY  =  $
NLS_COMP  =  BINARY
NLS_LENGTH_SEMANTICS  =  BYTE
NLS_NCHAR_CONV_EXCP  =  FALSE
NLS_NCHAR_CHARACTERSET  =  AL16UTF16
NLS_RDBMS_VERSION  =  9.2.0.8.0



n 27 Jul, 15:20, Johne_uk <edg..._at_tiscali.co.uk> wrote:
> One server is in the UK and the slow one in the US. Both servers have
> the same NLS settings (see below). However, I believe the unix Server
> in the US has its locale set to the US - is this a potential issue?
>
> rgds
>
> NLS_LANGUAGE = ENGLISH
> NLS_TERRITORY = UNITED KINGDOM
> NLS_CURRENCY =
> NLS_ISO_CURRENCY = UNITED KINGDOM
> NLS_NUMERIC_CHARACTERS = .,
> NLS_CALENDAR = GREGORIAN
> NLS_DATE_FORMAT = DD-MON-RR
> NLS_DATE_LANGUAGE = ENGLISH
> NLS_SORT = BINARY
> NLS_TIME_FORMAT = HH24.MI.SSXFF
> NLS_TIMESTAMP_FORMAT = DD-MON-RR HH24.MI.SSXFF
> NLS_TIME_TZ_FORMAT = HH24.MI.SSXFF TZR
> NLS_TIMESTAMP_TZ_FORMAT = DD-MON-RR HH24.MI.SSXFF TZR
> NLS_DUAL_CURRENCY =
> NLS_COMP = BINARY
> NLS_LENGTH_SEMANTICS = BYTE
> NLS_NCHAR_CONV_EXCP = FALSE
Received on Fri Jul 27 2007 - 09:34:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US