7. Changing Ownership of Databases and Database Objects : Changing Ownership of a Database Object : How to Change Ownership of Tables
 
Share this page                  
How to Change Ownership of Tables
Follow these steps to change the ownership of a table:
1. Generate the executable scripts.
2. Execute the copy.out script, copying the table as the current owner.
3. Execute the copy.in script, copying the table back in as the new owner.
These tasks can be accomplished using the copydb and sql commands.
For details on performing these steps in VDBA, see online help.
For more information on copying tables and other database objects, see the chapter “Loading and Unloading Databases.”