HomeОбразованиеRelated VideosMore From: oracletuts

How To Perform A Text Import With PL/SQL Developer

75 ratings | 23910 views
http://oracletuts.net/ Hey guys! I am TJ Abrahamsen, with OracleTuts. In this video I will show you how you can use PL/SQL Developer from Allround Automations to import a text file, in my case a .CSV file into a simple table. This tool can be used for many types of data imports into an Oracle table. I hope you find the little video helpful. ~ TJ
Html code for embedding videos on your blog
Text Comments (18)
Rajendra Bangar (8 months ago)
Very pooooor vedio quality
Zachary Zimmerman (2 years ago)
Superb. Thanks.
Raj Vallamkondu (2 years ago)
Excellent...Thanks!
nikhil more (2 years ago)
soja muna nahi tho rajnikant aajayega
Pablo Torres (3 years ago)
Excellent THANKS .!!
Tunde Akeem Ladipo (3 years ago)
Excellent
Owais Quadri (3 years ago)
May I know what version of pl/sql developer you are using? Mine is 7.1.4 and when I click on TOOLS I don't see all those options, to be specific I am looking for CONNECTIONS Thanks!
Dale (4 years ago)
Thanks for the instructive video, this was exactly the type of thing I was looking for !
oracletuts (4 years ago)
You are welcome. My first Youtube video :-)
Masse FromLA (4 years ago)
tj take a nap first
oracletuts (4 years ago)
Hi there. Thank you for the feedback. ;-)
Gagan Singh (4 years ago)
Very good tutorial.  Plain and simple.  Great help.  Thanks :)
oracletuts (5 years ago)
Created a text file that had 4.7 million records in it, with five columns. The itool seems to handle the file well. Had to kill the process after 1.7 million, since my session seemed to make my PL/SQL Developer "hang" and i needed something in another open window. But, it was still doing it's job well. Think this might be a setup issue (multi session, etc.). Anyhow...it took about 40 minutes to import 1.7 million records, where I set it to commit every 500 records. So, it is doing it's stuff.
oracletuts (5 years ago)
Hi Ralph. Thanks for the feedback. I have been very busy privately the last couple of months. I will try to make some more videos soon.
oracletuts (5 years ago)
Sorry for the late feedback. I have not tried it on large files yet. But, here is a reply to someone asking Allround Automations a similar question: Search Google for "Text Importer File Size Limit"
RM Ambrose (5 years ago)
Thanks! I'm new to Oracle, and I've been watching a lot of Chris Ostrowski's videos, but it's good to see stuff in PLSQL Developer (which I'm using) instead of Oracle's SQL Developer. I was actually looking for the Table Import & Export functions (I only found Chris's video on Export, and he uses the command line - looks like this is much nicer in PLSQL Developer). Hope you do more videos soon. I'd love to see stuff on Procedures and Packages, too.
rasandik99 (5 years ago)
Is it faster than sqlldr ? I have a million records to load !
oracletuts (5 years ago)
Yeah...I just got the dummy data from somewhere..

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.