Re: Placing schema in file system?

David E. Grove wrote:
> 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?
>
> For example, say database objects are stored in "/u01/oradata/orcl/". Is
> there a way to cause all objects created by "special_user" (and only those
> objects created by "special_user") to be stored in, say,
> "/u02/oradata/orcl"?
>
> Thank you.
>
> DG

It would be easier to give you an answer if you used terms that have meaning in the context of an Oracle database.

Data files are physical entities that map to the file system. A tablespace can consist of multiple physical data files. You can map an object to a specific tablespace but no more. So if you have a tablespace that consists of one or more data files at /u01/oradata/orcl/ then yes you can: Otherwise no.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)