SQLULDR2 is a DBA utility to extract Oracle table's data to flat text file, it's based on OCI with excellent performance. Since most of uses like GUI interface, so I released a GUI version of SQLULDR2, let's call it SQLULDR2 for Windows. With the following user interface.
DataCopy is a DBA utility to move data between different Oracle databases with middle file generation, it's based on OCI with excellent performance. Since most of uses like GUI interface, so I released a GUI version of DataCopy too, let's call it DataCopy for Windows. With the following user interface.
Any questions or suggestions, please info me, thanks.
Comments (3)
Hi, I've been reading through all the posts and have tested this program thoroughly and it works great. However, I'm just wondering if there's an easy way to add text qualifiers? I know I can write out my own sql query and add a function to each column to do so, but that takes a tremendous amount of time to run. Most clients require the " text qualifiers and just find it a bit surprising with all the added functionalities this program has, it doesn't appear to have the one a subpar Microsoft Access has. Any help if I'm missing something would be greatly appreciated. Thanks!
Karl
Posted by Karl | May 26, 2010 2:19 AM
Click the advanced tab, and select the "CSV" for text option.
Or you can download the command line version, and enable the text qualifiers with "QUOTE=0x22" option.
Thanks.
Posted by dbatools | May 28, 2010 11:31 PM
When I tried to extract gzip file the program craches (Win XP 32 bit).
Posted by Jiri | July 2, 2010 6:06 PM