Hi,

I have a need to specify a schema/tablespace for my application so that the tables are created in a separate schema.

So I used hibernate.default_schema. This works perfectly in postgres. I connect to the database as a user and everything is now qualified with the schema name.

In Oracle, however, it seems like it's looking for a user with the specified hibernate.default_schema. So if the schema name was "myschema", it's trying to look for that user. It seems like oracle treats a schema as a user.

I tried using catalog and it's the same. It's treating it as a user as well.

Has anybody encountered this? I pretty much needs it to work the same way it does in postgres. i.e. a schema or tablespace under the same user. Not a separate user.

Thanks in advance..

Budyanto