One table was dropped (by mistake), so we resotored the needed datafile, control files, redo logs (from a cold backup) to development machine. Took all the not-needed datafiles offline, renamed the restored file to the new location. And bingo, we had a new database, with that table data as of the cold backup.
NOW, here is the question:
With the database having only limited number of datafiles online, is it possible to apply the archieve logs to a certain point in time ?? I don't think so, since all the peices are in sync (and Oracle does not need to recover)- but I thought to check with the GURUs of dbasupport.com !
There is something called Tablespace Point in Time Recovery which allow you to recover a tablespace to a time different to other tablespaces in the database, the process is pretty long, check the documentation