data loader other than SQL Loader

[maswien]

Does anyone know any other Oracle data loader other than SQL Loader and has a better user interface?

Thanks

 

[JaxtheDog]

I use TOAD (Tool for Oracle Developers) from Quest software which allows you several options to load data as well as view and query. You can download a free 30 day copy from their web site. It's worth a try, I like it.

Jax

 

[maswien]

Thanks a lot! I guess that's what I want, another question, when I went to the quest website, there are many versions for me to choose, is "Toad for Oracle Suite" the one that I need to choose?

Thanks

 

[JaxtheDog]

Mjia,
There are different versions depending on features you want. The professional Suite, for excample, has lots of DBA stuff and trace/explain plan, etc.

For a try-out of the database loader, the roacle Suite one works well. Download it and answer the questions about yourself. They will email you a 30 day key to test it. Then you can see if you like it and want to actually talk about other features.

Regards,
Jax

 

[knowlgo]

I would be really careful using the native Import function on TOAD. It's very slow for any kind of sizeable data. If anything, you'll want to use the DBA/SQLLOADERWIZARD in TOAD, which just creates a sql loader script. It's slightly easier since it will build it for you. If you need to do any kind of positional load, it will be more difficult.