Geek Answers Handbook

How can I create an export of Oracle Database script Using Oracle SQL Developer?

I need to create an export script for an entire Oracle database using SQL Developer.

How can i do this?

+6
oracle export oracle-sqldeveloper
source share
2 answers

Tools-> Export Database?

+20
source share

To back up the entire database, I recommend using the expdp / impdp command from the command line. If you need only objects, not data, you can use the METADATA_ONLY setting, see

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htm

If you really need to create an SQL script for your complete database and don’t want to use a commercial tool like PL / SQL Developer, TOAD, etc., you probably have to do it yourself - for example, iterate over all objects and extract their DDL script using dbms_metadata.get_ddl (), something like
foreach user u in all_users
foreach object o in users_u_objects
script += dbms_metadata.get_ddl(u, o)

+3
source share

More articles:


All Articles