Selective Backup and Restore Rules
When performing a selective backup and restore on a table or database, the following rules must be met in order for the operation to be successful.
|
Type |
Restore Same Database |
Copy Same Database |
Copy and Rename |
Copy Different Database |
Copy and Rename |
|||||
|
|
DB Level |
Object Level |
DB Level |
Object Level |
DB Level |
Object Level |
DB Level |
Object Level |
DB Level |
Object Level |
|
Aggregate Function |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
No |
No |
|
JAR |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
No |
No |
|
External Stored Procedures |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
No |
No |
|
Standard Function |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
No |
No |
|
Trigger |
Yes |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
|
Instance or Constructor Method |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
|
Join Index |
Yes |
Yes |
Yes |
Yes |
No |
No |
Yes |
Yes |
No |
No |
|
Macro |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
No |
|
Hash Index |
Yes |
Yes |
Yes |
Yes |
No |
No |
Yes |
Yes |
No |
No |
|
Stored Procedure |
Yes |
Yes |
Yes |
Yes |
No |
No |
Yes |
Yes |
No |
No |
|
Queue Table |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Table Function |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
Yes |
|
Table |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
PPI Table |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
NoPI and Column-partitioned Table |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
UDT |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
|
View |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
No |
|
Authorization |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
No |