Re: TableSpace and users

From: Jean-Philippe Squelbut <squelbut_at_csi.com>
Date: Thu, 30 Jul 1998 09:50:36 +0200
Message-ID: <uoqnn74u9GA.323@ntdwwaaw.compuserve.com>

First, it's a very good idea to separate the data of your different application.
But, what ever you'll do you'll use the tablespaces.

1° If you don't care about tablespaces, all the objects you'll create will probably be in the tablespace 'system' because it is the default tablespace.

2° If you care about tablespaces, you 'll create one or more tablespaces by application, so the objects you'll create will be in the tablespace you want.

Just consider the Oracle "user" as a way to classify the relationnal objects. It is also called "schema", the owner. It is the application level in the relationnal world.
Consider the tablespace as a way of to classify the disk space consumed by the relationnal objects of your application.

The way to associate TS with user is the clause "default tablespace" and "quota unlimited" in "create user". A very simple mnemonic trick is to give the same name or code to apllication, user, and TS.

advantages:

of 1°     -nothing to think about
of 2°     - easier to manage, to reorg, to custom space allocation by

application.

disadvantages:
of 1° - very bad for the dictionnary, for the instance

• very difficult to reorg of 2° - you must think about it

I think you've the answer of the secon question.

Danielle Fortes a écrit dans le message ...
>
>I´m just starting with Oracle so ... sometimes i´m going making stupid
>questions! :)
>
>Well ... I was thinking to use Oracle´s tablespaces to separate database
>objetcs from several different applications like Human resources, Payroll
>and others ? I know the advantages but could someone tell me about the
>disadvantages to use this resource ? We develop products so I beleive that
>using tablespace I can improve distributions too.
>
>The other question is:
>
>Are there any problems to create some objetcs of database using SYSTEM or
>SCOTT user´s ?
>
>Thanks in advanced!
>
>Danielle Fortes
>fortes_at_metalink.com.br
>Remix Tecnologia Ltda
>Brazil
>
Received on Thu Jul 30 1998 - 02:50:36 CDT