Yonny, You're genius itself, i have never seen that item under there! [db] On 15 April 2011 15:27, yonny mutai <yonnym@googlemail.com> wrote:
[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