Here, two databases are copied that have different fallback attributes:
COPY DATA TABLE (Personnel) (FROM (OldPersonnel), NO FALLBACK) ,(Finance) (NO JOURNAL) ,FILE = ARCHIVE;
In the example:
- The database named Personnel is restored from an archived database named OldPersonnel with all tables defined as nonfallback after the copy operation.
- The database named Finance is restored from an archived database also named Finance with all journaling associated with its data tables disabled.