Determining Oracle Database Instance
Other than querying the v_$database and v_$instance tables (or the views v$instance, v$database) is there any other way to programtically retrieve (from PL/SQL) the database name of an oracle database? ...
vinstance
v$Instance permission errors
Hi all, I wanted to create a view that looked something like the following but i keep getting an ORA-01031 - insufficient permission error create view v_dbinfo as Select INSTANCE_NAME,HOST_NAME from v$instance; I can select from v$instance, and create a view from an existing table without any problems. Any idea on why this is occurri...