Thanks for your reply.

I can't effort export/import utility becuse it's a datawarehouse application. However, problem has been solved.

Actually the tablesapces I mentioned are different application databases(logically separated by tablespaces) reside in one physical database (one instance). Client some time need to restore one application on certain back date. Now, we are going to have one more identical database which will be used for restore purpose only. No need any restore operation on production database.

I appreciate your views.

Regards,

abhijit