Created On:  13 February 2012

Problem:

When creating a new Workspace under Oracle, when you use an existing user id, you may get an Oracle error ORA-01950, stating that the user has no privileges on a tablespace.

Resolution:

When you create a user under Oracle, you can specify which table space it will use, to hold the database objects that are created under that user id. If the user has not been granted space within their default tablespace, or have reached their quota limit, then this message would be displayed. We would recommend that the user be granted unlimited tablespace, so that Workspace can grow as more items are added to it. For more information about our recommendation for creating new Oracle users for MWB, see article 31744: Creating additional workspaces.