Re: Questions on External Tables - OOPs

Turkbear <john.greco_at_dot.state.mn.us> wrote:

>"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.
>
>
>

Sorry, I was still in the SqlLoader, not External File context.

( For Oracle to 'know' about the external file the account the Oracle service runs under needs permission to access the shared drive and it probably needs to be specified with UNC not Drive:\pathname - But not sure about that part) Received on Fri Sep 12 2003 - 11:37:18 CDT