Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: /dev/null for Oracle?
You could create a view on top of the dual table.
Create view my_dev_null as
select dummy col1,
dummy col2...
from dual
This would allow you to delete the actual table and should give quick response.
HTH,
Peter
Lifetime Intern
On Mon, 22 May 2000, Peter Dickmann wrote:
> Hello,
>
> I want to get rid of a table which is filled (but never used) by an
> application I cannot change. How can I redirect the insert statements to
> '/dev/null' ? Would be an 'INSTEAD OF' trigger a solution?
>
> Thanx, Peter
>
>
>
Received on Mon May 22 2000 - 00:00:00 CDT