Hi, Upload your ORA-7445 trace file by using iOraBugFinder. regards... "Nguyen, Long (ITS, Limestone Ave)" wrote: > Hi, > > A friend of mine ran an export and got segmentation fault. It seems to be a bug with >8.1.6 on Solaris 5.8 and relates to character sets. Below is the info supplied by >him. Anyone has experienced the same problem or could give a suggestion > what to try? I searched Metalink and could not find any references to this problem. > > Thanks > > > > > The database was created with charset and ncharset both set to > > WE8ISO8859P1: > > > > select * from NLS_DATABASE_PARAMETERS > > > > 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 TZH:TZM > > NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM > > NLS_DUAL_CURRENCY $ > > NLS_COMP BINARY > > NLS_NCHAR_CHARACTERSET WE8ISO8859P1 > > NLS_RDBMS_VERSION 8.1.6.0.0 > > > > --- > > > > When exporting the largest table, IF the client has US7ASCII > > set as the nls charset, the export works fine: > > > > $ export NLS_LANG=American_America.US7ASCII > > $ exp > > Export: Release 8.1.6.0.0 - Production on Mon Jun 4 10:37:28 2001 > > (c) Copyright 1999 Oracle Corporation. All rights reserved. > > Username: aleg > > Password: > > Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - 64bit > > Production > > With the Partitioning option > > JServer Release 8.1.6.0.0 - Production > > Enter array fetch buffer size: 4096 > 25600000 > > Export file: expdat.dmp > /tmp/x.dmp > > (2)U(sers), or (3)T(ables): (2)U > 3 > > Export table data (yes/no): yes > > > Compress extents (yes/no): yes > > > Export done in US7ASCII character set and WE8ISO8859P1 NCHAR character > > set > > server uses WE8ISO8859P1 character set (possible charset conversion) > > About to export specified tables via Conventional Path ... > > Table(T) or Partition(T:P) to be exported: (RETURN to quit) > > topicrels > > > > . . exporting table TOPICRELS 4826389 rows > > exported > > Table(T) or Partition(T:P) to be exported: (RETURN to quit) > > > > > Export terminated successfully without warnings. > > > > --- > > > > Note the warning: "Export done in US7ASCII character set and > > WE8ISO8859P1 > > NCHAR character set server uses WE8ISO8859P1 character set (possible > > charset conversion)", which I guess we expect! > > > > ---- > > > > Now, if we set the client NLS_LANG to match the database, the export > > fails: > > > > $ export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 > > $ exp > > Export: Release 8.1.6.0.0 - Production on Mon Jun 4 10:41:38 2001 > > (c) Copyright 1999 Oracle Corporation. All rights reserved. > > Username: aleg > > Password: > > Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - 64bit > > Production > > With the Partitioning option > > JServer Release 8.1.6.0.0 - Production > > Enter array fetch buffer size: 4096 > 25600000 > > Export file: expdat.dmp > /tmp/x.dmp > > (2)U(sers), or (3)T(ables): (2)U > 3 > > Export table data (yes/no): yes > > > Compress extents (yes/no): yes > > > Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR > > character set > > About to export specified tables via Conventional Path ... > > Table(T) or Partition(T:P) to be exported: (RETURN to quit) > > topicrels > > > > . . exporting table TOPICRELS 4826389 rows > > exportedSegmen > > tation Fault > > > > -------- > > > > Other tables are exported just fine. The topicrels table looks like > > this: > > > > CREATE TABLE TOPICRELS ( > > FROMTID VARCHAR2 (5) NOT NULL, > > TRTYPE VARCHAR2 (2) NOT NULL, > > TOTID VARCHAR2 (5) NOT NULL, > > SEQ NUMBER (4) DEFAULT 0, > > UNCERTAIN CHAR (1)) > > TABLESPACE USERS NOLOGGING > > PCTFREE 1 PCTUSED 99 INITRANS 1 MAXTRANS 255 STORAGE ( > > INITIAL 77725696 NEXT 4571136 PCTINCREASE 1 MINEXTENTS 1 > > MAXEXTENTS 121 FREELISTS 1 FREELIST GROUPS 1 ) CACHE; > > > > It has 3 indices: > > > > CREATE INDEX TRFROMTOTYPE ON > > TOPICRELS(FROMTID, TOTID, TRTYPE) > > TABLESPACE INDX PCTFREE 1 STORAGE(INITIAL 151257088 NEXT 6160384 > > PCTINCREASE 0 ) > > ; > > > > CREATE INDEX TRFROMTYPESEQTOUNC ON > > TOPICRELS(FROMTID, TRTYPE, SEQ, TOTID, UNCERTAIN) > > TABLESPACE INDX PCTFREE 1 STORAGE(INITIAL 108134400 NEXT 6160384 > > PCTINCREASE 0 ) > > ; > > > > CREATE INDEX TRTOTYPEFROM ON > > TOPICRELS(TOTID, TRTYPE, FROMTID) > > TABLESPACE INDX PCTFREE 1 STORAGE(INITIAL 138936320 NEXT 6160384 > > PCTINCREASE 0 ) > > ; > > > > > > System info: > > > > oracle environment: > > > > NLS_LANG=American_America.US7ASCII > > ORACLE_BASE=/usr/local/oracle/app/oracle > > ORACLE_DOC=/usr/local/oracle/app/oracle/product/8.1.6/doc > > ORACLE_HOME=/usr/local/oracle/app/oracle/product/8.1.6 > > ORACLE_SID=ALEG > > > ORA_NLS33=/usr/local/oracle/app/oracle/product/8.1.6/ocommon/nls/admin/d > > ata > > > PATH=/usr/local/oracle/app/oracle/product/8.1.6/bin:/etc:/usr/ccs/bin:/u > > sr/local/ > > > bin:/usr/java/bin:/usr/bin:/usr/ucb:/etc:/usr/sbin:/usr/bin:/usr/ucb:/et > > c:/usr/dt > > /bin:/usr/sbin:/usr/ccs/bin:/usr/openwin/bin:/usr/local/bin:. > > > > $ uname -a > > SunOS aleg 5.8 Generic_111459-01 sun4u sparc SUNW,Sun-Blade-1000 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nguyen, Long (ITS, Limestone Ave) > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- Web: http://www.unal-bilisim.com ********* Questions and Answers: http://www.unal-bilisim.com/qa/discus/ ********* itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. ********* iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. ********* -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: export causes segmentation fault
Danisment Gazi Unal (Unal Bilisim) Tue, 05 Jun 2001 01:51:21 -0700
- export causes segmentation fault Nguyen, Long (ITS, Limestone Ave)
- Re: export causes segmentation fau... Danisment Gazi Unal (Unal Bilisim)
- Re: export causes segmentation fau... Suzy Vordos
- RE: export causes segmentation fau... Nguyen, Long (ITS, Limestone Ave)
