Re: ORA-00904
dealt with that one this week on aix platform. a couple of things can cause it. 1. an upgrade or patch and then forget to run catalog, catproc, catrep(if ur using replication), utlirp. 2. using a version of export that is not compatible with the database(no one flame me for this, it was on metalink). if you want moer into on the error, let me know, i'll go and get the doc id from metalink so you can look it up. joe "PHU,JULIA (HP-Sunnyvale,ex2)" wrote: > > Greetings, > > I'm lost on the 'ORA-00904: invalid column name' error message. Can someone > shed some light on it? It is 8i on NT box with sp6a. > > Regards, > Julia Phu > -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: ORA-00904
Hi, Joe, 'an upgrade or patch and then forget to run catalog, catproc, catrep(if ur using replication), utlirp.' Do you recommend to run catalog, catproc, catrep, and utlirp? I looked up a doc in Metalink and couldn't resolve my problem. Perhaps I looked up the incorrect one. Please send me info if you will. Thank you. Julia -Original Message- Sent: Saturday, May 26, 2001 6:00 AM To: Multiple recipients of list ORACLE-L dealt with that one this week on aix platform. a couple of things can cause it. 1. an upgrade or patch and then forget to run catalog, catproc, catrep(if ur using replication), utlirp. 2. using a version of export that is not compatible with the database(no one flame me for this, it was on metalink). if you want moer into on the error, let me know, i'll go and get the doc id from metalink so you can look it up. joe "PHU,JULIA (HP-Sunnyvale,ex2)" wrote: > > Greetings, > > I'm lost on the 'ORA-00904: invalid column name' error message. Can someone > shed some light on it? It is 8i on NT box with sp6a. > > Regards, > Julia Phu > -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: PHU,JULIA (HP-Sunnyvale,ex2) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
automatic create LS user in portal30 when add empluyee table
hello gurus i have employee table, and i'm planning that a employee can login to portal with his profile data. how to create or remove user login server to portal, when i add new record to employee or delete employee record. Any information on how I can accomplish this would be greatly appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: darlis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: ORA-00904 - RESOLVED!
Hi, Joe, The ORA-00904 is resolved. I think the 'ALTER SYSTEM FLUSH SHARED_POOL' solved the problem. Thanks for the reply. Julia -Original Message- Sent: Saturday, May 26, 2001 6:00 AM To: Multiple recipients of list ORACLE-L dealt with that one this week on aix platform. a couple of things can cause it. 1. an upgrade or patch and then forget to run catalog, catproc, catrep(if ur using replication), utlirp. 2. using a version of export that is not compatible with the database(no one flame me for this, it was on metalink). if you want moer into on the error, let me know, i'll go and get the doc id from metalink so you can look it up. joe "PHU,JULIA (HP-Sunnyvale,ex2)" wrote: > > Greetings, > > I'm lost on the 'ORA-00904: invalid column name' error message. Can someone > shed some light on it? It is 8i on NT box with sp6a. > > Regards, > Julia Phu > -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: PHU,JULIA (HP-Sunnyvale,ex2) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: ORA-00904
I dont necessarily recommend it but thats whats in most release notes for patches sets, so I tend to follow the instructions oracle gives in most cases :) Joe "PHU,JULIA (HP-Sunnyvale,ex2)" wrote: > > Hi, Joe, > > 'an upgrade or patch and then forget to run catalog, catproc, > catrep(if ur using replication), utlirp.' > > Do you recommend to run catalog, catproc, catrep, and utlirp? > > I looked up a doc in Metalink and couldn't resolve my problem. Perhaps I > looked up the incorrect one. Please send me info if you will. > > Thank you. > Julia > > -Original Message- > Sent: Saturday, May 26, 2001 6:00 AM > To: Multiple recipients of list ORACLE-L > > dealt with that one this week on aix platform. > > a couple of things can cause it. > > 1. an upgrade or patch and then forget to run catalog, catproc, > catrep(if ur using replication), utlirp. > > 2. using a version of export that is not compatible with the > database(no one flame me for this, it was on metalink). > > if you want moer into on the error, let me know, i'll go and get the doc > id from metalink so you can look it up. > > joe > > "PHU,JULIA (HP-Sunnyvale,ex2)" wrote: > > > > Greetings, > > > > I'm lost on the 'ORA-00904: invalid column name' error message. Can > someone > > shed some light on it? It is 8i on NT box with sp6a. > > > > Regards, > > Julia Phu > > > > -- > Joe Testa http://www.oracle-dba.com > Performing Remote DBA Services, need some backup DBA support? > For Sale: Oracle-dba.com domain, its not going cheap but feel free to > ask:) > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joseph S. Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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: PHU,JULIA (HP-Sunnyvale,ex2) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
OTN Tracks?
Is there any particular advantage, other than the obvious (disk space, download speed, install from CD(s) vs install from hard drive, etc) to subscribing to an OTN track over either: 1) Downloading off of OTN ... or ... 2) Ordering the trial CDs from Oracle Store ? In particular, does software installed from OTN downloads or trial CDs actually expire after 30 days? (They didn't in the past, but its been a while...). How often are updates sent out? I am quite skeptical of paying $200 per OTN track. I was a victim of the now long defunct Oracle Developer Programme! After I paid $$$ for an ODP subscription, ODP just disappeared - no web site, telephone disconnected, etc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: historical data
Chris Spence was kind enough to mention PDQout in his response to this question and the debate since then seems to have revolved around whether exp/imp will still be around to reload archive data. There can be no debate with PDQout however. It creates flat files which can be reloaded with sqlldr (compare the speed of that with the speed of imp), or any other bulk loader. So you can be sure that you can reload into Oracle or into any other database, at any time in the future. Additionally, as PDQout makes use of the Oracle Call Interface, it can work across SQL*Net or download a view, saving a lot of processing when preparing data for a datamart. Sorry for the plug but what would you have done :-) Anyway to assuage your anger, you can get a FREE version of PDQout from our website, which will allow the downloading of tables of up to 250k rows. Oh! Just one thing, that version can't download views, we're not that stupid :-) Regards, Oriole Corporation, Oracle Performance Tools and Free Scripts Email: [EMAIL PROTECTED] Tel: +44 (0)20 7872 5480 Faxes: UK +44 (0)705 066 8661 US +1 240 526 5946 http://www.oriole.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oriole INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Oracle DBA Needed in Philly suburbs..
We are seeking candidates for a Financial Services company in the north Philadelphia suburbs that has an immediate need for an Oracle DBA who will be responsible for administering the Oracle databases and applications in a real-time environment. The selected candidate must know how to handle complexities of multiple databases, manage upgrades, and efficiencies. Duties will include,performanced tuning, operational monitoring, maintenance, backup and recovery, and troubleshooting. Very exciting project work going on. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. * Requirements: - Degree in C.S. or related field - 4+ yrs Oracle DBA experience - Unix (solaris preferred) - Perl and shell scripts (Korn shell preferred) - A thorough understanding of logical and physical modeling concepts - Parallel server,replication and or partitioning experience a plus - Excellent communications skills - Stable Job History - U.S. citizenship or permanent residency required This positions offer: * Stability * The opportunity to become a key member of the team. * 3 weeks vacation * Causal work environment * Base Salary D.O.E. * Excellent relocation package NO sub contracting positions available. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as an attachment to: OraStaff, Inc. Ph: 1-800-549-8502-Please do not call if you need sponsorship Email: [EMAIL PROTECTED] Please use job code: One/Philly/DBA/Nancy U. Note: This is only one of the many opportunities that we have available across the U.S. for candidates with Oracle skills who are U.S. citizens or permanent residents. So if this one is not a match for you, we invite you to send us your resume- as we quite possibly have the opportunity that you are seeking. We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).