connect system/password
Connected.

create user c2c identified by c2c;
User created.

grant all privileges to c2c;

Grant succeeded.

connect c2c/c2c
Connected.

select * from tab;
no rows selected
For importing the dump file:


copy the path of dump file into command prompt and
type below statement after setting the path


imp fromuser=(dump file username) touser=(database username) file=(dumpfile name)

imp fromuser=c2c touser=c2c file=c2c.DMP

It will ask to enter username & password

Username: c2c/c2c
then press enter


tables will be imported

then start server.....