Skip to content

Month: September 2010

Downloading Files

Copying from Windows to a network share:
From a command prompt use the following command:  COPY <source file> <destination location> /B /Z
Be sure to use COPY, not XCOPY.  I’ve yet to get xcopy to restart.  The /Z will allow you to re-issue the command if it gets interrupted.  When you do this, you will be asked if you want to over write the existing file.  Say yes, and it will pick up where it left off.  I’ve copied several 4GB files in this manner and either dropped the VPN connection or interrupted the transfer using Ctrl-C.  Every file eventually completed successfully and produced the same CRC32 values as the original.  I like to use hashcalc for compute CRC32 values of the file before and after I copy it.  This verifies the integrity of the file.  Be sure to run hashcalc local to the file.

Oracle Export/Import Utility

These tools are used to transfer data from one oracle database to another oracle database. You Export tool to export data from source database, and Import tool to load data into the target database. When you export tables from source database export tool will extracts the tables and puts it into the dump file. This dump file is transferred to the target database. At the target database the Import tool will copy the data from dump file to the target database.