Connect with Expertise | Find Experts, Get Answers, Share Insights

how to export oracle database to a flat file

C
 
Join Date: Jan 2008
Posts: 220
#1: Nov 10 '09
I want to export oracle(version 9.2.0.1) database to a flat file. How can I do that? Is there any free tools for that? Found a tool called data loader but it is a commercial one.

debasisdas's Avatar
E
M
C
 
Join Date: Dec 2006
Location: Bangalore, KA, India
Posts: 7,648
#2: Nov 10 '09

re: how to export oracle database to a flat file


you want to export the entire database into flat file ? why ?
C
 
Join Date: Jan 2008
Posts: 220
#3: Nov 11 '09

re: how to export oracle database to a flat file


Actually I want to port my oracle database to postgres. To do that I found some forum saying need to take a oracle database to flat file and then import it from postgres.
 
Join Date: Sep 2007
Posts: 2
#4: Nov 11 '09

re: how to export oracle database to a flat file


use export utility and store the data definitions in a flat file
debasisdas's Avatar
E
M
C
 
Join Date: Dec 2006
Location: Bangalore, KA, India
Posts: 7,648
#5: Nov 12 '09

re: how to export oracle database to a flat file


Better use some third party tool for the purpose of migration.

You can try this.
Saii's Avatar
E
C
 
Join Date: Apr 2007
Posts: 145
#6: Dec 17 '09

re: how to export oracle database to a flat file


Visit postgresql.org and search for ora2pg. you may find some information
amitpatel66's Avatar
E
M
C
 
Join Date: Mar 2007
Location: Hyderabad, India
Posts: 2,241
#7: Dec 18 '09

re: how to export oracle database to a flat file


You can Export the DDL and its Data using Oracle SQL Developer also.

Navigate to Tools -> Export DDL (and Data), select the database instance and save.
Reply