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).
