Hi,
I was wondering if there is a way to determine the tablespace id of
each tablespace on a backup image. I want to perform a redirected
restore pointing the tablespace containers to different locations
than the ones defined on the backup image.
While I haven't tried it yet I imagine that I could perform a
redirected restore of just the catalog table space and then look at
the catalog table info to determine the tablespaces.
1) Will the solution I detail above work
2) Is there another way to determine this information assuming that
I do not have the original system from which the backup was created
Thanks in advance
Lew