StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POScript Oracle tables (DDL) with data insert statements into single/multiple sql files
text
Body
copied!<p>I am needing to export the tables for a given schema, into DDL scripts and Insert statements - and have it scripted such that, the order of dependencies/constraints is maintained. </p> <p>I came across this article suggesting how to archive the database with data - <a href="http://www.dba-oracle.com/t_archiving_data_in_file_structures.htm" rel="nofollow">http://www.dba-oracle.com/t_archiving_data_in_file_structures.htm</a> - not sure if the article is applicable for oracle 10g/11g.</p> <p>I have seen "export table with data" features in "Sql Developer", "Toad for Oracle", "DreamCoder for Oracle" etc, but i would need to do this one table at a time, and will still need to figure out the right order of script execution manually. </p> <p>Are there any tools/scripts that can utilize oracle metadata and generate DDL script with data? </p> <p>Note that some of the tables have CLOB datatype columns - so the tool/script would need to be able to handle these columns.</p> <p>P.S. I am needing something similar to the "Generate Scripts" feature in SQL Server 2008, where one can specify "script data" option and get back a self-sufficient script with DDL and data, generated in the order of table constraints. Please see: <a href="http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx" rel="nofollow">http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx</a></p> <p>Thanks for your help!</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload