Re: Placing schema in file system?

On Wed, 29 Jun 2005 14:42:38 -0800, David E. Grove interested us by writing:

> Oracle 10g
> Solaris 10
> Sun V480
>
> Is it possible to cause all database objects for a particular schema to be
> created in a (different) designated file system?

Think of it this way - Oracle uses a kind of predefined 'virtual disk' called tablespace.

Nearly all your schema objects that require disk resources are placed in these tablespaces - 'external tables', which are normally read-only, are the notable exception. When you create a table, you have the option of telling the Oracle into which tablespace to put the table. (Ditto, index.) Or you can rely on the defaults set syste-wide, or per-user.

Now, a tablespace is generally made of disk files. When you create the tablespace, you decide how many files, and where the files are to be placed.

An Oracle database needs a few tablespaces just to get running - SYSTEM and SYSAUX (in 10g). And tablespaces TEMP and UNDO are usually suggested.  Then you can add as many 'user data' tablespaces as your heart desires.

This, and many more basics, are discussed in the Concepts manual at http://docs.oracle.com

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***