Any ideas as to how we can re-create a tablespace on a different server?
We have a cold backup, so we can copy the datafiles to the target server. Can we just create a new instance on the target server with the same tablespace name and the same path structure and plug-in the original datafiles?
Just a bit more background, we just want to get a table back from cold backup without restoring the whole database, so we were looking to restore the tablespace's files into a dummy database, then exporting the table were after.
Unfortunately it is an old version of Oracle - 22.214.171.124 and we don't use RMAN. Any info would be appreciated.