Is it possible that during the restore database redirect command, change the SMS tablespaces to DMS?
I have a situation where I have a backup image of database which has all the tablespaces as SMS. I need to create a copy of this same database BUT change some of the SMS tablespaces to DMS for some testing purposes. Is it possible to achieve with restore command? If not what other way can be used except creating a brand new database and then import/export of data?
Yes, thats what I concluded from the documentation as well. Another thing I found is that Quest central for database tool by Quest has the capability to do this in their alter tablespace screen. On the background it does export, drop tables, create tablespace and import the data back. One can do it manually as well. But using the tool, it's just easy and it takes care of dependcies.
Originally posted by sathyaram_s
Restore Command cannot do this