Oracle rman SCN

Hi everybody,
I have a question connected with recovering data from oracle 9/10. elow is description and question. Please HELP. The question is a little teoretical but very important ;-) Please be patient for my mistake ;-) I am new to Oracle ;-|

Shortly my question is: It is possible recover only some part of the data from (archive log + redo)?
Exactly, I'd like to recover only some transactions without some others.

Full description below:

DB: oracle 10i and Oracle 9 (with ArchiveLog) Database has 3 tables: PERSON, SALES, ORDERS Below there are rows with all transactions (DATA/TIME OF TRANS/ SCN/ AND DESCRIPTION):

TIME  SCN	DESCRIPTION
11:00 1 	User adam did: INSERT INTO PERSON SOMEDATA
11:05 2 	User robert did: INSERT INTO PERSON SOMEDATA
11:05 3 	User anna did: Insert into ORDERS SOMEDATA

11:10 4 	DBA (or user) did: DROP TABLE ORDERS

11:11 5 	User adam did: INSERT INTO PERSON SOMEDATA
11:11 6 	User adam did: UPDATE PERSON SOMEDATA
11:11 7 	User roger did: INSERT INTO PERSON SOMEDATA
11:13 8 	User roger did: INSERT INTO SALES SOMEDATA

My question is: It is possible to recover ALL DATA without SCN number 4?

I think about syntax:

RECOVER UNTIL SCN=3;
RECOVER FROM SCN=5 TO SCN=8;
Is it possible?? How?

Please help,
Daniel Received on Mon Apr 09 2007 - 14:49:04 CDT