Archives of the TeradataForum
Message Posted: Tue, 26 Feb 2002 @ 12:28:55 GMT
You will not be able to drop a database if there is a default journal table associated with that database and this is the reason for your error.
For removing a Journal table from your database try this:
Modify database xxx as
However, you still will not be able to drop a journal table from your database if some of your existing tables in the database are using journalling option. For this you should use:
ALTER TABLE NAME,WITH [JOURNAL TABLE=JOURNAL TABLE NAME]; ,NO BEFORE JOURNAL,NO AFTER JOURNAL;
Hope it helps..
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|