Any other Oracle Lite tips?

  • Use the ODBC function to get the DB name: SELECT CAST({FN DATABASE()} AS CHAR(16)) FROM DUAL;

  • To create a new database use the following command line: CREATEDB polite new_db_name

  • Connect to your newly created DB with connect string: system/manager@odbc:polite:new_db_name