Home » RDBMS Server » Server Administration » Re: Instance Names
Re: Instance Names [message #369999] Fri, 24 November 2000 05:39
Rajesh Matkar
Messages: 20
Registered: September 1999
Junior Member
Hi,
To get current instance name, use V$instance oracle Data Dictionary view. You are getting problem due to your access rights. You should connect with SYSTEM user or SYS user or provide SELECT ANY TABLE to your current user. You will definately access instance information.

Best of luck

- Rajesh

Report message to a moderator

Previous Topic: Dynamic SQL
Next Topic: Single quote character in data causes problems
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 04 14:49:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.