Skip to Main Content

Oracle Database Discussions

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!

setting the default and temporary tablespace for a user

6ab48247-f8b7-4731-8192-492884451c8eAug 6 2014 — edited Aug 6 2014

I am trying to create  a user in Oracle 11g XE using the following code.

create user test1 identified by testee1

default tablespace USERS

temporary tablespace TEMP

grant connect, resource, dab to test1

account unlock;

create user test1 identified by testee1

default tablespace USERS

temporary tablespace TEMP

grant connect, resource, dab to test1

quota 5m on USERS

quota 5m on TEMP

account unlock;

account unlock;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2014
Added on Aug 6 2014
2 comments
1,462 views