I never mount raw disks or partitions, and never mix raw partitions and
cooked ones on the same disk. I didn't actually know you COULD 'mount' a raw
disk or disk partition.
Oh well, learn something new every day.
RSH.
"koert54" <koert54_at_nospam.com> wrote in message
news:0e8g8.223606$rt4.22113_at_afrodite.telenet-ops.be...
> 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 Sun Mar 03 2002 - 10:00:32 CST
