Question: how to import data from dump file in oracle?
Answer: Create the user: create user <username> identified by <password> default tablespace <tablespacename> quota unlimited on <tablespacename>; Grant the rights: grant connect, create session, imp_full_database to <username>; Start the import with imp : imp <username>/<password>@<hostname> file=<filename>.