Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: /dev/null for Oracle?

Re: /dev/null for Oracle?

From: Jan Benjamins <j.benjamins_at_home.nl>
Date: 2000/05/22
Message-ID: <etfW4.15462$hs1.580280@news.rdc1.ov.nl.home.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US