getting message: oci_execute(): ORA-00942: table or view does not exist

This is wrong CodeIgniter CI_Model has no constructor so you cannot use 

PHP Code:

parent::__construct(); 


I admit I'm being pedantic here, but CI_Model does have a constructor. It is empty, but it's there. So you're right in the sense that making the call is pointless.