Re: Schemas...

        Simplify your life and end your confusion by creating tablespaces for your application and then creating a user with default storage on the new tablespace. Now create all of the tables, indexes, grants, constraints, etc. for your application when connected as the new user.  The user will now equate to a schema and the schema will be contained in the tablespaces you have created.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 4/30/00, 3:27:47 PM, GAB <news4_at_REMOVEbaxnet.net> wrote regarding Schemas...:

> I'm a little lost on the Schema front here. I'm using the default DB
> for my new app. As I'm creating tables, I'm placing them in the
> "users" TS.
 

> The add table command also gives me an opportunity to place the table

in
> a particular SCHEMA. I think I'd like to make a new schema here, and
> sort of wrap my application's data around this new schema.
 

> Can I/should i do this? It was always my understanding that schemas
> were really a view of the DD/structure by each USER. I'm lost again..

> Greg
Received on Mon May 01 2000 - 00:00:00 CDT