Re: external table
Date: 11 Sep 2003 12:27:12 -0700
Message-ID: <83e64e50.0309111127.17363491_at_posting.google.com>
Billy,
Before we create an external table, we use CREATE OR REPLACE DIRECTORY testing AS '/../../../testing/' command. The data file(s) should be in that (testing) directory.
After creating the external table, we load the data from external
table to the existing table,
then the log files and the bad files go to the 'testing' directory
where the data files are.
How to specify that ?
vslabs_at_onwe.co.za (Billy Verreynne) wrote in message news:<1a75df45.0309110443.1445e0fc_at_posting.google.com>...
> helpora_at_yahoo.com (Erohsik) wrote in message
>
> > I am using external tables to load data from the data file. But the
> > log files
> > are getting created in the datafile's directory (because of CREATE OR
> > REPLACE DIRECTORY ...)
> > But I want those log files get created in a perticular directory. How
> > can I do that ?
>
> Parsing error. Provide more detail.
>
> What external tables? Are you loading into a remote db via an Oracle
> db link?
>
> What log files? CREATE DIRECTORY is for using BFILES. Not log files
> (as in alert log, sql loader log, import log) files.
Received on Thu Sep 11 2003 - 21:27:12 CEST