Carlosdl 
29340 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.
Q:
Multiple Tables to Bulk Import .sql script
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.
ASKED:
Oct 14 2008 9:30 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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 Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Browse IT Answers by Topic
