Re: 'internal' role and 9i
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'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm getting loads of the same error: IMP-00017: following statement failed with ORACLE error 9275: GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL IMP-3: ORACLE error 9275 encountered ORA-09275: CONNECT INTERNAL is not a valid DBA connection I'm aware that connect internal does not exist in 9i, but 'internal' is a role. So as a test I dropped the role, recreated it and then manually tried to grant it something - The same error occurred: SQL select * from dba_roles where role like 'INTER%'; ROLE PASSWORD -- INTERNAL NO SQL SQL drop role internal; Role dropped. SQL create role internal; Role created. SQL GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL; GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL * ERROR at line 1: ORA-09275: CONNECT INTERNAL is not a valid DBA connection SQL This doesn't make any sense to me. Can anybody help to shed any light on this?? TIA for any response, they're much appreciated. Cheers, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 'internal' role and 9i
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 Gorman [EMAIL PROTECTED] wrote: 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'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm getting loads of the same error: IMP-00017: following statement failed with ORACLE error 9275: GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL IMP-3: ORACLE error 9275 encountered ORA-09275: CONNECT INTERNAL is not a valid DBA connection I'm aware that connect internal does not exist in 9i, but 'internal' is a role. So as a test I dropped the role, recreated it and then manually tried to grant it something - The same error occurred: SQL select * from dba_roles where role like 'INTER%'; ROLE PASSWORD -- INTERNAL NO SQL SQL drop role internal; Role dropped. SQL create role internal; Role created. SQL GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL; GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL * ERROR at line 1: ORA-09275: CONNECT INTERNAL is not a valid DBA connection SQL This doesn't make any sense to me. Can anybody help to shed any light on this?? TIA for any response, they're much appreciated. Cheers, Barry __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 'internal' role and 9i
Oops! blush 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 least to create a role called internal. Yong Huang --- Tim Gorman [EMAIL PROTECTED] wrote: 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'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm getting loads of the same error: IMP-00017: following statement failed with ORACLE error 9275: GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL IMP-3: ORACLE error 9275 encountered ORA-09275: CONNECT INTERNAL is not a valid DBA connection I'm aware that connect internal does not exist in 9i, but 'internal' is a role. So as a test I dropped the role, recreated it and then manually tried to grant it something - The same error occurred: SQL select * from dba_roles where role like 'INTER%'; ROLE PASSWORD -- INTERNAL NO SQL SQL drop role internal; Role dropped. SQL create role internal; Role created. SQL GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL; GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL * ERROR at line 1: ORA-09275: CONNECT INTERNAL is not a valid DBA connection SQL This doesn't make any sense to me. Can anybody help to shed any light on this?? TIA for any response, they're much appreciated. Cheers, Barry __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 to fix it. It is not an Oracle problem, but a mis-use of an Oracle internal user. What you did implies that you are running sql statements while connected as internal. Why in the world you would take this chance is beyond me - strictly a no-no. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 18, 2003 8:59 AM To: Multiple recipients of list ORACLE-L 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 Gorman [EMAIL PROTECTED] wrote: 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'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm getting loads of the same error: IMP-00017: following statement failed with ORACLE error 9275: GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL IMP-3: ORACLE error 9275 encountered ORA-09275: CONNECT INTERNAL is not a valid DBA connection I'm aware that connect internal does not exist in 9i, but 'internal' is a role. So as a test I dropped the role, recreated it and then manually tried to grant it something - The same error occurred: SQL select * from dba_roles where role like 'INTER%'; ROLE PASSWORD -- INTERNAL NO SQL SQL drop role internal; Role dropped. SQL create role internal; Role created. SQL GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL; GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL * ERROR at line 1: ORA-09275: CONNECT INTERNAL is not a valid DBA connection SQL This doesn't make any sense to me. Can anybody help to shed any light on this?? TIA for any response, they're much appreciated. Cheers, Barry __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 'internal' role and 9i
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 INTERNAL_CONVERT are. As a test I created roles for INTERNAL_USE and INTERNAL_CONVERT, hoping that it would not allow me to create them, but it did, so I then ran the grant again and it also allowed it. Now I'm really confused!! -Original Message- Tim Gorman Sent: 18 November 2003 13:34 To: Multiple recipients of list ORACLE-L 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'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm getting loads of the same error: IMP-00017: following statement failed with ORACLE error 9275: GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL IMP-3: ORACLE error 9275 encountered ORA-09275: CONNECT INTERNAL is not a valid DBA connection I'm aware that connect internal does not exist in 9i, but 'internal' is a role. So as a test I dropped the role, recreated it and then manually tried to grant it something - The same error occurred: SQL select * from dba_roles where role like 'INTER%'; ROLE PASSWORD -- INTERNAL NO SQL SQL drop role internal; Role dropped. SQL create role internal; Role created. SQL GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL; GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL * ERROR at line 1: ORA-09275: CONNECT INTERNAL is not a valid DBA connection SQL This doesn't make any sense to me. Can anybody help to shed any light on this?? TIA for any response, they're much appreciated. Cheers, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 'internal' role and 9i
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 needs to be changed. Not the answer I was hoping for, but at least now I know!! Thanks for your help all. -Original Message- Mercadante, Thomas F Sent: 18 November 2003 14:54 To: Multiple recipients of list ORACLE-L 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 user. What you did implies that you are running sql statements while connected as internal. Why in the world you would take this chance is beyond me - strictly a no-no. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 18, 2003 8:59 AM To: Multiple recipients of list ORACLE-L 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 Gorman [EMAIL PROTECTED] wrote: 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'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm getting loads of the same error: IMP-00017: following statement failed with ORACLE error 9275: GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL IMP-3: ORACLE error 9275 encountered ORA-09275: CONNECT INTERNAL is not a valid DBA connection I'm aware that connect internal does not exist in 9i, but 'internal' is a role. So as a test I dropped the role, recreated it and then manually tried to grant it something - The same error occurred: SQL select * from dba_roles where role like 'INTER%'; ROLE PASSWORD -- INTERNAL NO SQL SQL drop role internal; Role dropped. SQL create role internal; Role created. SQL GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL; GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL * ERROR at line 1: ORA-09275: CONNECT INTERNAL is not a valid DBA connection SQL This doesn't make any sense to me. Can anybody help to shed any light on this?? TIA for any response, they're much appreciated. Cheers, Barry __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send
Re: 'internal' role and 9i
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 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 INTERNAL_CONVERT are. As a test I created roles for INTERNAL_USE and INTERNAL_CONVERT, hoping that it would not allow me to create them, but it did, so I then ran the grant again and it also allowed it. Now I'm really confused!! -Original Message- Tim Gorman Sent: 18 November 2003 13:34 To: Multiple recipients of list ORACLE-L 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'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm getting loads of the same error: IMP-00017: following statement failed with ORACLE error 9275: GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL IMP-3: ORACLE error 9275 encountered ORA-09275: CONNECT INTERNAL is not a valid DBA connection I'm aware that connect internal does not exist in 9i, but 'internal' is a role. So as a test I dropped the role, recreated it and then manually tried to grant it something - The same error occurred: SQL select * from dba_roles where role like 'INTER%'; ROLE PASSWORD -- INTERNAL NO SQL SQL drop role internal; Role dropped. SQL create role internal; Role created. SQL GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL; GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL * ERROR at line 1: ORA-09275: CONNECT INTERNAL is not a valid DBA connection SQL This doesn't make any sense to me. Can anybody help to shed any light on this?? TIA for any response, they're much appreciated. Cheers, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 'internal' role and 9i
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 has gone away, you have to pay the piper. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 18, 2003 10:09 AM To: Multiple recipients of list ORACLE-L 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 INTERNAL_CONVERT are. As a test I created roles for INTERNAL_USE and INTERNAL_CONVERT, hoping that it would not allow me to create them, but it did, so I then ran the grant again and it also allowed it. Now I'm really confused!! -Original Message- Tim Gorman Sent: 18 November 2003 13:34 To: Multiple recipients of list ORACLE-L 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'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm getting loads of the same error: IMP-00017: following statement failed with ORACLE error 9275: GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL IMP-3: ORACLE error 9275 encountered ORA-09275: CONNECT INTERNAL is not a valid DBA connection I'm aware that connect internal does not exist in 9i, but 'internal' is a role. So as a test I dropped the role, recreated it and then manually tried to grant it something - The same error occurred: SQL select * from dba_roles where role like 'INTER%'; ROLE PASSWORD -- INTERNAL NO SQL SQL drop role internal; Role dropped. SQL create role internal; Role created. SQL GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL; GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL * ERROR at line 1: ORA-09275: CONNECT INTERNAL is not a valid DBA connection SQL This doesn't make any sense to me. Can anybody help to shed any light on this?? TIA for any response, they're much appreciated. Cheers, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of
RE: 'internal' role and 9i
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. Best Regards, K Gopalakrishnan -Original Message- Barry Deevey Sent: Tuesday, November 18, 2003 7:09 AM To: Multiple recipients of list ORACLE-L 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 INTERNAL_CONVERT are. As a test I created roles for INTERNAL_USE and INTERNAL_CONVERT, hoping that it would not allow me to create them, but it did, so I then ran the grant again and it also allowed it. Now I'm really confused!! -Original Message- Tim Gorman Sent: 18 November 2003 13:34 To: Multiple recipients of list ORACLE-L 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'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm getting loads of the same error: IMP-00017: following statement failed with ORACLE error 9275: GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL IMP-3: ORACLE error 9275 encountered ORA-09275: CONNECT INTERNAL is not a valid DBA connection I'm aware that connect internal does not exist in 9i, but 'internal' is a role. So as a test I dropped the role, recreated it and then manually tried to grant it something - The same error occurred: SQL select * from dba_roles where role like 'INTER%'; ROLE PASSWORD -- INTERNAL NO SQL SQL drop role internal; Role dropped. SQL create role internal; Role created. SQL GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL; GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL * ERROR at line 1: ORA-09275: CONNECT INTERNAL is not a valid DBA connection SQL This doesn't make any sense to me. Can anybody help to shed any light on this?? TIA for any response, they're much appreciated. Cheers, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
RE: 'internal' role and 9i
Yong didn't do it, he merely posted a reply. Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/18/2003 06:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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 to fix it. It is not an Oracle problem, but a mis-use of an Oracle internal user. What you did implies that you are running sql statements while connected as internal. Why in the world you would take this chance is beyond me - strictly a no-no. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 18, 2003 8:59 AM To: Multiple recipients of list ORACLE-L 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 Gorman [EMAIL PROTECTED] wrote: 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'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm getting loads of the same error: IMP-00017: following statement failed with ORACLE error 9275: GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL IMP-3: ORACLE error 9275 encountered ORA-09275: CONNECT INTERNAL is not a valid DBA connection I'm aware that connect internal does not exist in 9i, but 'internal' is a role. So as a test I dropped the role, recreated it and then manually tried to grant it something - The same error occurred: SQL select * from dba_roles where role like 'INTER%'; ROLE PASSWORD -- INTERNALNO SQL SQL drop role internal; Role dropped. SQL create role internal; Role created. SQL GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL; GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL * ERROR at line 1: ORA-09275: CONNECT INTERNAL is not a valid DBA connection SQL This doesn't make any sense to me. Can anybody help to shed any light on this?? TIA for any response, they're much appreciated. Cheers, Barry __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 'internal' role and 9i
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 9iYong didn't do it, he merely posted a reply. "Mercadante, Thomas F" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/18/2003 06:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: 'internal' role and 9iYong,It seems to me that you are missing the point here. The real point is thatyou should not have granted "select on some table to internal" - ever. Anda new release caught you on this mistake. And now, you have to fix it. Itis not an Oracle problem, but a mis-use of an Oracle "internal" user.What you did implies that you are running sql statements while connected asinternal. Why in the world you would take this chance is beyond me -strictly a no-no.Tom MercadanteOracle Certified Professional-Original Message-Sent: Tuesday, November 18, 2003 8:59 AMTo: Multiple recipients of list ORACLE-LTim,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 inparsing.Nonetheless, it's confusing to say the least to create a role calledinternal.Yong Huang--- Tim Gorman [EMAIL PROTECTED] wrote: 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... -TimHello all,I'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm getting loads of the same error: IMP-00017: following statement failed with ORACLE error 9275: "GRANT SELECT ON "DOWNLOAD_SEQ" TO "INTERNAL"" IMP-3: ORACLE error 9275 encountered ORA-09275: CONNECT INTERNAL is not a valid DBA connection I'm aware that connect internal does not exist in 9i, but 'internal' is a role.So as a test I dropped the role, recreated it and then manually tried to grant it something - The same error occurred: SQL select * from dba_roles where role like 'INTER%'; ROLE PASSWORD -- INTERNAL NO SQL SQL drop role internal; Role dropped.SQL create role internal; Role created.SQL GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL; GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL * ERROR at line 1: ORA-09275: CONNECT INTERNAL is not a valid DBA connectionSQLThis doesn't make any sense to me. Can anybody help to shed any light on this??TIA for any response, they're much appreciated.Cheers, Barry__Do you Yahoo!?Protect your identity with Yahoo! Mail AddressGuardhttp://antispam.yahoo.com/whatsnewfree-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Yong HuangINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Mercadante, Thomas FINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
alter database character set (Was: RE: 'internal' role and 9i)
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) 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. Best Regards, K Gopalakrishnan -Original Message- Barry Deevey Sent: Tuesday, November 18, 2003 7:09 AM To: Multiple recipients of list ORACLE-L 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 INTERNAL_CONVERT are. As a test I created roles for INTERNAL_USE and INTERNAL_CONVERT, hoping that it would not allow me to create them, but it did, so I then ran the grant again and it also allowed it. Now I'm really confused!! __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 'internal' role and 9i
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 that it is ok for developers to be using the SYS account - which is what Internal actually is. This is totally wrong. Sys/Internal is for creating/patching the database - for internal use only - never for application use. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 18, 2003 11:49 AM To: Multiple recipients of list ORACLE-L 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, 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. Yong Huang --- Barry Deevey [EMAIL PROTECTED] wrote: 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 needs to be changed. Not the answer I was hoping for, but at least now I know!! Thanks for your help all. -Original Message- Mercadante, Thomas F Sent: 18 November 2003 14:54 To: Multiple recipients of list ORACLE-L 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 user. What you did implies that you are running sql statements while connected as internal. Why in the world you would take this chance is beyond me - strictly a no-no. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 18, 2003 8:59 AM To: Multiple recipients of list ORACLE-L 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 Gorman [EMAIL PROTECTED] wrote: 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'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm getting loads of the same error: IMP-00017: following statement failed with ORACLE error 9275: GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL IMP-3: ORACLE error 9275 encountered ORA-09275: CONNECT INTERNAL is not a valid DBA connection I'm aware that connect internal does not exist in 9i, but 'internal' is a role. So as a test I dropped the role, recreated it and then manually tried to grant it something - The same error occurred: SQL select * from dba_roles where role like 'INTER%'; ROLE PASSWORD -- INTERNAL NO SQL SQL drop role internal; Role dropped. SQL create role internal; Role created. SQL GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL; GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL * ERROR at line 1: ORA-09275: CONNECT INTERNAL is not a valid DBA connection SQL This doesn't make any sense to me. Can anybody help to shed any light on this?? TIA for any response, they're much appreciated. Cheers, Barry __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
RE: 'internal' role and 9i
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, 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. Yong Huang --- Barry Deevey [EMAIL PROTECTED] wrote: 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 needs to be changed. Not the answer I was hoping for, but at least now I know!! Thanks for your help all. -Original Message- Mercadante, Thomas F Sent: 18 November 2003 14:54 To: Multiple recipients of list ORACLE-L 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 user. What you did implies that you are running sql statements while connected as internal. Why in the world you would take this chance is beyond me - strictly a no-no. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 18, 2003 8:59 AM To: Multiple recipients of list ORACLE-L 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 Gorman [EMAIL PROTECTED] wrote: 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'm attempting to import into 9.2.0.1.0 from 7.3.4 and I'm getting loads of the same error: IMP-00017: following statement failed with ORACLE error 9275: GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL IMP-3: ORACLE error 9275 encountered ORA-09275: CONNECT INTERNAL is not a valid DBA connection I'm aware that connect internal does not exist in 9i, but 'internal' is a role. So as a test I dropped the role, recreated it and then manually tried to grant it something - The same error occurred: SQL select * from dba_roles where role like 'INTER%'; ROLE PASSWORD -- INTERNAL NO SQL SQL drop role internal; Role dropped. SQL create role internal; Role created. SQL GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL; GRANT SELECT ON DOWNLOAD_SEQ TO INTERNAL * ERROR at line 1: ORA-09275: CONNECT INTERNAL is not a valid DBA connection SQL This doesn't make any sense to me. Can anybody help to shed any light on this?? TIA for any response, they're much appreciated. Cheers, Barry __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
RE: alter database character set (Was: RE: 'internal' role and 9i)
INSERT STANDARD DISCLAIMERS 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. END DISCLAIMERS Best Regards, K Gopalakrishnan -Original Message- Yong Huang Sent: Tuesday, November 18, 2003 9:00 AM To: Multiple recipients of list ORACLE-L 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) 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. Best Regards, K Gopalakrishnan -Original Message- Barry Deevey Sent: Tuesday, November 18, 2003 7:09 AM To: Multiple recipients of list ORACLE-L 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 INTERNAL_CONVERT are. As a test I created roles for INTERNAL_USE and INTERNAL_CONVERT, hoping that it would not allow me to create them, but it did, so I then ran the grant again and it also allowed it. Now I'm really confused!! __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: alter database character set (Was: RE: 'internal' role and 9i)
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 new charset is only for changing from a subset to a superset. If changing to a lower character set works, what's the syntax? Personally, I can't imagine how that's possible. Thanks. Yong Huang --- K Gopalakrishnan [EMAIL PROTECTED] wrote: INSERT STANDARD DISCLAIMERS 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. END DISCLAIMERS Best Regards, K Gopalakrishnan -Original Message- Yong Huang Sent: Tuesday, November 18, 2003 9:00 AM To: Multiple recipients of list ORACLE-L 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) 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. Best Regards, K Gopalakrishnan -Original Message- Barry Deevey Sent: Tuesday, November 18, 2003 7:09 AM To: Multiple recipients of list ORACLE-L 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 INTERNAL_CONVERT are. As a test I created roles for INTERNAL_USE and INTERNAL_CONVERT, hoping that it would not allow me to create them, but it did, so I then ran the grant again and it also allowed it. Now I'm really confused!! __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: alter database character set (Was: RE: 'internal' role and 9i)
It does. If you do a full import from a US7ASCII database into a WE8ISO8859P1 database and you need to change the WE8ISO8859P1 database to US7ASCII then this is the way to do it. ALTER DATABASE CHARACTER SET internal_use us7ascii; Make sure you know what you're doing. See Metalink Doc Id 100751.996 Yong Huang yong321 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @yahoo.com cc: Sent by: Subject: RE: alter database character set (Was: RE: 'internal' role and 9i) ml-errors 11/18/2003 12:49 PM Please respond to ORACLE-L 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 new charset is only for changing from a subset to a superset. If changing to a lower character set works, what's the syntax? Personally, I can't imagine how that's possible. Thanks. Yong Huang --- K Gopalakrishnan [EMAIL PROTECTED] wrote: INSERT STANDARD DISCLAIMERS 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. END DISCLAIMERS Best Regards, K Gopalakrishnan -Original Message- Yong Huang Sent: Tuesday, November 18, 2003 9:00 AM To: Multiple recipients of list ORACLE-L 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) 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. Best Regards, K Gopalakrishnan -Original Message- Barry Deevey Sent: Tuesday, November 18, 2003 7:09 AM To: Multiple recipients of list ORACLE-L 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 INTERNAL_CONVERT are. As a test I created roles for INTERNAL_USE and INTERNAL_CONVERT, hoping that it would not allow me to create them, but it did, so I then ran the grant again and it also allowed it. Now I'm really confused!! __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling
Re: alter database character set (Was: RE: 'internal' role and 9i)
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] Sent: Tuesday, November 18, 2003 7:49 PM 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 new charset is only for changing from a subset to a superset. If changing to a lower character set works, what's the syntax? Personally, I can't imagine how that's possible. Thanks. Yong Huang --- K Gopalakrishnan [EMAIL PROTECTED] wrote: INSERT STANDARD DISCLAIMERS 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. END DISCLAIMERS Best Regards, K Gopalakrishnan -Original Message- Yong Huang Sent: Tuesday, November 18, 2003 9:00 AM To: Multiple recipients of list ORACLE-L 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) 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. Best Regards, K Gopalakrishnan -Original Message- Barry Deevey Sent: Tuesday, November 18, 2003 7:09 AM To: Multiple recipients of list ORACLE-L 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 INTERNAL_CONVERT are. As a test I created roles for INTERNAL_USE and INTERNAL_CONVERT, hoping that it would not allow me to create them, but it did, so I then ran the grant again and it also allowed it. Now I'm really confused!! __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).