Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I've designed a database on Oracle 10g xe (Windows Platform) and I want to export the tables I created in a sql file. I've googled all night and didn't find anything. I also tried to install a Windows GUI for that database but I'm not able to connect to database. Please help me out with this :D

share|improve this question

migrated from stackoverflow.com Nov 30 '11 at 1:07

This question came from our site for professional and enthusiast programmers.

add comment

2 Answers 2

There are a few different ways to do this:

  • Install Oracle SQL Developer which I thought was installed as a default. Then use this to export your data on a per table basis or as a .dmp file

  • The old fashioned way, from the dos command line using the [export command]. This gives you a .dmp file which you can import into another database2

  • if you want to send the data to another 10g or 11g database you can use the datapump which is fast and easy but takes a few minutes to set up

share|improve this answer
    
i found this after hours of research :D –  Badea Sorin Nov 30 '11 at 10:04
add comment

If you just want to extract the DDL required to create the same objects in another database, see DBMS_METADATA package. It's quite versatile, and easy to use.

If you want the data as well as the DDL, you should look at Datapump export/import. It will write the DDL and the data into a dump file, but you won't be able to read the file format.

If you really want a .SQL file, that has all the DDL and the data, I guess you could script something. Perhaps use DBMS_METADATA for the DDL, and then write some SQL that generates SQL for the DATA in a whole bunch of INSERT statements.

But, really, if you just want to be able to move an entire schema, including data, then Datapump is the answer. If you just want the DDL, in human readable form, use DBMS_METADATA.

If the requirement is for DDL and data, and it all to be human readable, then please explain your requirement in further detail.

Hope that helps.

share|improve this answer
    
but from what i've seend the dll doesn't contain the data from the tables –  Badea Sorin Nov 30 '11 at 1:13
    
Ok, I added some info to the answer, depending on different scenarios. Hope that covers it. –  Mark J. Bobak Nov 30 '11 at 2:04
    
I found what i needed: Oracle SQL Developer . It make a dump exactly like phpMyAdmin for example :) –  Badea Sorin Nov 30 '11 at 2:06
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.