Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Importing an export file
>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
>
>
>
I'm fairly certain that if you don't specify a fix suffix in your file=
parameter in UNIX, then the imp command adds .dmp, hence in your case it would
be looking for /tmp/pipe.dmp.
HTH,
Rob
Received on Tue Jun 13 2000 - 00:00:00 CDT