Re: ORACLE AND UNIX QUESTION

In article <CwsxDz.4yp_at_aplcenmp.apl.jhu.edu>, <birznie_at_aplcenmp.apl.jhu.edu> writes:
> Newsgroups: comp.databases.oracle
> Path:
dcsun4.us.oracle.com!gatekeeper.us.oracle.com!decwrl!hookup!yeshua.marcam.com!M athWorks.Com!europa.eng.gtefsd.com!howland.reston.ans.net!swrinde!cs.utexas.edu !bcm!news.msfc.nasa.gov!news.larc.nasa.gov!saimiri.primate.wisc.edu!aplcenmp!bi rznie
> From: birznie_at_aplcenmp.apl.jhu.edu (Gunther Birznieks)
> Subject: ORACLE AND UNIX QUESTION
> Message-ID: <CwsxDz.4yp_at_aplcenmp.apl.jhu.edu>
> Organization: Johns Hopkins Continuing Professional Programs
> Date: Tue, 27 Sep 1994 18:44:23 GMT
> Lines: 8
>
> Question: Is Oracle limited to using Operating system files for its
> databases on UNIX? Or can you use RAW PARTITIONS to store data on a UNIX
> Box such as a Sun Sparcstation running Solaris.
>
> Thanks,
>
> Gunther
>

The answer is yes. You simply substitute the filesystem path/filename with the raw device:

CREATE TABLESPACE FOO DATAFILE '/dev/rdsk/foodsk' SIZE 800M;

The trick is to partition your disks correctly for all the files you want.

David Huet
Oracle Complex Systems Received on Wed Sep 28 1994 - 23:49:50 CET