Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: newbie' question on SQL Loader
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