Solved

how to select data from a particular partition

Posted on 2008-06-26
2
7,688 Views
Last Modified: 2013-12-19
hi
i have a table with 5 partitions.

now i  want something like this.

select * from table_name (from partition 3).

how to do this ?
0
Comment
Question by:vishali_vishu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 21875355
simply like this:
select * from table_name partition(3)

Open in new window

0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 21875577
Angellll is correct, you simply include the keyword "partition" in your query, and you must use parentheses around the partition name.  You may optionally include a space between the word "partition" and the parenthesis like this:
select * from table_name partition (3)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
oracle DR - data guard failover. 18 74
format dd/mm/yyyy parameter 16 59
UTL_FILE invalid file operation 5 60
Convert summed columns to Rows 6 25
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question