Re: REFERENCEing a system table

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Tue, 9 Aug 2005 09:58:13 +0800
Message-ID: <5e304862050808185836017c0b@mail.gmail.com>

You could try adding a DDL trigger at database level - if its a tablespace add/drop event, then add/delete row(s) from your own table.

hth
connor

> I just mentioned it in another message, but I thought it would be
> nice to ask if there is a way out -- until now I've been assumed it is
> just an arbitrary restriction coupled to an Oracle modelling defect and
> have let the issue to rest.
>

-- 
Connor McDonald
===========================
email: connor_mcdonald_at_yahoo.com
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 08 2005 - 21:00:16 CDT