Need to change the query with out referring to partition...

we have a partition on a table called (INBOUND) and (OUTBOUND) - table is list partitioned ...
we have to drop the partition so have to have a alternate for the inbound_outbound_ind ....etc..
i have attached a file which shows a query... can you help me rewrite the query when the partition is dropped...... change-this-query.txt
Rao_SAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
>>FIRST_VALUE (inbound_seq_pk) OVER (PARTITION BY miss_object_id ORDER BY seq_nbr ASC)

This is NOT like table partitions and has nothing to do with them.  the 'partition by' clause of a data warehouse window function like FIRST_VALUE is the same as a 'group by' clause on a regular select.

It tells the function how to group the 'window'.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HainKurtSr. System AnalystCommented:
     (SELECT DISTINCT FIRST_VALUE (inbound_seq_pk) OVER (PARTITION BY miss_object_id ORDER BY seq_nbr ASC) /** i dont understand this line */

this means, group the records by miss_object_id, then order by seq_nbr ASC and get the first_value
0
HainKurtSr. System AnalystCommented:
also the query you posted is not complete, it requires "FROM someTable" clause...
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Rao_SAuthor Commented:
sorry about that...
attached the corrected file... change-this-query.txt
0
Christoffer SwanströmPartnerCommented:
The relevant part of the query is actually this:


UPDATE aqtit01.tqt_it_inbound_seq PARTITION(INBOUND)


Can you post the table definition (including the partitioning).

I think you will be able to replace the PARTIITON(INBOUND) by an additional WHERE clause that specifies the equivalent of the partition values for INBOUND.
0
Rao_SAuthor Commented:
thank you..!!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.