Oracle 9.0.1.1 exp bug
I tried to run an intranet app from home, with a database connection from my laptop tunneled to Telkom HQ Data Center. Seems that the application tooks too many queries and data volume were bit too much (OK, maybe I should profile the data volume & query counts...), it took me an hour of trial and error so that I realized : it is impossible to run the app without timing out while in tunneled connection. OK, then proceed to think.. If this is were my usual application, what would I do ? I would fire up MySQL Administrator and backup the externally located database in my system, then restore it to my local MySQL database. For oracle database, the tool alternatives were: - use TOAD to move the database (which, I think would be tedious, and also I have no TOAD installed in my system) - use Oracle Datapump, which we cannot use because the database are 9.0.1.1, where such technology haven't exist yet, and also .. I have no experience at this moment on Datapump. - migrate to MySQL,