Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: newbie' question on SQL Loader

Re: newbie' question on SQL Loader

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 14 Feb 2001 21:02:46 +0100
Message-ID: <t8m1penutllm67@beta-news.demon.nl>

This message will be displayed even when loader rejected *all* records. Check your log file please.

Hth,

Sybrand Bakker, oracle DBA

<" srcnckpc"@hotmail.com> wrote in message news:3A8A8620.3068B33E_at_hotmail.com...
> I created a small table and loaded it with a few rows (via the control
> file) to practise the SQL Loader utililty. Thus:
>
> C:\sqlload control=data_file.ctl log=data_file.log
>
> When I executed the above command, I got:
>
> Commit point reached - logical record count 6
>
> But at SQL>select * from my_table, I get:
>
> no rows selected.
>
> How come I cannot see the rows and columns (results of the loading) in
> SQL??
>
> Thank you.
>
>
>
Received on Wed Feb 14 2001 - 14:02:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US