
connect system/tiger
Connected.
create user c2t identified by c2t;

User created.
grant all privileges to c2t;

Grant succeeded.

connect c2t/c2t
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=CTIS touser=c2t file=ctis.DMP

It will ask to enter username & password

Username: c2t/c2t
then press enter


tables will be imported

then start server.....