From: sybrandb@my-deja.com
Newsgroups: comp.databases.oracle.misc
Subject: Re: about SQL Loader:newbie here
Date: Fri, 02 Feb 2001 09:48:53 GMT
Organization: Deja.com
Lines: 46
Message-ID: <95dvq5$i0c$1@nnrp1.deja.com>
References: <3A79CB27.EDE55AAC@hotmail.com>
NNTP-Posting-Host: 194.229.115.34
X-Article-Creation-Date: Fri Feb 02 09:48:53 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT)
X-Http-Proxy: 1.1 x68.deja.com:80 (Squid/1.1.22) for client 194.229.115.34
X-MyDeja-Info: XMYDJUIDsybrandb




Answers embedded

In article <3A79CB27.EDE55AAC@hotmail.com>,
  " srcnckpc"@hotmail.com wrote:
> I1)s there a website or some way to learn step-by-step how to use this
> utility?
>
technet.oracle.com has all documentation, and sample control files are
in %ORACLE_RDBMS%\demo. These files are discussed in the documentation


> 2)I have Oracle8 for NT on my machine. Where can I find the Oracle
 RDBMS
> Utilities Guide?

If you installed the documentation, just go to the Oracle for NT group
and click 'documentation'. Otherwise install the documentation.
>
> 3) I am trying to load a huge database from Excel (2000 records) into
> Oracle to run queries. I know SQL Loader will do the job but have no
> idea how it will do this.
2000 huge? lol :) dump the sheet to a csv file which means columns
delimited by , and strings embedded in double quotes. Create a correct
control file and you should be there



>
> any help will be appreciated
>
>


Regards,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com
http://www.deja.com/