6. Loading and Unloading Databases : Copy Operation : Locking While Copying a Database : Lock Database Exclusively When Copying
 
Share this page                  
Lock Database Exclusively When Copying
Locking ensures the consistency of the tables being copied.
To lock tables exclusively when copying them, use the sql command with -l flag when you run the copy.out script, as follows:
sql -l dbname <copy.out