patternMinor
Oracle 10g XE GUI
Viewed 0 times
oraclegui10g
Problem
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
Solution
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
-
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
Context
StackExchange Database Administrators Q#8574, answer score: 4
Revisions (0)
No revisions yet.