Hi dude,

dmp is a Database file. its consist Tables, stored procedure, function, package etc.

this dmp file use to transfer one server to another server. if this creating before we log in and create user name and give privileges . Here user called as Database name.and give to privileage then only uploaded the dmp file

C:\>sqlplus system/password

SQL> create user CLIENT_TEST identified by client_test_password;
SQL> grant connect, unlimited tablespace, resource to CLIENT_TEST;
SQL> exit

 

 

C:\>imp system/password FROMUSER=ABCDE TOUSER=client_test file=c:\database.dmp full=yes
Advertisements