exp & imp schema-one database to another database.
Dear experts,
I am using exp command for exporting the specific schema in orcl database, the command that I am using are below :-
exp userid=SHLULSPROD/SHLULSPROD@kastle file=/backup/SHL/SHLULSPROD.dmp log=/backup/SHL/SHLULSPROD.log rows=y grants=y constraints=y statistics=none direct=n full=n consistent=y
Now I am planning to import SHLULSPROD schema to different database which is my test database, SHLULSPROD schema are exist in test database. so what command we can used for complete import the SHLULSPROD schema from orcl to test database with complete objects also imported.
Need your support.