generate sql script from tables

Question

alt text http://www.freeimagehosting.net/uploads/64fac9c8c4.gif

is it possible to generate sql scripts from for all tables ? i want to generate the sql script and import into another database server

Answer 1

Select the tables you want to export, right click, scripts>create table script. It works in mysql, not sure about oracle.