SEO

I am trying to import a dmp file from Unix to Windows. The file is
sized 1.6 gb. I have installed Oracle 8i (8.1.7) on Windows 2000. The
Oracle Home directory is d:\oracle\ora81.

I would like to:
- view the contents of the dmp file so I can see the table names /
schema
- import the dmp file into my Oracle db on my Windows 2000 server.
I have tried both the OEM Import Wizard and the command line IMP
utility but both are failing.

When attempting to read the .dmp file using the Import Wizard in
Oracle Enterprise Manager (OEM) I get an error:
"couldn't open "c:/winnt/temp/2824144632.log": no such file or
directory". This error also appears when I try to do an export.

I found a post which suggested creating a file called 'null.tcl' in
the \network\agent\tcl directory, but I think this fix was for an
earlier version of Oracle as this file already existed in my
ORACLE_HOME directory.

Additionally, if I try to import the file using the IMP command line
utility, I get an error saying 'abnormal end of export file'. I have
increased the buffer size & I'm verifying now that the file was FTP'd
in binary mode. The import rows option is turned off.

I hope someone can provide some pointers/tips to help me.

Thank you in advance.

Couple of things spring to mind;

- try show=y (see docs for more info, imp/exp are in the Utilities
manual IIRC)

- ensure it is not a direct path export as I believe these are not portable

- try copying the file back to the original system and use imp with
show=y to see if it is readable there (if you have a broken dump file
then no amount of magic will fix it)

KJP

jukia wrote:
> I am trying to import a dmp file from Unix to Windows. The file is
> sized 1.6 gb. I have installed Oracle 8i (8.1.7) on Windows 2000. The
> Oracle Home directory is d:\oracle\ora81.
>
> I would like to:
> - view the contents of the dmp file so I can see the table names /
> schema
> - import the dmp file into my Oracle db on my Windows 2000 server.
> I have tried both the OEM Import Wizard and the command line IMP
> utility but both are failing.
>
> When attempting to read the .dmp file using the Import Wizard in
> Oracle Enterprise Manager (OEM) I get an error:
> "couldn't open "c:/winnt/temp/2824144632.log": no such file or
> directory". This error also appears when I try to do an export.
>
> I found a post which suggested creating a file called 'null.tcl' in
> the \network\agent\tcl directory, but I think this fix was for an
> earlier version of Oracle as this file already existed in my
> ORACLE_HOME directory.
>
> Additionally, if I try to import the file using the IMP command line
> utility, I get an error saying 'abnormal end of export file'. I have
> increased the buffer size & I'm verifying now that the file was FTP'd
> in binary mode. The import rows option is turned off.
>
> I hope someone can provide some pointers/tips to help me.
>
> Thank you in advance.

Also be sure you used a BINARY copy of the dmp file when moved from the Unix system.


KevJohnP <nospam@nowhere.com> wrote:

>Couple of things spring to mind;
>
>- try show=y (see docs for more info, imp/exp are in the Utilities
>manual IIRC)
>
>- ensure it is not a direct path export as I believe these are not portable
>
>- try copying the file back to the original system and use imp with
>show=y to see if it is readable there (if you have a broken dump file
>then no amount of magic will fix it)
>
>KJP
>
>jukia wrote:
>> I am trying to import a dmp file from Unix to Windows. The file is
>> sized 1.6 gb. I have installed Oracle 8i (8.1.7) on Windows 2000. The
>> Oracle Home directory is d:\oracle\ora81.
>>
>> I would like to:
>> - view the contents of the dmp file so I can see the table names /
>> schema
>> - import the dmp file into my Oracle db on my Windows 2000 server.
>> I have tried both the OEM Import Wizard and the command line IMP
>> utility but both are failing.
>>
>> When attempting to read the .dmp file using the Import Wizard in
>> Oracle Enterprise Manager (OEM) I get an error:
>> "couldn't open "c:/winnt/temp/2824144632.log": no such file or
>> directory". This error also appears when I try to do an export.
>>
>> I found a post which suggested creating a file called 'null.tcl' in
>> the \network\agent\tcl directory, but I think this fix was for an
>> earlier version of Oracle as this file already existed in my
>> ORACLE_HOME directory.
>>
>> Additionally, if I try to import the file using the IMP command line
>> utility, I get an error saying 'abnormal end of export file'. I have
>> increased the buffer size & I'm verifying now that the file was FTP'd
>> in binary mode. The import rows option is turned off.
>>
>> I hope someone can provide some pointers/tips to help me.
>>
>> Thank you in advance.

Turkbear <john.g@dot.spamfree.com> wrote in message news:<242d805b35oljm43s9gp05grb2t82rs8nj@4ax.com>. ..
> Also be sure you used a BINARY copy of the dmp file when moved from the Unix system.
>
>

Also do a tail on the dmp file on unix (preferably the one you copied
back from W). You should see a couple of EXIT lines and probably some
CREATE TRIGGER commands.

jg
--
@home.com is bogus. Surf naked!
[The risk of the new Internet flaw was similar to Internet users]
"running naked through the jungle, which didn't matter until somebody
released some tigers." - Paul Vixie.