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!

[Oracle]ORA-02155: invalid DEFAULT tablespace identifier

michaelhoangMar 2 2016 — edited Mar 3 2016

Hi experts,

While create user, I'm getting the following error:

ORA-02155: invalid DEFAULT tablespace identifier

I've verified and confirm that this tablespace is valid in the database.

I just have one small concerned that I'm creating user identified by default tablespace (TEMP).

Can we do for the same? If yes then how I can proceed further on this?

Thank you for your time in advances.

Best regards

This post has been answered by EdStevens on Mar 2 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 31 2016

Added on Mar 2 2016

#general-database-discussions

4 comments

2,401 views