I have a varchar2 column in a table, which contains binary data. We chose varchar2's columns based on how the RDBMS stores values for varchars as opposed to blobs. At least historically, blobs were stored separately and I was concerned about access times especially in light of the fact that we use select *. In addition, to
change varchar2 to blobs or raws at this point is not worth the development time.

Now we are porting our application to Oracle 10G I want to verify if RMAN can restore a table that has binary data in a varchar2 column without any data translation. So what I tried doing is placing one table that has varchar2 column with binary data into its own tablespace.

I backed up the tablespace using RMAN.

I went into SQLPLUS and dropped the tablespace including contents

I tried restoring the tablespace via RMAN and I was not succesful.

My database is in archive mode but I know I missing some step/(s) on the restoration side. That is where I need a bit of assitance.
Any help and exact syntax would be appreciated.

Thanks in advance to all who answer this post