User | Varinder Sandhu

Oracle – Create tablespace and User / Schema

Varinder Sandhu Oracle, Oracle-Tips and Tricks, Varinder Sandhu

Creating a tablespace and user is a very common task after creating an oracle database. Before going further must read the post Schema vs. User In this post we will see how to create tablespace and user with example Tablespace Each tablespace in an Oracle database consists of one or

» Read more

Oracle, Schema, Tablespace, Temporary Tablespace, User

Oracle – Schema vs User

Varinder Sandhu Oracle, Oracle-Tips and Tricks, Varinder Sandhu

For all intents and purposes you can consider a user to be a schema and a schema to be a user. A schema is the set of objects (tables, views, indexes, etc) that belongs to an user account. It is often used as another way to refer to an Oracle

» Read more

Oracle, Schema, User