I've never used that, but this syntax seems to work:
alter database character set internal_use us7ascii;
Of course, you could lose some characters or mess up your data completely
that way...
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Se
Huang
@yahoo.com> cc:
Sent by: Subject: RE: alter database character
set (Was: RE: 'internal
Gopal,
In case I didn't make my message clear, I wanted to know if using that keyword
allows us to change character set from a superset to a subset (e.g. from UTF8
to US7ASCII). The documented command ALTER DATABASE CHARACTER SET
is only for changing from a subset to a superset. If changing to a
Yes. You can use INTERNAL_USE keyword to convert the database character set.
I think there is a utility called 'csscan' character set scanner which can
be
used to determine the possibility of the INTERNAL_USE conversion.
Best Regards,
K Gopalakrishnan
-Original Message-
Yong Huang
Barry,
I suggest you open a Tar with Oracle, unless you're sure changing your
application is easy. Oracle obviously missed this little detail by
over-rejecting a previously legitimate role. If 9i's Release note doesn't say
how to deal with this case, then Oracle support should open a bug.
Tom,
I
Yong,
You said "It's not always easy to have a futuristic view to avoid potential
problems. The
developer probably shouldn't have granted anything to internal back then.
But
it wasn't obvious at that time that doing so could cause a problem later."
I totally disagree with you. Your quote implies
Gopal,
Are you saying with an undocumented parameter or command, I can alter database
(national) character set us7ascii even if my current (national) character set
is utf8?
Yong Huang
--- K Gopalakrishnan <[EMAIL PROTECTED]> wrote:
> INTERNAL_USE is an keyword (to enable an undocumented feature)
Yeah,
I realized that afterward - sorry Yong.
Tom Mercadante Oracle Certified Professional
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Tuesday, November 18, 2003
11:24 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: 'internal' role and
cc:
Subject: RE: 'internal' role and 9i
Yong,
It seems to me that you are missing the point here. The real point is that
you should not have granted "select on some table to internal" - ever. And
a new release caught you on this mistake. And now, you have
INTERNAL_USE is an keyword (to enable an undocumented feature) in ALTER
DATABASE
command. THis can be used to convert the database character set if the
existing
char set (national charset) is the superset of the db charset. You can just
run
the ALTER Database command to convert the db charset.
B
Barry,
What you need to do is stop using the INTERNAL role.
Create your own role. Grant access to the tables to this role. And then
grant this role to your application user. Everything should be fine.
As I said, you made a mistake back when you started using the INTERNAL role.
Now that this
sounds hardcoded in the kernel about the internal user, reserved word or
not, its just a bad idea.
joe
Barry Deevey wrote:
As of yet I'm unsure how the application would be affected if I rename the
role - I need to do some investigation.
I tried this in Oracle 8 and it worked fine - It just see
This would explain why it worked when I tried it on oracle 8 then.
The developers that originally created the application left quite a while
ago, so I don't think I'll be able to ask them why they did it this way.
But basically you're saying that it shouldn't have been done like this and
now it ne
As of yet I'm unsure how the application would be affected if I rename the
role - I need to do some investigation.
I tried this in Oracle 8 and it worked fine - It just seems to be oracle 9
that doesn't like it.
I've also checked v$reserved_words and INTERNAL is not listed, INTERNAL_USE
and INTER
Yong,
It seems to me that you are missing the point here. The real point is that
you should not have granted "select on some table to internal" - ever. And
a new release caught you on this mistake. And now, you have to fix it. It
is not an Oracle problem, but a mis-use of an Oracle "internal"
Oops!Thanks for the correction, Yong!
> Tim,
>
> I checked v$reserved_words. At least in 9.2.0.1, INTERNAL
> is not in there. Oracle should address this issue.
>
> When I trace the SQL GRANT SELECT ON SOMETABLE TO
> INTERNAL, it stops in parsing.
>
> Nonetheless, it's confusing to say the
Tim,
I checked v$reserved_words. At least in 9.2.0.1, INTERNAL is not in there.
Oracle should address this issue.
When I trace the SQL GRANT SELECT ON SOMETABLE TO INTERNAL, it stops in
parsing.
Nonetheless, it's confusing to say the least to create a role called internal.
Yong Huang
--- Tim G
Barry,
Why make life difficult? It's just a role, not a data
object referenced by applications (hopefully). Change it's
name to something that is not a "reserved word" and move on.
There is a list of "reserved words" in the SQL Language
reference.
Hope this helps...
-Tim
> Hello all,
>
> I
18 matches
Mail list logo