SQL Language (MOSC)

MOSC Banner

How to avoid creation of view in remote DB?

edited Oct 7, 2015 10:03AM in SQL Language (MOSC) 1 commentAnswered

Hi,

I have a query like this:

SELECT
    Column_1,
    Column_2,
    Column_3,
    ... in total 463 columns
FROM SUMDB.F_CELLPI0_RNCCELL_DH@prs t1
    JOIN SUMDB.F_CELLPI1_RNCCELL_DH@prs t2 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID)
    JOIN SUMDB.F_CELLPI2_RNCCELL_DH@prs t3 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID)
    JOIN SUMDB.F_CELLPI3_RNCCELL_DH@prs t4 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID)
    JOIN SUMDB.F_CELLPI4_RNCCELL_DH@prs t5 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID)
    JOIN SUMDB.F_CELLPI5_RNCCELL_DH@prs t6 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID)
    JOIN SUMDB.F_CELLPI6_RNCCELL_DH@prs t7 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID)
    JOIN SUMDB.F_CELLPI7_RNCCELL_DH@prs t8 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID)
    JOIN SUMDB.F_TNN000005_RNCCELL_DH@prs t9 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID)
    JOIN SUMDB.F_TNN000009_RNCCELL_DH@prs t10 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID)
    JOIN SUMDB.F_TNN000043_RNCCELL_DH@prs t11 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID)
    JOIN SUMDB.F_TNN000144_RNCCELL_DH@prs t12 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID)
    LEFT OUTER JOIN SUMDB.F_NBCELLPI0_RNCCELL_DH@prs t13 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID)
    LEFT OUTER JOIN SUMDB.F_TNN000161_RNCCELL_DH@prs t14 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID)
WHERE STARTTIME = DATE '2015-09-24'
    AND RULEID = 100005;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center