Oarcle 9i Database (small) convert tables to CSV for MySQL
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.
DatabasesWindows OSWindows Server 2003Oracle DatabaseMySQL Server
I'm not a DBA but can follow steps, What would be the commands now that I'm in at this user?
I think it will be easier to download a trial of TOAD then install access. What would be the commands from TOAD to export? Or do I still need a platform like ACCESS or EXCEL? I've attached two screenshots showing I'm in now.