469,344 Members | 5,548 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,344 developers. It's quick & easy.

Query too long

Hello everyone,

I'm having some troubles displying this query in SQL Developer.I have 3 tables:
MASTER_TRANSACTION_HIST is a big table with millions of rows
LOCAL and PLAFOND are small cardinality tables.

select mt.LOCAL_ID, plf.SUBAGENT_ID, l.DESCRIPTION, to_char(min(mt.DATE_TRANS), 'dd-mm-yyyy')

from ADM.MASTER_TRANSACTION_HIST mt, ADM.LOCAL l, ADM.PLAFOND plf

where mt.LOCAL_ID = l.LOCAL_ID

and mt.APPLICATION = 'ARPA'

and mt.PLAFOND_ID = plf.PLF_ID

and mt.DATE_TRANS >= to_date('01-01-2007','dd-mm-yyyy') and mt.DATE_TRANS < to_date('04-06-2008','dd-mm-yyyy')

and plf.SUBAGENT_ID like '____3__' OR plf.SUBAGENT_ID like '____4__'

group by mt.DATE_TRANS, mt.LOCAL_ID, plf.SUBAGENTE_ID, l.DESCRIPTION


This query is taking too much time and giving me an IO error of no space left on device. I presume its too much data for him. Am i doing anything wrong ?

thank you
Jun 4 '08 #1
3 1612
r035198x
13,262 8TB
What's the exact error message that you get?
You probably just need to create an additional datafile for one of the tablespaces.
Jun 4 '08 #2
What's the exact error message that you get?
You probably just need to create an additional datafile for one of the tablespaces.
Exactly. Problem is solved... thanks a lot.
Jun 4 '08 #3
r035198x
13,262 8TB
Exactly. Problem is solved... thanks a lot.
Welcome. I find that the error message is usually a complete give away.
A more permanent solution to your problem is to define the dbf file such that it automatically extends when full and not limit it's size. Then you only get that error when the hard drive/partition itself is full.

Or better yet, switch to ASM.
Jun 4 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Harvey | last post: by
4 posts views Thread by Bob Bedford | last post: by
4 posts views Thread by Kory | last post: by
3 posts views Thread by annecarterfredi | last post: by
9 posts views Thread by Sinner | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.