Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Data File Not Found When Select External Tables

Re: Data File Not Found When Select External Tables

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 07 Jun 2006 06:53:30 +0200
Message-ID: <etmc82hm569grapsgb9quvg0il6mnt45ju@4ax.com>


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
Received on Tue Jun 06 2006 - 23:53:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US