Archive for the ‘Oracle’ Category

Issues With Oracle’s Recyclebin

Sunday, February 24th, 2008

Oracle introduced since 10g a new feature the Database Recyclebin, which as a Operative System recyclebin brings the ability to restore tables (files in OS) that are dropped (deleted).

(more…)

How to use Oracle Instant Client

Sunday, February 24th, 2008

Instant Client allows you to run your applications without installing the standard Oracle client or having an ORACLE_HOME. OCI, OCCI, Pro*C, ODBC, and JDBC applications work without modification, while using significantly less disk space than before. Even SQL*Plus can be used with Instant Client. No recompile, no hassle.

(more…)

‘Error ORA-00942′ During Migration

Saturday, February 16th, 2008

This error happens when the user doesn’t have DBA rights, Flex2SQL requires DBA role when converting the table, if not, then the error: “ErrorĀ : ORA-00942: table or view does not exist” comes up. Flex2SQL performs a select to some views to get information from server to use it to convert tables.