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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie question: How to check for a tables existence in a smart (fast) way ??

Re: Newbie question: How to check for a tables existence in a smart (fast) way ??

From: Rasmus Langaard jr. <rasmus.langaard_at_nsa.no>
Date: 1998/01/09
Message-ID: <MPG.f2039318a76dd43989689@news.online.no>#1/1

In article <6935n9$nrp_at_info.telenor.no>, jorgen.hauikland_at_fou.telenor.no says...
> Hey !
>
> I'm working on an application and need to create some tables if they don't
> already exists - sometimes they do. I've tried to find a smart SQL statement
> but i end up with something that lists smaller or larger parts of the table.
> This is no good solution because this table can occasionally be quite large
> (50 - 60 MB). I need a statement that don't do any searching in the table,
> just sees if it's there.
>
> Any suggestions ??
>
> Private e-mails are welcome as long as they also are submitted to the group.
>
> Joergen Haukland
> NORWAY
>
> e-mail: jorgen.haukland_at_fou.telenor.no
>
>
>

Hei Jørgen!

Sjekk om ditt TABLE_NAME finnes i USER_TABLES - evt. sjekk som SYSTEM i DBA_TABLES. Lykke til! - rasmus Received on Fri Jan 09 1998 - 00:00:00 CST

Original text of this message

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