Re: export causes segmentation fault

Try with COMPRESS=N and see if that makes a difference....

"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: Long.Nguyen_at_its.csiro.au
>
> 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: Suzy Vordos
  INET: lvordos_at_datsit.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).