Re: Transfering database from VMS machine to a SPARC 10 workstation

In article <30AUG94.17084199_at_tigris.cti.gr>, tsiutsiu_at_tigris.cti.gr writes:
> Hi,
> we have an Oracle v6.0.34 database and Forms v3.0.16 on a VAX/VMS
> machine running OpenVMS ver. 5.5-2 and an Oracle v6.0.36 database with
> Forms v3.0.16 on a SPARC 10 workstation running Solaris 1.1 .
> We intend to transfer the database from the VMS machine to the
> SPARC 10 workstation.
> Is anyone familiar with that? We wonder what kind of problems might
> occur and whether there is anything that we should take care of, first.
> Any help would be appreciated.
> Thanks in advance.
>
> ----
>
> email address: tsiutsiu_at_cti.gr
>

I have never moved an entire database from VMS to Solaris, but we have moved a number of applications and their data. I would expect that a full export of the database would work well. When you FTP the file over to the sun, make sure that you set your mode to binary. Make sure that you create all the tablespaces before you attempt to do the full import. Unix won't like the VMS file specifications currently in dba_data_files.

-- 
Bob Swisshelm                | swisshelm_at_Lilly.com     | 317 276 5472
Eli Lilly and Company        | Lilly Corporate Center  | Indianapolis, IN 46285