database

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s