I want to make use of the RMAN utility, available with the oracle 8i. I have installed 2 databases(prod and catdb). The initial steps of connecting to RMAN, registering db etc are complete.

I wanted to create and resolve this scenerio

1) Create a table (A) on tablespace (TSA), populate it.
2) Take the rman tablespace backup(TSA).
3) Drop the table(A)

Now, I want to get back the table(A) from the rman backup.

How can I get it back;

Steps will be very useful.