When install (reinstall) Oracle 12c on windows server 2008 r2 64bit, if you meet this error “oui-10137”, you should remove folder “c:\program files\oracle”, then try again. ... Read more
Tag Archives: Oracle
Withdata Software Released OracleToExcel Version 2.0
Withdata software has announced oracletoexcel 2.0, a data conversion tool that export Oracle data to excel. Version 2.0 Add “turning off log” in command line. Withdata OracleToExcel – Tool for exporting Oracle data to Excel Withdata OracleToExcel is convenient: 1. Easy visually ... Read more
Withdata Software Released OraLoader Version 4.5
Withdata software has announced oraloader 4.5, a data conversion tool that helps dba and database developer import/export Oracle database from/to flat files and Excel files. Version 4.5 Add “Bad File” to log failed import records. Add “turning off log” in command line. Fix ... Read more
Withdata Software Released XlsToOra Version 3.0
Withdata software has announced xlstoora 3.0, a data conversion tool that import Excel data to Oracle database. Version 3.0 Add “turning off log” in command line. Add “Bad File” to log failed import records. Fix bug “falied load part columns data in command ... Read more
Withdata Software Released SqliteToOracle Version 1.0
Withdata software has announced sqlitetooracle 1.0, a data conversion tool that convert SQLite data to Oracle database. Version 1.0 is the first release. SqliteToOracle – Convert SQLite data to Oracle SqliteToOracle is convenient: 1. Easy visually config, just click on the mouse. 2. ... Read more
Withdata Software Released PostgresToOracle Version 1.0
Withdata software has announced postgrestooracle 1.0, a data conversion tool that convert PostgreSQL data to Oracle database. Version 1.0 is the first release. PostgresToOracle – Convert PostgreSQL data to Oracle PostgresToOracle is convenient: 1. Easy visually config, just click on the ... Read more
Withdata Software Released OracleToSqlite Version 1.0
Withdata software has announced oracletosqlite 1.0, a data conversion tool that convert Oracle data to SQLite database. Version 1.0 is the first release. OracleToSqlite – Convert Oracle data to SQLite OracleToSqlite is convenient: 1. Easy visually config, just click on the mouse. 2. ... Read more
Withdata Software Released OracleToPostgres Version 1.0
Withdata software has announced oracletopostgres 1.0, a data conversion tool that convert Oracle data to PostgreSQL database. Version 1.0 is the first release. OracleToPostgres – Convert Oracle data to PostgreSQL OracleToPostgres is convenient: 1. Easy visually config, just click on the ... Read more
How to call Oracle Stored Procedure in OraCmd
Is it possible to call a Stored Procedure within the OraCmd ? Yes, You can. For example, you have a Oracle stored procedure “test_procedure”, create or replace procedure test_procedure is begin delete from employees where employee_id < 100; end test_procedure; In OraCmd, you ... Read more
How to execute sql file via command line for Oracle
Use sql*plus run SQL file sqlplus username/password@databasename @/path/to/test.sql If you want to see whats going on like this, including any error messages, you need connect to SQL*Plus with sqlplus username/password@databasename Then run the script from the SQL*Plus prompt: set echo ... Read more