Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: create user with global rights ..?
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<air0m6$s60$1_at_lust.ihug.co.nz>...
Thanks for the info about 'o7_dictionary_accessibility.
> As for changing the global name, you could try the same thing. Search for
> global_name, author Howard J. Rogers, group this one, and you'll get this as
> the first thread:
>
> alter database rename global_name to NEW.NAME.AND.DOMAIN
I did a 'o7_dictionary_accessibility=true in init.ora file
and
alter global_name set global_name='NEWNAME.DOMAIN'
It worked and works fine. But what is the difference between your command syntax and the above one.
Thanks. Received on Fri Aug 09 2002 - 09:09:53 CDT