6. Loading and Unloading Databases : Copy Operation : Copy a Database to Another Instance
 
Share this page                  
Copy a Database to Another Instance
When copying a database, you can direct where the data is copied to and from by specifying a destination directory and a source directory. The directories can be on the same machine or different machines.
When you run the copy.out script, the data files are generated in the destination directory. If you have specified a source directory, you must move the copy.in script and the data files to this directory. When you run the copy.in script, the user objects are created and the tables are populated with the data from the source directory.
In VDBA, use the Destination Directory and/or Source Directory options specified in the Generate copy.in and copy.out dialog.