How to export and import the schema from one user to another ?
Here I'm going to explain how to use impdp/expdp utility to import schema and export it to another user.
Create a directory object in database that point to a physical location on the Operating system where dumps,log etc are going to store.
This directory object is only a pointer to a physical directory, it will not create any directory.
You can view all the directories with the help of DBA_DIRECTORIES view.
Those users who are going to use these utility must have READ,WRITE permission to this directory object.
Here we first try to export a schema of user TEST using the following expdp command.
Now we try to import this schema to different user. There is no need of creating another user, it will automatically create the new user.
Finally, you need to unlock the user and set the password for them.