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