Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Questions on External Tables
"Jim Kennedy" <kennedy-down_with_spammers_at_no_spam.comcast.net> wrote:
>
>
>"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)
>>
>
Are you planning to run SqlLoader on the Server? - Why?
If on a client then there would be no problem mapping the drive. Received on Fri Sep 12 2003 - 11:10:26 CDT