Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: /dev/null for Oracle?
Please, insert some rows and then
select sysdate from dual;
:)
jan
Peter Connolly <peter_at_wpi.edu> wrote in message
news:Pine.OSF.4.21.0005221117110.23350-100000_at_wpi.WPI.EDU...
> 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
![]() |
![]() |