Home > IT Answers > Oracle > Multiple Tables to Bulk Import .sql script
ADMIntegrated
5 pts.
 Multiple Tables to Bulk Import .sql script
Oracle, Oracle import/export, Oracle Table Export, SQL, Sql Script, TOAD
I am a very new user to both SQL and Oracle and I am hoping that someone can explain to me if there is a way to multiple tables in a schema to .sql Import scripts. I know that in TOAD, you can right click on a table and choose export from the list, then save it as an .sql file. If I select multiple tables the export option disappears. Is there a way to do this without going through the 20-30 tables one by one? Doesn't matter what application is used, whether it's TOAD, Oracle SQL Developer, DB Visualizer, etc. Thanks.

Software/Hardware used:
ASKED: October 14, 2008  9:30 PM
UPDATED: April 22, 2009  6:59 PM
RELATED QUESTIONS
Answer Wiki:
I have been using the Lite version of Navicat Oracle for a couple of weeks now which compared it to Oracle's SQL Developer and also Oracle Maestro. I have found Navicat to open quicker (especially compared to SQL Developer... java runs soooo slow!). I also find the interface/gui to be less cluttered and easier to find things. Get at try!
Last Wiki Answer Submitted:  April 22, 2009  4:03 am  by  88522   30 pts.
All Answer Wiki Contributors:  88522   30 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Do you really need the output as a script ? or you just need it to import it in another database ?
If the latter you could use the IMPORT and EXPORT utilities.

carlosdl
 63,535 pts.