A COPY statement allows the creation of objects and giving them different names. In database-level copy operations, the statement allows copying to a database with a different name.
To use the COPY statement, these conditions must be met:
- Restore access privileges on the target database or table are required.
- A target database must exist to copy a database or an individual object.
- When copying a single table that does not exist on the target system, you must have CREATE TABLE and RESTORE database access privileges for the target database.
- If the archived database contains a journal table that needs to be copied, the target database must also have a journal table.