hmm...
Don't ask how we got into this situation, but I have two instances with the same global_name and need to be able to create a link between them. Is this doable? Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Donahue, Adam 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: hmm...
I was afraid that'd be the only way. Thanks. Adam -Original Message- Sent: Friday, December 06, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi Set global_names = false in init.ora file and try again -Original Message- Sent: vrijdag 6 december 2002 17:41 To: Multiple recipients of list ORACLE-L Don't ask how we got into this situation, but I have two instances with the same global_name and need to be able to create a link between them. Is this doable? Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Donahue, Adam 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.com -- Author: Jack van Zanen 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.com -- Author: Donahue, Adam 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: hmm...
Thanks for the suggestions, all. I knew about these workarounds, but apparently the answer to my original question is no. Adam -Original Message- Sent: Friday, December 06, 2002 5:39 PM To: Multiple recipients of list ORACLE-L There is: Alter database rename global_name Waleed -Original Message- Sent: Friday, December 06, 2002 5:14 PM To: Multiple recipients of list ORACLE-L You can update the global_name by using sqlplus or svrmgrl (internal or / as sysdba or sys): update global_name set global_name = newname; commit; I do this every time I clone a database. If you don't change it, then the database links won't work. DENNIS WILLIAMS wrote: Adam - Someone posted a better hidden? parameter awhile back. Jared, was that you? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 06, 2002 11:29 AM To: Multiple recipients of list ORACLE-L I was afraid that'd be the only way. Thanks. Adam -Original Message- Sent: Friday, December 06, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi Set global_names = false in init.ora file and try again -Original Message- Sent: vrijdag 6 december 2002 17:41 To: Multiple recipients of list ORACLE-L Don't ask how we got into this situation, but I have two instances with the same global_name and need to be able to create a link between them. Is this doable? Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Donahue, Adam 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.com -- Author: Jack van Zanen 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.com -- Author: Donahue, Adam 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.com -- Author: DENNIS WILLIAMS 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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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.com -- Author
RE: hmm...
That is exactly what I was looking for. Thanks. Adam -Original Message- Sent: Friday, December 06, 2002 7:29 PM To: Multiple recipients of list ORACLE-L Adam, If you need keep the global_name the Create the database link with @ symbol. The online documentation http://download-west.oracle.com/docs/cd/A97630_01/server.920/a96521/ds_admin.htm#13803 gives you some examples. I am not sure if this is what you are looking for but it may help. Scott --- Donahue, Adam [EMAIL PROTECTED] wrote: Thanks for the suggestions, all. I knew about these workarounds, but apparently the answer to my original question is no. Adam -Original Message- Sent: Friday, December 06, 2002 5:39 PM To: Multiple recipients of list ORACLE-L There is: Alter database rename global_name Waleed -Original Message- Sent: Friday, December 06, 2002 5:14 PM To: Multiple recipients of list ORACLE-L You can update the global_name by using sqlplus or svrmgrl (internal or / as sysdba or sys): update global_name set global_name = newname; commit; I do this every time I clone a database. If you don't change it, then the database links won't work. DENNIS WILLIAMS wrote: Adam - Someone posted a better hidden? parameter awhile back. Jared, was that you? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 06, 2002 11:29 AM To: Multiple recipients of list ORACLE-L I was afraid that'd be the only way. Thanks. Adam -Original Message- Sent: Friday, December 06, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi Set global_names = false in init.ora file and try again -Original Message- Sent: vrijdag 6 december 2002 17:41 To: Multiple recipients of list ORACLE-L Don't ask how we got into this situation, but I have two instances with the same global_name and need to be able to create a link between them. Is this doable? Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Donahue, Adam 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.com -- Author: Jack van Zanen 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.com -- Author: Donahue, Adam 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.com -- Author: DENNIS WILLIAMS 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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -- Please see the official ORACLE-L FAQ
RE: sys login -probably a dumb question
You probably have the sys password incorrect on instance2. If you specify "as sysdba" it basically ignores the password if you are authorized as an OS user (belong to group oracle, for example). Adam -Original Message-From: John Shaw [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 05, 2002 4:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: sys login -probably a dumb questionNope - they are both 9.2.0.2 solaris 9 [EMAIL PROTECTED] 12/05/02 02:08PM Any chance that instance 2 is 9i, and instance 1 isn't? -Original Message- From: John Shaw [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Subject: sys login -probably a dumb question I have 2 instances on a sun box. instance abc I can connect by just -- sys/not_default@abc but on instance def I can't connect by sys/not_default2@def it gives a ERROR: ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE. I have to use sys/not_default2@def as sysdba. why?
RE: [Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_inte
Dennis Williams DBA, 40%OCP ^^ How does one get to be a 40% OCP? Is that like being a 40% expert? Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Donahue, Adam 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: Changing column format
Title: RE: Changing column format I believe "username" herewould be a unique identifier. In most systems, username must be unique (at least within a particular domain). If yours is a single domain system, David, then having two Jim Joneses would not be the problem. There is another, more database-specific reason not to use the username field as the primary key: username(I assume) has semantic meaning, andm further, I assume, could change. For example, let's assume my username is "adonahue". Later I get a promotionand I want avanity username of "adam". Let's also assume your database consists of several tables, many of which reference the user table by username. In this case, updating the username will require updating ALL rows in all tables to reflect the new name. (That is, the data structure becomes denormalized if username is the primary key.) If you use userid, you can simply update the user table referenced by the corresponding userid, and no further changes would be required in child tables. Jerry's suggestion is best: userid as the primary (surrogate) key, and a non-null unique constraint on username to prevent duplicate names within the same system. Adam -Original Message-From: Whittle Jerome Contr NCI [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 07, 2002 4:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Changing column format David, I suggest that you don't. There are many "Jim Jones" in the world. How are you going to handle that? Is this field really your primary key and related to other tables or do you just need to make sure there are no duplicate names? If so, create a unique constraint instead. If you must, first make sure that there is not already a duplicate name. SELECT username, count(username) FROM your_table_name GROUP BY username HAVING count(username) 1; If you have any records returned, you need to fix your data before creating the primary key. Same thing with null values. If the SQL below returns a number other than zero, you need to put something in the null values before creating the primary key. SELECT count(username) FROM your_table_name where username = Null; To drop the primary key: ALTER TABLE your_table_name DROP PRIMARY KEY CASCADE; To create a primary key: ALTER TABLE your_table_name ADD PRIMARY KEY (username); Personally, I think you are going to regret doing this. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Nguyen, David M [SMTP:[EMAIL PROTECTED]] I create a table to store user account information and set "userid" column to be primary key. I now want to set "username" to be primary key instead of "userid", how do I change it? There are couple hundreds of records in table. Please advise. Thanks, David
RE: Changing column format
I'm not sure I understand your problem, exactly. Are you saying someone adding a user accidentically adds a new record where one already exists, and thus you have some records in subsidiary tables pointing to the first user record, and others the second? Adam -Original Message- Sent: Thursday, November 07, 2002 8:04 PM To: Multiple recipients of list ORACLE-L we have systems where for various reasons (usually because someone can't type) a row is entered with differing names, but which refer to the same person. We use unique, non-semantic ids, with no meaning associated to the key. We STILL have the problem (and I'm facing having to design a way to do this in a new system) of merging the information in these two records and cascading the referential integrity OUCH --- Jared Still [EMAIL PROTECTED] wrote: Thank you Adam! I had given up hope that someone else would point this out. Jared On Thursday 07 November 2002 14:24, Donahue, Adam wrote: I believe username here would be a unique identifier. In most systems, username must be unique (at least within a particular domain). If yours is a single domain system, David, then having two Jim Joneses would not be the problem. There is another, more database-specific reason not to use the username field as the primary key: username (I assume) has semantic meaning, andm further, I assume, could change. For example, let's assume my username is adonahue. Later I get a promotion and I want a vanity username of adam. Let's also assume your database consists of several tables, many of which reference the user table by username. In this case, updating the username will require updating ALL rows in all tables to reflect the new name. (That is, the data structure becomes denormalized if username is the primary key.) If you use userid, you can simply update the user table referenced by the corresponding userid, and no further changes would be required in child tables. Jerry's suggestion is best: userid as the primary (surrogate) key, and a non-null unique constraint on username to prevent duplicate names within the same system. Adam -Original Message- Sent: Thursday, November 07, 2002 4:24 PM To: Multiple recipients of list ORACLE-L David, I suggest that you don't. There are many Jim Jones in the world. How are you going to handle that? Is this field really your primary key and related to other tables or do you just need to make sure there are no duplicate names? If so, create a unique constraint instead. If you must, first make sure that there is not already a duplicate name. SELECT username, count(username) FROM your_table_name GROUP BY username HAVING count(username) 1; If you have any records returned, you need to fix your data before creating the primary key. Same thing with null values. If the SQL below returns a number other than zero, you need to put something in the null values before creating the primary key. SELECT count(username) FROM your_table_name where username = Null; To drop the primary key: ALTER TABLE your_table_name DROP PRIMARY KEY CASCADE; To create a primary key: ALTER TABLE your_table_name ADD PRIMARY KEY (username); Personally, I think you are going to regret doing this. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- I create a table to store user account information and set userid column to be primary key. I now want to set username to be primary key instead of userid, how do I change it? There are couple hundreds of records in table. Please advise. Thanks, David Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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). __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http
RE: Password is not case sensity and uncrypted
There are certain rules Oracle uses for its names, one of which is that names are case insensitive. Password falls under these rules. That said, you can override these rules by enclosing the password in quotation marks (just as you could do the same for a table). So SQL alter user myuser identified by CaseSenSitIve will store the password in a case-sensitive manner. But then you must use quotation marks when connecting as well, e.g., $ sqlplus myuser/CaseSenSitIve And I'm not sure this will work across platforms. A Metalink note (61424.999) on this topic indicates that UNIX seems to support case-sensitive passwords, while Windows does not. About encryption, typically Oracle stores passwords in an encrypted format by default. Adam -Original Message- Sent: Friday, October 04, 2002 1:48 PM To: Multiple recipients of list ORACLE-L Is password case-sensity in oracle database? And how do I encrypt it as it shows unencrypted in password field? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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.com -- Author: Donahue, Adam 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).