Home » RDBMS Server » Server Utilities » SQL Loader utility (oracle 10g enterprise edition)
SQL Loader utility [message #592931] Tue, 13 August 2013 03:22 Go to next message
satheeshsharma
Messages: 11
Registered: August 2013
Location: Chennai
Junior Member
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>sqlplus one/two

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 13 13:33:20 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> create table me(id number,name varchar(20));

Table created.

SQL> host
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>notepad one.ctl

C:\Documents and Settings\Administrator>sqlldr one/two one.ctl


SQL*Loader: Release 10.2.0.1.0 - Production on Tue Aug 13 13:35:46 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


C:\Documents and Settings\Administrator>exit

SQL> select * from me;

no rows selected.


In the above procedure...I have loaded the data from the datafile which contains datas that would be added into the table.

And the datafile is

Satheesh,1000
Aravind,2000
Mohan,3000
Ravi,4000
Magi,5000


when u see my above execution, the data is not loaded into the table...can anyone explain why data is not loaded into the table.

[Updated on: Tue, 13 August 2013 03:24]

Report message to a moderator

Re: SQL Loader utility [message #592944 is a reply to message #592931] Tue, 13 August 2013 04:07 Go to previous messageGo to next message
cookiemonster
Messages: 10846
Registered: September 2008
Location: Rainy Manchester
Senior Member
You need to check the sqlloader logfile. You haven't specified one so rerun sqlloader with a logfile specified and check what it says.
Re: SQL Loader utility [message #592961 is a reply to message #592931] Tue, 13 August 2013 05:51 Go to previous message
Lalit Kumar B
Messages: 1852
Registered: May 2013
Location: World Wide on the Web
Senior Member
satheeshsharma wrote on Tue, 13 August 2013 13:52

C:\Documents and Settings\Administrator>notepad one.ctl

C:\Documents and Settings\Administrator>sqlldr one/two one.ctl



You have only mentioned the control file. Where is the data file?
Previous Topic: About RESUMABLE, RESUMABLE_NAME parameter
Next Topic: SQL*LOADER ERROR
Goto Forum:
  


Current Time: Tue Jul 29 02:55:39 CDT 2014

Total time taken to generate the page: 0.10202 seconds