The following CREATE DATABASE command creates a clone of a database snowmy_db i.e.
Create database pods_db clone snowmy_db before (statement = '7e5d0cb9-005e-94e6-b058-k8f5b37c5725'); What are possible reason of failing cloning operation for this database?

Question

The following CREATE DATABASE command creates a clone of a database snowmy_db i.e.

Create database pods_db clone snowmy_db before (statement => '7e5d0cb9-005e-94e6-b058-k8f5b37c5725'); What are possible reason of failing cloning operation for this database?

Roger Warner · Accepted Answer

Time Travel Statement query time is beyond the retention time of few current child (e.g., a table) of the Database entity.

Roger Warner · Accepted Answer

Time Travel Statement query time is at or before the point in time when the object was created.

Roger Warner · Answer

CREATE DATABASE query fails due to compilation error as it do not support state-ment keyword.

Roger Warner · Answer

SQL Compilation error: "Incorrect Syntax 'before' while creating database"

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 109 - DEA-C01 discussion

Suggested answer: A, B

0 comments