Rao_S
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you..!!!
ASKER
attached the corrected file... change-this-query.txt