DBCopiers use vendor-specific bulk copy and SQL utilities for speed, rather than using JDBC. Therefore, to use a DBCopier, the native SQL environment for the database in question must be set up before starting Dynamo. This is required by the vendor tools in the database software. To use a DBCopier, you must set up the environment in which the JVM runs as specified in the database vendor documentation. You can add this environment information to your environment.sh or environment.bat file. For information about the settings for your database, see the documentation from your database vendor.
For example, for Oracle you should set your environment up to look something like this:
ORACLE_HOME=/oracle-directory
PATH=$PATH:$ORACLE_HOME/bin
ORACLE_SID=ora8
