Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle on UNIX
You did not say what the version of Oracle was on the unix machine. If the versions are not identical, which is probably the case, you must look at setting the COMPATIBLE parameter in the init.ora. If it was exported with a higher version number, I believe you will need to reexport with COMPATIBLE set to the target version number.
Ian wrote:
> I am trying to import a export dmp file that was taken from a UNIX machine,
> onto a NT machine with Oracle 7.3.
>
> I am getting back a message that the SQL statements are not valid.
>
> I think it is because the recordlength is not set correct - using the NT
> default value.
> Can anybody help with what recordlength I should set for the import, or how
> i can resolve this error.
>
> Thanks in advance
>
> Ian
Received on Sun Mar 08 1998 - 00:00:00 CST