Re: Questions on External Tables

Answers interspersed.

Pinaki wrote:

>Hello,
>
>I have a few queries regarding external tables...
>
>Q1.I need to import data in an OracleDB(Oracle 9i,Release
>2,OS-Win2K,Professional)from an excel file(.xls format). I can import
>the file through external tables provided the file is in .csv
>format.But the source file is in .xls and that is the restriction.Can
>it be done with the help of external tables?
>

No. But exactly which part of using SAVE-AS in Excel it that you can't perform?

>Q2. Data can be imported with the help of external tables provide
>there is a delimiter which delimits each column value.Can it be done
>by position as in sqlldr?
>

http://tahiti.oracle.com. Surely this is something you can look up yourself.

>Q3.In case of external table is it compulsory for the directory(in
>which my file is present i.e the .dat or.csv file) to be present in
>the physical file system of the server.Can't it be present in the file
>system of the client machine and I create a logical mapping of the
>file from the server?
>
>Thanks,
>Pinaki
>
>

If you can map it how would the machine know the difference? Just don't expect performance and scalability.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)