[db]

  yes... you just right click on the table and select load,select a csv .. select the columns.. and it loads the data to the table.I use it for small files, for huge files i use sqldr.

On Fri, Apr 15, 2011 at 2:33 PM, [db] <dimbega@gmail.com> wrote:

Thanks Zack,
And all the rest of you ?
Zack
The database workbench seems rather solid and nice,
have you loaded excel and .csv to the db with it?
I wanna engage you since i only manage to find functionality to transfer from db to db.

db

On 15 April 2011 14:15, [db] <dimbega@gmail.com> wrote:

Yonny,
Does Sql Developer really have Sql Ldr capability?

db

On 15 April 2011 14:04, Zack Githinji <zachgithinji@gmail.com> wrote:

try use, database workbench from upscene

On Fri, Apr 15, 2011 at 1:45 PM, yonny mutai <yonnym@googlemail.com> wrote:

Oracle SqlDeveloper

On Fri, Apr 15, 2011 at 1:33 PM, kennedy kariuki <kkairu@gmail.com> wrote:

Toad
Quickload

On Fri, Apr 15, 2011 at 12:56 PM, [db] <dimbega@gmail.com> wrote:

Moses,
Could you name me some good ones that i could try?
much appreciated.

On 15 April 2011 12:52, Moses <mosenetk@gmail.com> wrote:

You might try using a gui tool or EM online for this.  Given the small size of the csv.

Moses.

On 15 Apr 2011 12:11, "[db]" <dimbega@gmail.com> wrote:

Hi guys,

i have been trying to load a .csv file of about 6K on to an Oracle 10g DB.
The issue i have is that it keeps giving me a variance of errors that mostly include

"SQL*Loader-128: unable to begin a session
ORA-03135: connection lost contact"

The error seems so forthright and am frustrated that i cannot find the solution.
could it be the connection to the db, and if it is, tnsping seems to disprove that.

Running
Win 7 Ultimate
ORACLE 10g


DB

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke

--

,_._._._._._._._|____________________________________________________ 

|_|_|_|_|_|_|_|_|___________________________________________________/ 

 ~ Yonny ~ !      

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke

--
Regards,
Zack K. Githinji
Technical Officer,

Cell:+254 722 649199
E-mail:zachgithinji@gmail.com

"God grant me the serenity to accept the things I cannot change, the
courage to change the things I can, and the wisdom to know the
difference."

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke

--

,_._._._._._._._|____________________________________________________ 

|_|_|_|_|_|_|_|_|___________________________________________________/ 

 ~ Yonny ~ !      

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke