Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: update sys tables sets idiot flag?
Group,
Interesting.
Recognize both, agree with previous postings.
Also, I often delete from sys.user_history$ to allow users to re-use passwords
Keep adding...
nb: still ppl out there modifying sql.bsq to prevent fragmentation ?
<mike_st0ne_at_my-deja.com> wrote in message
news:95p1i1$3iv$1_at_nnrp1.deja.com...
> 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 SYS-
> owned 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 - 13:48:23 CST