Re: how to access mounted drive as raw file

I'm guessing you're on on some sort of windows platform using some sort of Oracle version (the one without a version and stuff )?????

Anyways - a raw device is a piece of your disk without a filesystem on it - can be a logical volume or a partition.
On NT/2000 you also don't have to assign a drive letter to it ...

On Unix you can access the raw device through its special device file. The lazy dba's amoung as - me included - like to create symbolic links to the special device file (ln -s /dev/xxx xxx.dbf) ... this way the usage within Oracle is kind of transparant.

Now on NT/2000 the only way to access a raw device is by creating symbolic links representing the raw devices. So using \\.\i:\raw is pretty pointless because there's no drive letter to point to ! :-) So you'll need an Oracle tool called Oracle Object Link Manager. (GUIORACLEOBJMANAGER.EXE)
It's normally included with Oracle OPS or Oracle RAC. I just installed/configured a 9i RAC last week on 2000 and this tool will let you create/delete/rename the symbolic links and sync the links amoung the participating nodes...
Once the link is created you can do things like " create tablespace .... datafile '\\.\symbolic_link_name' "

Oracle 9i RAC is now sooooo easy you could even do it with one thumb in your ass ! (until the lock transferts start and your thumb is needed for gc_files_to_lock) :-)

"Richard Limanowski" <richard.limanowski_at_t-online.de> wrote in message news:a77e1f06.0203020624.7cd9fc24_at_posting.google.com...
> Hi,
>
> I am looking for a way to access "mounted drive" as a raw file from
> within oracle.
>
> In an article "HOW TO SETUP ORACLE ON A RAW PARTITION" I found a
> description how to do in on a partition level:
> 1. create partition (without creating a file system on it)
> 2. use raw file with a construct '\\.\f:' like
> create tablespace xxx datafile '\\.\f:' size 1 M;
>
> But what if I:
> 1. create partition (without creating a file system on it)
> 2. do not assign a drive letter to it but mount it into an empty
> NTFS directory, say 'i:\raw1'?
>
> I tried:
> richard_at_onc> CREATE TABLESPACE rts DATAFILE '\\.\i:\raw1' SIZE 1M
> *
> ERROR at line 1:
> ORA-01119: error in creating database file '\\.\i:\raw1'
> ORA-27040: skgfrcre: create error, unable to create file
> OSD-04002: Datei kann nicht geöffnet werden
> O/S-Error: (OS 5) Zugriff verweigert
>
> Cheers
>
> Richard Limanowski
Received on Sat Mar 02 2002 - 11:46:36 CST