I need to import Oracle Database from production to development for just one schema. What is the easiest way to do this? I did this to remove the user using this scheme and recreate the user with the same parameters and run the import command. Is it correct?
I am using Oracle 10g and I am not a DBA developer, but my DBA gives me a dump file and I need to create a local test environment.
Do I need to abandon the user? Can I just delete all objects for this user?
source
share