Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select rows from a partition

591942Jul 16 2008 — edited Jul 16 2008
Hi All,

I have a table D_POSITION with partition created on record_date, key1 with Range-hash partition.

Previously I use to get the data by following this query.

SELECT * FROM D_POSITION PARTITION (P_20080331)

Recently I truncated the table and reinserted from the backup table.

Now this is giving me the 0 records. But for this partition we have more than 60000 records.

Please let me know where it went wrong....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 13 2008
Added on Jul 16 2008
3 comments
9,167 views