Duplicate Oracle Schema

Using imp/exp:
Export the database using:

exp 'system/password' owner=schema_to_be_duplicated file=filename.dmp log=logfile.log

Then import the dump file into the target schema:

imp 'system/password' fromuser=schem_to_be_duplicated touser=target_username file=
filename.dmp

But keep in mind that the target schema must be available on the database. If it does not, then you must have to create it first using CREATE USER command). The import does not create user for you it only migrates objects & data within schemas.

Using impdp/expdp:

We must first create a directory object you can access. The directory object is only a pointer to a physical directory, creating it does not actually create the physical directory on the file system.

sqlplus / AS SYSDBACREATE OR REPLACE DIRECTORY DUMP_DIR AS '/home/oracle/dumpdir/';

Export with:

expdp schema_to_be_duplicated/password DUMPFILE=filename.dmp DIRECTORY=dmpdir

Import with:

impdp REMAP_SCHEMA=schema_to_be_duplicated:new_schema DUMPFILE=filename.dmp DIRECTORY=dmpdir EXCLUDE=JOB

you will be asked for a username and password, the default is system/system

Remember that you must first create the destination user:

CREATE USER new_schema IDENTIFIED BY new_password DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON users;
GRANT CREATE session, CREATE table, CREATE view, CREATE procedure, CREATE synonym, CREATE SEQUENCE, CREATE TRIGGER, CREATE TYPE, CREATE MATERIALIZED VIEW, CREATE DATABASE LINK,Debug Any Procedure,Debug Connect Session TO new_schema;
ALTER USER new_schema QUOTA UNLIMITED ON USERS;