Re: update sys tables sets idiot flag?

But there's never been a rule that didn't have exceptions!

Two that I can think of:

1. You have auditing enabled, and you want to clear down AUD$ - nothing wrong with issuing "truncate table AUD$" . Admittedly, AUD$ isn't part of the data dictionary, but it is a SYSowned table.
2. You want to change the global name of your database, but you can't because it currently hasn't got a suffix (like e.g. ".WORLD"), and as a result "ALTER DATABASE RENAME GLOBAL_NAME TO <NEWNAME.SUFFIX>" isn't working. The only available workaround is to issue

update sys.props$
set value$='<NEWNAME.SUFFIX>' where name='GLOBAL_DB_NAME';

Can anyone add to this list?

Mike S

Sent via Deja.com
http://www.deja.com/ Received on Tue Feb 06 2001 - 08:26:19 CST