Skip to Main Content

Oracle Database Discussions

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!

ORA-08103 - object no longer exists

669004Nov 6 2008
Will I be able to read from Partition A of Table A while Partition B of Table A is getting truncated?


Otherwise, can the following sqls 1 and 2

1 select * from table A where partition_id = 1 (partition_id is the partition key and the table is list partitioned from part_1 to part_10)
2 alter table A truncate partition part_2 reuse storage update global indexes

run at the same time?


Thanks,
Shan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 4 2008
Added on Nov 6 2008
0 comments
207 views