Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: getting a dump of ddl to recreate my schema?
Mark Harrison wrote:
> I've been modifying my schema using SQL Developer, and now I
> would like to dump my schema out to an sql file.
>
> What's the best way to do this?
>
> Many TIA!
> Mark
>
No version, so my typing this answer may be a complete waste of time as my answer applies only to 9i and 10g.....but....
If by "dump my schema" you mean to create an SQL file with the CREATE SQL commands, you can try the following:
SELECT dbms_metadata.get_ddl(object_type,object_name) FROM user_objects;
Save the output to a file.
HTH,
Brian
-- =================================================================== Brian Peasland dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Sat Aug 19 2006 - 10:20:26 CDT