Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Importing an export file

Importing an export file

From: Jason Ahrens <ahrensj_at_psi.ca>
Date: 2000/06/13
Message-ID: <39469463.C8CAB096@psi.ca>#1/1

I am attempting to do an import through a named pipe. The reason for the pipe is the export file is greater than 2GB and so is compressed.

Oracle version is 7.3.3, OS is Solaris 2.6. A transcript of the failing session follows. Various portions of the imp command have been removed for transmission.

falcon:/tmp$ uname -imsr
SunOS 5.6 sun4u SUNW,Ultra-2
falcon:/tmp$ id
uid=1002(oracle) gid=102(dba)
falcon:/tmp$ mknod pipe p
falcon:/tmp$ ls -l pipe
prw-r--r-- 1 oracle dba 0 Jun 13 15:39 pipe falcon:/tmp$ gunzip -c /vol2/CIMS_full.exp.gz > pipe & [1] 20791
falcon:/tmp$ /vol1/oracle/product/7.3.3/bin/imp ******/****** file=/tmp/pipe tables=****** fromuser=****** touser=****** COMMIT=Y INDEXES=Y GRANTS=N BUFFER=81920
Message 100 not found; No message file for product=RDBMS, facility=IMP: Release 7.3.3.0.0 - Production on Tue Jun 13 15:42:46 2000 Copyright (c) Oracle Corporatio
IMP-00003: Message 3 not found; No message file for product=RDBMS, facility=IMP
Error while trying to retrieve text for error ORA-12545 IMP-00021: Message 21 not found; No message file for product=RDBMS, facility=IMP
IMP-00000: Message 0 not found; No message file for product=RDBMS, facility=IMP

If anyone knows what may be wrong, I would greatly appreciate a reply.

Thanks Received on Tue Jun 13 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US