| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> strange data format error: ora-01821
hi, list friends:
I have a oracle 8.1.7.4 database in redhat linux 7.2,which is used to support a development datawarehouse project.Now i hit some strange error message about date format through dblink The error only appear in oracle warehouse builder, it cannot be reproduced in sqlplus with the same statement.Query like: select 1 from dual_at_dblink, and it give out error message of ora-1821.If i mannually create the dblink and do the query, it is ok in sql*Plus, and if i try to use the dblink in oracle warehouse builder, it still give out error.I am not familier with warehouse builder.So i refer to this mailing list for help. I also tried set event like: alter system set events ' 1821 trace name errorstack level 5'
Starting up ORACLE RDBMS Version: 8.1.7.4.0. System parameters with non-default values:
processes = 150 timed_statistics = TRUE event = 1821 trace name errorstack level 5 shared_pool_size = 81943040 and there is trace file like:
Node name: dwdb Release: 2.4.7-10 Version: #1 Thu Sep 6 17:27:27 EDT 2001 Machine: i686
Some additional information :
bash_profile:
ORACLE_SID=back
ORACLE_HOME=/oracle/8.1.7
export ORACLE_HOME
ORA_NLS=$ORACLE_HOME/ocommon/nls/admin/data
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORA_NLS33
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:/home/oracle/product/webcache/webcache/bin
EDITOR=vi
NLS_LANG=american_america.ZHS16CGB231280
export ORACLE_SID ORACLE_HOME ORA_NLS LD_LIBRARY_PATH EDITOR PATH NLS_LANG
NLS_DATE_FORMAT="YYYYMMDD hh24:mi:ss"
export NLS_DATE_FORMAT
initsid.ora file:
////////
db_name = "back"
instance_name = back
service_names = back
control_files = ("/oracle/8.1.7/oradata/back/control01.ctl", "/oracle/8.1.7/oradata/back/control02.ctl", "/oracle/8.1.7/oradata/back/control03.ctl")
open_cursors = 300
open_links = 20
parallel_max_servers = 2
timed_statistics = true
event = "1821 trace name errorstack level 5"
/////////////////////////////
NAME VALUE$ COMMENT$
---------------------------------------- ------------------------------ ------------------------------
DICT.BASE 2 dictionary base tables version # DBTIMEZONE 0:00 DB time zone NLS_LANGUAGE AMERICAN Language NLS_TERRITORY AMERICA Territory NLS_CURRENCY $ Local currency NLS_ISO_CURRENCY AMERICA ISO currency NLS_NUMERIC_CHARACTERS ., Numeric characters NLS_CHARACTERSET ZHS16CGB231280 Character set NLS_CALENDAR GREGORIAN Calendar system NAME VALUE$ COMMENT$
---------------------------------------- ------------------------------ ------------------------------
NLS_DATE_FORMAT DD-MON-RR Date format NLS_DATE_LANGUAGE AMERICAN Date language NLS_SORT BINARY Linguistic definition NLS_TIME_FORMAT HH.MI.SSXFF AM Time format NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM Time stamp format NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM Time with timezone format NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:T Timestamp with timezone format ZM NLS_DUAL_CURRENCY $ Dual currency symbol NLS_COMP BINARY NLS comparison NAME VALUE$ COMMENT$
---------------------------------------- ------------------------------ ------------------------------
NLS_NCHAR_CHARACTERSET ZHS16CGB231280 NCHAR Character set GLOBAL_DB_NAME BACK Global database name EXPORT_VIEWS_VERSION 8 Export views revision # NLS_RDBMS_VERSION 8.1.7.4.0 RDBMS version for NLS paramete rs ///////////////////////////////////////////// Thanks for your help:)
>Eric > set long 2000 > select text from user_views where view_name = 'MYVIEW'; > >There are probably more elegant methods, but this works. > >Dennis Williams >DBA >Lifetouch, Inc. >dwilliams_at_lifetouch.com > > >-----Original Message----- >Sent: Tuesday, August 27, 2002 4:49 PM >To: Multiple recipients of list ORACLE-L > > >I did an import into a database and have one view that is invalid. How can >I >get the definition for the view out of database so that I can drop it and >recreate it? > >Might there be any issues with just dropping and recreating it? How do >other >people handle this when then import goes well except for one view being >invalid? > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Eric Richmon > INET: cemail2_at_sprintmail.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). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: DENNIS WILLIAMS > INET: DWILLIAMS_at_LIFETOUCH.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).
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡zhu chao ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡chaospku_at_163.net ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡2002-08-28
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zhu chao INET: chaospku_at_163.net 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).Received on Wed Aug 28 2002 - 03:28:18 CDT
 |
 |