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
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
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
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 ~ !
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."
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
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
[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 ~ !
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
[db] LOL... Glad to be of help On Fri, Apr 15, 2011 at 4:18 PM, [db] <dimbega@gmail.com> wrote:
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
_______________________________________________ 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 ~ !
Yes, just make a connection to the database u r using, then when u open the database go to tools->import Data then u will get a wizard, select the csv file and the next window will ask you what table you want to load into.. The rest is magic.. :) all the best. 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
-- 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."
participants (5)
-
[db] -
kennedy kariuki -
Moses -
yonny mutai -
Zack Githinji