export oracle tables as readable sql

mjh · 12-10-2007, 06:21 AM

Hi everyone

I am working with an Oracle 10 database - and was wondering if there was a way (on the command line / cron job) that I could export all the tables as human readable readable SQL.

I am currently using exp and imp to export and import binary dumps of the database, but would prefere to be able to see what has been exported, this would also be useful for importing the database into another machine/database.

Thanks,
Matt.

bigearsbilly · 12-10-2007, 08:09 AM

well, you can pass a script of SQL commands to the SQL login prompt can you not?

set SPOOL to a file and select what you want, n'est-ce pas?

I think that's what i used to do.

mjh · 12-10-2007, 09:41 AM

Was hoping there was some amazing program or command I could pass to exp in order to do it.... Pure laziness on my part reallty. I will give it a go.

bigearsbilly · 12-11-2007, 03:06 AM

probably is,
you could use perl DBI or PRO*C or something in java to connect I should imagine.

i can't really say cos I aint worked with oracle for about 4 years.

chrism01 · 12-12-2007, 01:05 AM

Yrs ago I used Oracle a lot and used SQL*Loader to load in flat files. I thought there was a reverse tool as well, SQL*Dump (??) or something (SQL*Loader with a dump option?) , so you could easily move backups between diff versions of Oracle.

bigearsbilly · 12-12-2007, 03:27 AM

yeah me too, sqlload from CA, I seem to remember there was a dump too, perhaps the same
tool, i remember doing configuration files for it.
but it's not free! (or it wasn't then)