RE: Help with import 8.1.5 - coredump

I believe this is a bug. I have run into it several times, just never has time to pursue it. It has to do with the tables clause. You take it out. The core goes away. Put it back in, it comes back.. Take a look on metalink..

Shawn M Ferris
Oracle DBA - Time Warner Telecom

> -----Original Message-----
> From: Ruiz, Mary A (CAP, CDI) [mailto:Mary.Ruiz_at_gecapital.com]
> Sent: Monday, November 20, 2000 1:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Help with import 8.1.5 - coredump
>
>
> Hi, list, please help me. I have an 8.1.5 database on Sun
> Solaris 2.6
> I took a full export this past weekend - Here is my control file
> BUFFER=81920
> FILE=/u01/home/dba/oracle/admin/sf01/exp/sf01_pipe
> LOG=/u01/home/dba/oracle/admin/sf01/exp/sf01_exp.log
> USERID=system/systempasswd
> FULL=Y
> COMPRESS=N
>
> It is one of those compressed through a pipe exports. I
> need to recover
> one table.
> mknod cp_pipe p
> uncompress < exp_sf01.dmp.Z > cp_pipe &
> imp system/systempasswd_at_dev21 fromuser=cp
> tables=cr_limit_decr file=cp_pipe
> ignore=y
>
> Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 -
> Production
> With the Partitioning and Java options
> PL/SQL Release 8.1.5.0.0 - Production
>
> Export file created by EXPORT:V08.01.05 via conventional path
> import done in US7ASCII character set and US7ASCII NCHAR character set
> . importing CP's objects into CPSegmentation Fault(coredump)
>
> Has anyone found a way to work around this problem in 8.1.5 ?
> Is there a
> patch for the imp utility to overcome this error ?
> I have logged a tar and am waiting for the phone to ring.
>
> Thanks in advance,
> Mary Ruiz / Atlanta GA
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruiz, Mary A (CAP, CDI)
> INET: Mary.Ruiz_at_gecapital.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).
Received on Mon Nov 20 2000 - 14:59:23 CST