Generate database & tables schema (ddl) on Oracle pl-sql?

I wrote oraddlscript which calls dbms_metadata. Get_ddl (Pop's answer) for each database object owned by a user and writes the DDL to a file Update: Answered comment.

I wrote oraddlscript which calls dbms_metadata. Get_ddl (Pop's answer) for each database object owned by a user and writes the DDL to a file. Update: Answered comment.

Using oracle 10.2 and can't connect, try replacing dll with the one shipped with oracle and throw exception – Dels Nov 4 '09 at 5:56 I tried on a non-development machine, and got an exceptions. Solved after installing ODAC 11.1.0. 6.21 with "install.

Bat all c:\oracle\odp odac". ODAC is here: oracle. Com/technology/software/tech/windows/odpnet/index.html.

– devio Nov 4 '09 at 7:04 thanks i'll check – Dels Nov 6 '09 at 7:01.

You could try: select dbms_metadata. Get_ddl('TABLE',table_name,owner) from dba_tables where owner='schema name'; It returns longs, so you may want to play with the long buffer. More about dbms_metadata here: download.oracle.com/docs/cd/B19306_01/ap....

Already tested use long 90000, but the generated script was unusable since it contain much blank and unterminated strings – Dels Nov 4 '09 at 5:58.

If you just need to dump your schema, this free package does a very nice job. We use it in daily production. sourceforge.net/projects/cx-oracletools If you need to convert from Oracle to SQL Server, this software might do a better job.

We've used it to convert between Oracle, MySql, and Postgreqsql. spectralcore.com/fullconvert.

I use oracle 10.2 (10g) – Dels Nov 4 '09 at 5:57 No problem for 10.2, that's what we have also. – Mark Harrison Nov 4 '09 at 16:51.

Greetings, I'd recomend using Oracle SQL Developer Data Modeler since it's from Oracle, it can read the DDL information directly from the Data Dictionary. It creates an ERD and then you can produce DDL for SQL Server 2000/2005, some versions of DB2 and Oracle 9i/10g/11g.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.