troubleshooting Question

Oarcle 9i Database (small) convert tables to CSV for MySQL

Avatar of System Admin
System Admin asked on
DatabasesWindows OSWindows Server 2003Oracle DatabaseMySQL Server
31 Comments7 Solutions234 ViewsLast Modified:
We have a Oarcle 9i Database in a legacy system and want to convert tables to CSV with data.  For some reason they have Oracle 9i and on Windows 2003 Server.  This is a legacy application that was setup by an old administrator and I need to access to recover the data to move.

This is a blackbox system - cannot connect to network and vendor lock the DB and changed all Oracle system passwords.  

So with help from EE guys we figured out that the below will allow as sysdba.

1.  the sqlnet.ora parameter SQLNET.AUTHENTICATION_SERVICES=(NTS)
2.   sqlplus "/ as sysdba"


Well once in that I can only export a backup and other commands on the command line.  I have a developer who is going to take this small DB and convert to MySQL.  What command would allow to convert/export on the Oracle 9I command line as sysdba to a CSV with tables names and rows?  

He wants a CSV so he can import into MySQL.  If there is another way to accomplish this on the server and I don't know I'm willing to try anything.  Maybe a third party tools?  

Thank you in advance!  Will be online and able to respond and test commands.
SOLUTION
Mark Geerlings
Database Administrator, retired

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 7 Answers and 31 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 7 Answers and 31 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros