"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1063375585.899462_at_yasure...
> 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.
Problem is that Oracle can't see the mapping since the mapping disappears
once you log off. Since Oracle is a service on the machine then it won't
see the mapping.
Jim
>
> --
> 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)
>
Received on Fri Sep 12 2003 - 10:07:28 CDT
