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!

Restore dropped partition

617730Oct 9 2008 — edited Oct 10 2008

Good day.
Would you please advise me on my problem.
I'm working with 10.1.0.3 version.
I have a partitioned table. Each partitinos is located in it's own tablespace. Most partition tablespaces are in read only state. A couple of partitions (read onle ones) have been dropped by mistake (alter table drop partition). Is there any possibility to restore the table to "before partitions were dropped" state without full database recovery? I do have a full cold backup and all archivelogs.
Thanks in advance.

Edited by: Mashuka on Oct 9, 2008 1:43 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 7 2008

Added on Oct 9 2008

#general-database-discussions

5 comments

3,961 views