Archives of the TeradataForum

Message Posted: Tue, 23 Aug 2005 @ 11:34:17 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Ankit,

As per the Recovery Manager utility documentation:

You can reuse the table only when one of the following occurs:

* You drop the table and create it again.

* You restore the table from an archived backup.

* You perform a DELETE ALL operation on that table if you do not want to lose the DDL associated with the table. When you issue a DELETE ALL, the partially rolled back rows can be removed, and the table is made usable.

Hope this helps.

Pranav Sankar

	<Prev	Next>		<<First	<Prev	Next>	Last>>