New To Oracle DB

Oracle Database XE 11.2 on Windows 2008 64 bit

  1. run imp or impdp command in windows command line, not SQL command line

  2. It failed to import dmp file by command : imp, impdp works

  • Issue: ORA-01918: user does not exist 

Create user manually by instruction

  • ORA-00959: tablespace does not exist

Create tablespace by instruction

Be careful about ORA-12953: The request exceeds the maximum allowed database size of 11 GB

  • ORA-01950: no privileges on tablespace

Grant permission by instruction

Note: Assign privilege to database owner.