heeeej how's fonzie like ? coooooooool :-)
"RSH" <RSH_Oracle_at_worldnet.att.net> wrote in message
news:6dZg8.15889$106.1213224_at_bgtnsc05-news.ops.worldnet.att.net...
> "I never said you said you could".
>
> This is worse than the UN when we had all that shoe banging by the USSR.
>
> I said, "I didn't know you could do that", which hardly is equivalent of
> some "J'Accuse" thing.
>
> And I still think mixing raw partitions and file systems on the same
> spindles is a terribly bad idea, which is also something I think you
didn't
> say, so get over it.
>
> RSH.
>
>
> "koert54" <koert54_at_nospam.com> wrote in message
> news:7TGg8.235713$rt4.22558_at_afrodite.telenet-ops.be...
> > Where in my post does it say you can mount a raw device ? You can't
mount
> a
> > raw device but you can create symbolic links to it ...
> >
> > "RSH" <RSH_Oracle_at_worldnet.att.net> wrote in message
> > news:AMrg8.11070$gK2.829750_at_bgtnsc04-news.ops.worldnet.att.net...
> > > 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 Tue Mar 05 2002 - 01:07:37 CST
