Home > IT Answers > Oracle > Multiple Tables to Bulk Import .sql script
Help

Question

Asked:
Asked By:
Oct 14 2008   9:30 PM GMT
ADMIntegrated   5 pts.

Multiple Tables to Bulk Import .sql script


Oracle, SQL, TOAD, Oracle import/export, Sql Script, Oracle Table Export

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.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Apr 22 2009  4:03 AM GMT  by 88522   30 pts.




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!
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Oracle and Development.

Looking for relevant Oracle Whitepapers? Visit the SearchOracle.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Carlosdl   21920 pts.  |   Apr 22 2009  6:59PM GMT

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.