Multiple Tables to Bulk Import .sql script

5 pts.
Tags:
Oracle
Oracle import/export
SQL
SQL scripts
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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!

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    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.
    70,200 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following