Archives of the TeradataForum

Message Posted: Mon, 13 Sep 2004 @ 10:21:20 GMT

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

Narrayan

Dropping a Database/User would mean that the Database/User had no tables or other objects within it so you would simply recreate the database/user. If you have an Archive of the database/user then you could restore it from backup.

In regards to tables... Oooooo! You will need to recover the data from backup. I do not believe there is anyway to recovery from the Transient Journals... Those are used for rollback so if you were in the middle of the update/delete you could abort the request and the table would rollback.

If you have already completed the tasks in deleting the data, then you will need to recover from backup....

Best Regards

Chris Coffing
AFKS O&M Lead Teradata DBA
Certified Teradata Master

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