Oracle trideni II

Milan Sorm xsorm na informatics.muni.cz
Pátek Březen 17 09:14:42 CET 2000


Fri, Mar 17, 2000 ve 08:12:25AM +0000 Vladimir Naprstek napsal:
# Milan Sorm wrote:
# 
# > Cim ? exp ?
# >
# 
# exp user/passwd file=filename tables=(....)
# 
# pokud je v oné inkriminované tabulce ještě cizí klíč, tak i tu.
# 

jenze tu uz nemuzu, to je tabulka uzivatelu s tisici rodnych cisel - to bych
radsi nikde neposilal.

ale asi vim, kde je problem:

SQL: select * from NLS_DATABASE_PARAMETERS          
PARAMETER              |VALUE
-----------------------+------------------------------
NLS_LANGUAGE           |AMERICAN
NLS_TERRITORY          |AMERICA
NLS_CURRENCY           |$
NLS_ISO_CURRENCY       |AMERICA
NLS_NUMERIC_CHARACTERS |.,
NLS_CHARACTERSET       |US7ASCII
NLS_CALENDAR           |GREGORIAN
NLS_DATE_FORMAT        |DD-MON-YY
NLS_DATE_LANGUAGE      |AMERICAN
NLS_SORT               |BINARY
NLS_TIME_FORMAT        |HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT   |DD-MON-YY HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT     |HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT|DD-MON-YY HH.MI.SSXFF AM TZH:T
NLS_DUAL_CURRENCY      |$
NLS_COMP               |NULL
NLS_NCHAR_CHARACTERSET |US7ASCII
NLS_RDBMS_VERSION      |8.1.5.0.0

Otazkou je, jak zmenit to NLS_*

alter session set nls_characterset=EE8ISO8859P2  

skonci:

S1000 ORA-00922: chybejici nebo chybna volba (DBD ERROR: OCIStmtExecute)

--milan


Další informace o konferenci Test