Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Placing schema in file system?

Placing schema in file system?

From: David E. Grove <david_grove_at_correct.state.ak.us>
Date: Wed, 29 Jun 2005 14:42:38 -0800
Message-ID: <11c68v1j54hfp7d@corp.supernews.com>


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 Received on Wed Jun 29 2005 - 17:42:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US