Re: temporary tables
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Sat, 24 Jul 2010 09:53:16 +0200
Message-ID: <8avkflFa88U2_at_mid.individual.net>
On 23.07.2010 19:42, Ed Prochak wrote:
> On Jul 23, 9:52 am, Francogrex<fra..._at_grex.org> wrote:
>> I have access to a database as read-only (so, I cannot create tables,
>> insert or update values etc)... But I need to search a col with type
>> LONG and since this is not a possibility to search it in a when
>> clause, they suggested I try to convert it to CLOB first. Is there a
>> way that I create a "temporary table" (ex would reside only in PC
>> memory or a local DB on my PC) that is not in the read-only database
>> and do the work on that table (which will not commit anything and will
>> disappear upon closing the session)?
>
> I think you misunderstand Oracle Temporary tables. here's a quote from
> the concepts guide
Date: Sat, 24 Jul 2010 09:53:16 +0200
Message-ID: <8avkflFa88U2_at_mid.individual.net>
On 23.07.2010 19:42, Ed Prochak wrote:
> On Jul 23, 9:52 am, Francogrex<fra..._at_grex.org> wrote:
>> I have access to a database as read-only (so, I cannot create tables,
>> insert or update values etc)... But I need to search a col with type
>> LONG and since this is not a possibility to search it in a when
>> clause, they suggested I try to convert it to CLOB first. Is there a
>> way that I create a "temporary table" (ex would reside only in PC
>> memory or a local DB on my PC) that is not in the read-only database
>> and do the work on that table (which will not commit anything and will
>> disappear upon closing the session)?
>
> I think you misunderstand Oracle Temporary tables. here's a quote from
> the concepts guide
I think OP did not talk abut Oracle Temp tables but rather accidentally reused the term. It seems he rather wants some form of external index to search for. Materialized views come to mind. Alternatively, dump the whole table to a text file and search there. Feasibility of course depends on the size of the data set.
> So talk to your DBA about creating a temporary table for you. You may
> need some other things as well to search the CLOB. I suggest you talk
> to your DBA for help.
If the DBA is willing he could create a materialized view inside the original DB which then could be queried. That's probably the most efficient and robust solution.
Kind regards
robert
-- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/Received on Sat Jul 24 2010 - 02:53:16 CDT