Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01950: no privileges on tablespace during import

maddoxOct 27 2011 — edited Aug 22 2013

I am trying to import using data pump (OEM) from a 10g database to an 11g database using import files. I keep receiving an error (ORA-01950: no privileges on tablespace). My user has already been granted unlimited tablespace and create any table. Also, I was able to use the same user id and manually create a table in the tablespace. Does anyone have an idea of what I could be missing?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 19 2013

Added on Oct 27 2011

#database-key-features, #export-import-sql-loader-external-tables

5 comments

23,182 views