6. Loading and Unloading Databases : Copying Individual Database Objects : How to Copy a Database Object
 
Share this page                  
How to Copy a Database Object
Follow these basic steps to copy a database object:
1. Check for duplicate objects, as described in Prepare to Copy a Database Object.
2. Log in as the DBA of the old database or as a privileged user who can impersonate the DBA (by using the -u flag for commands or by using the Users branch in the Virtual Nodes window in VDBA).
3. Use the relevant copy method to copy the object out of the database into an intermediate file.
4. Set the protections on the file copy.in or intermediate file and the data files so that you can access them after you log in as the DBA of the new database.
5. Log in as the DBA of the new database.
6. Using the relevant copy method in input mode, copy the intermediate file into the new database.
There are now two copies of the object, one in each database.
7. To remove the original object, the DBA or privileged user must use the applicable Ingres tool as the original owner (by using the -u flag for commands or by using the Users branch in the Virtual Nodes window in VDBA) and delete the copy of the object.