Re: Importing an export file

Jason,

Make sure you have set you $ORACLE_HOME and $ORACLE_SID enviroment variables.

Followed by setting
. /usr/local/bin/oraenv or where ever oraenv is located on your machine.

Cheers,

Roger

"Jason Ahrens" <ahrensj_at_psi.ca> wrote in message news:39469463.C8CAB096_at_psi.ca...
> 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 Wed Jun 14 2000 - 00:00:00 CDT