Archives of the TeradataForum

Message Posted: Thu, 27 Dec 2012 @ 09:49:59 GMT

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

Since the journal is in another database in your example (DB_JOURNAL.JOURNAL_TBL), the MODIFY DATABASE A AS DROP DEFAULT JOURNAL TABLE; merely removes the "default" from database A and does not drop the journal. But since the journal is in a different database, you don't need to take any explicit action at all regarding the journal in order to be able to drop the database. Once you drop the objects it contains, you can drop database A.

You will get an error if you try to actually drop a journal table that is still active.

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