Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Placing schema in file system?
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