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?
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