What is the result of executing a TRUNCATE TABLE comman…

What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving
enabled?

What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving
enabled?

A.
It fails with the ORA-665610 Invalid DDL statement on history-tracked message

B.
The rows in the table are truncated without being archived.

C.
The rows in the table are archived, and then truncated.

D.
The rows in both the table and the archive are truncated.

Explanation:
http://surachartopun.com/2010/06/ddl-on-tables-enabled-for-flashback.html

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

mhassan

mhassan

C.

Prior to 11gR2, this statement would fail.

Reply