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