I would like to change Oracle user when I need to clone Oracle database by using SMO. Is it possible to do that? When I change Oracle user parameter in SMO cloning wizard and doing clone, I always got an error "control file could not be created". I also assigned user permission and owner to original Oracle path but the problem still exist. Please kindly give me an idea.
Thank you very much for your advise. I will check with my customer because they changed permission for me but I think they maybe miss no 3. What is the real world when other people clone Oracle database, do they use another user instead of original user? Because this is my customer requirement.