Re: Data File Not Found When Select External Tables

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 7 Jun 2006 05:21:57 -0700
Message-ID: <1149682917.738265.240770@f6g2000cwb.googlegroups.com>

Resant wrote:
> Really?
> But when I map another client (not server), it's works ok!
> Is it related with permission or something else?
>
> Thanks,
>
> Resant
>
> Sybrand Bakker wrote:
> > On 6 Jun 2006 18:57:06 -0700, "Resant" <resant_v_at_yahoo.com> wrote:
> >
> > >What do you mean create a table as a file? I do create a table to *map*
> > >to an existing file.
> > >I create that file in \\server2\Data, and mapping to drive G.
> > >
> > >Below is my script :
> > >
> > >CREATE OR REPLACE DIRECTORY EXT_TABLES AS 'G:\EXT';
> >
> > Oracle doesn't support network drives.
> >
> > --
> > Sybrand Bakker, Senior Oracle DBA

Plus... You should not use mapped drives. Mapped drives are only valid within an active session. Oracle database however; runs as a service (background process).

Not sure if it will work but you can try the UNC name '\\server2\Data' instead of the mapped drive.

Regards
/Rauf Received on Wed Jun 07 2006 - 07:21:57 CDT