yes what sreddy is said is right.
There is another alternate way i guess correct me if i am wrong.
Find out who are the users for that user1 tablespace.
Export those users
Where u have different database create those users and then import it back with the clause fromuser , touser
--pravin




Reply With Quote