Tuesday, September 3, 2013

No privileges on tablespace 'USERS' with Oracle

Problem:
I created an export of an existing database (schemas) as system. Then I created a test database. I created tablespaces and users, and then imported this export dmp file into the test database as system.

All seems to go well except on a few tables I get 'no privileges on tablespace 'USERS' message.

I don't understand why I'm getting this error.  Does the system user have a limited quota on the user tablespace? How can I resolve this?
Answer:

The solution to this tablespace problem is simple.  The user who owns the tables must be given privileges on users.

You can type this command into your SQL*Plus to grant tablespace:

GRANT UNLIMITED TABLESPACE TO <username>;

No comments:

Post a Comment