IMPORT TIME IS HIGH
Hi Import is taking much time.How to eliminate that? Thanks -seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: IMPORT TIME IS HIGH
Seema Singh wrote: Hi Import is taking much time.How to eliminate that? Thanks -seema Check the paper by Paul Baumgartel in the library section of www.oriole.com -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Rama Velpuri's 9i Backup and Recovery Book Available?
Personally speaking I think that it is one of the best books available on Backup and Recovery.the case studies at the end of the boom r pure gems. I have the Oracle 8 edition and the concepts r very clearly explained esp. Media Recovery the concepts of which r still not very clear to many DBAs. Do get the book cos it is a sure keeper..I dont think there is a 9i Backup and Recovery book yet available. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 20 December 2001 19:31 To: Multiple recipients of list ORACLE-L Hello, One of the DBAs here thinks that it is ok, esp. if you need material on using RMAN (we do not). Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 20, 2001 1:10 PM To: Multiple recipients of list ORACLE-L I am thinking of buying Rama Velpuri's book, 'Oracle 8i Backup and Recovery'. Can anybody tell me if this is still considered to be one of the best Oracle Backup and Recovery books available? Before buying the 8i version of this book, can anybody tell me if there is a 9i book available? Or if there are plans to produce a 9i version of the book and when it might be available? Thanks, Sam. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma 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: Sherman, Paul R. 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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).
Merry Christmas
Hi everybody on the list !! Am going on my holidays today evening and shall b back in the New Year. Wish you all a merry and drunk (for some) Christmas and a very happy and database problem-free New Year !! Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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).
[no subject]
SET ORACLE_L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Blum, Marc 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:
Mark.u have to send the mail to [EMAIL PROTECTED] with the message SET ORACLE-L NOMAIL to temporarily suspend mail from the list. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 21 December 2001 10:05 To: Multiple recipients of list ORACLE-L SET ORACLE_L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Blum, Marc 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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).
Seasons Greeting
All, As I did the Christmas shift last year, I am off on my hols until January 2nd. No on call even. To all have a safe, happy and healthy Christmas and 2002. May we all look forward hopefully to a more united and secure world next year. Best Wishes from th UK Lee Off to post my nomail now. The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
program caused an invalid page fault in module ORACLIENT8.DLL at memory address
Hello Folks, I have installed oracle 8i client on a windows 98 system and am using an application that has the database in an NT server. At some point of testing the application i get the error message program caused an invalid page fault in module ORACLIENT8.DLL at memory address and the system (my windows 98 machine) crashes. What could be the possible reasons?? Please guide me. Thanking all in anticipation. Ranjit winmail.dat
Web Development Toolkit and memory per session
Hi, Some of our developers are using the Web Development Toolkit, and we now find that some sessions from the web site require 140M of memory or more. This is placing a strain on the backend server, memory usage for sessions adds up quickly. Is it normal for Web Toolkit connections to use up that much memory per session? [I am obviously just fishing for information...] Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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).
Num. of blocks multiple of 5?
Hi all!I have created tablespace where initial and next extents are same = 128KB.Block size is 4K.After creating test table and querying DBA_SEGMENTS, I see that new tableoccupies 35 blocks, instead of 32 blocks.Same happened with tablespace where initial = next = 256 and test tableoccupied 65 instead of 64 blocks.Why is this happening?Regards
Career Question ?
Doesanybody know any websites of Germanyor England related with Oracle jobs ?
Re: Merry Christmas
Wish u the same and everyone their family in the list a happy xmas and new year. Venkat -- On Fri, 21 Dec 2001 01:55:22 SARKAR, Samir wrote: Hi everybody on the list !! Am going on my holidays today evening and shall b back in the New Year. Wish you all a merry and drunk (for some) Christmas and a very happy and database problem-free New Year !! Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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). -- Click here for your very own create-a-date adventure from MatchMaker Go to http://ecard.matchmaker.com/dating.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: IMPORT TIME IS HIGH
in addition, define what you mean by much time -- how much data are you loading? how slow is the load actually? I've found that in general, an import takes about twice as long as the export. --- Stephane Faroult [EMAIL PROTECTED] wrote: Seema Singh wrote: Hi Import is taking much time.How to eliminate that? Thanks -seema Check the paper by Paul Baumgartel in the library section of www.oriole.com -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: recovery scenario - partial database - help
instead of stripping the other files from the controlfile, have you tried to use the original controlfile, mount the database and then offline drop the datafiles of the tablespaces you don't care about before you open the database? --- [EMAIL PROTECTED] wrote: OK we had some data deleted from our production database and reporting database that shouldn't have been deleted. We want to take from the most recent backup the 3 tablespaces affected by the delete and the system tablespace and restore those files to a temporary database with a backup controlfile so we can pull the data we need out. We have stripped the other files from the controlfile creation script. We are getting a 600 error when we attempt to create the controlfile - we have 2 DBAs here who have successfully completed this scenario in the past but we are stifled by the 600 error this time around. Oracle Support is saying we can't do this anymore in 8.1.7 we aren't so sure. Can anyone think of something we are missing?Anyone performed this operation before? Restoring from the full backup is an option but it is our last one due to the size and time required to do this. Oracle 8.1.7.0 AIX 4.3.3 Any and all help is welcomed - thanks! John Dailey Corporate Systems DBA ING Americas Atlanta, GA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: IMPORT TIME IS HIGH
You can't do much. I have two tables importing as I write that have been running since 2:30 yesterday afternoon and it is 7:00 in the AM. They have 16million rows each. But they have to put the rows in one row at a time. And I am importing them into a bigger, faster, better box, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 21, 2001 3:10 AM Hi Import is taking much time.How to eliminate that? Thanks -seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: Ruth Gramolini 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).
program caused an invalid page fault in module ORACLIENT8.DLL at memory address
Hello Folks, I have installed oracle 8i client on a windows 98 system and am using an application that has the database in an NT server. At some point of testing the application i get the error message program caused an invalid page fault in module ORACLIENT8.DLL at memory address and the system (my windows 98 machine) crashes. What could be the possible reasons?? Please guide me. Thanking all in anticipation. Ranjit __ Sent via the samtechindia.com WebMail Server -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranjit Sandhu 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: Trigger
Hamid, Change your trigger as follows: Create or replace trigger cre_PK before insert declare loc_seq number; begin select seqname.nextval into loc_seq from dual; insert into tableA(col1) values(loc_seq) end / Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, December 20, 2001 12:55 PM To: Multiple recipients of list ORACLE-L List, I need some help for creating a trigger, here is my question? I have a table TABLEA(col1,col2,col3) col1 is Primary Key for this table and an application insert records into this table, but I want to write a trigger on this table to generate primary key with using nexval of a sequence I have tried but doesn't work , if any of you have some sample or some links I really appreciate, This is my trigger: Create or replace trigger cre_PK before insert insert into tableA(col1) values(seqname.nextval) end Thanks in Advance Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Mercadante, Thomas F 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).
OT: Thanks for replies to locally managed tablespaces
Thanks for all the help I received, especially as this was my first posting. LMTs are now a separate, and definitely, tested, project for the future. From us here in Edinburgh, Scotland, have a peaceful Christmas and a memorable Hogmany! Heather -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Docherty, Heather 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: IMPORT TIME IS HIGH
Rachel Carmichael wrote: in addition, define what you mean by much time -- how much data are you loading? how slow is the load actually? I've found that in general, an import takes about twice as long as the export. Rachel, I don't know it's because of the festive season but I find you optimistic. I'd rather say 3 or 4 times as long as a conventional export. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: IMPORT TIME IS HIGH
There are some hints and tips about import speed on my site (see sig) - a little out of date but still mostly relevant. hth connor --- Ruth Gramolini [EMAIL PROTECTED] wrote: You can't do much. I have two tables importing as I write that have been running since 2:30 yesterday afternoon and it is 7:00 in the AM. They have 16million rows each. But they have to put the rows in one row at a time. And I am importing them into a bigger, faster, better box, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 21, 2001 3:10 AM Hi Import is taking much time.How to eliminate that? Thanks -seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: Ruth Gramolini 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
OT: Thanks for replies to locally managed tablespaces
Thanks for all the help I received, especially as this was my first posting. LMTs are now a separate, and definitely, tested, project for the future. From us here in Edinburgh, Scotland, have a peaceful Christmas and a memorable Hogmany! Heather -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Docherty, Heather 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: VNI-2015 LInux server / winNT station / Linux server
Joe; I already tried that, I went to my linux server, I installed the OMS, it's up and working, I discovered the node and the database, the agent dsnmp is working, I am logon as oracle, I created an account under the same name, with all the rights and roles available, I have the credentials set to this accounts for linux and oracle database user, and I am still getting the same thing And about the article from Mr. Raube (thanks for your time on this one), I have already tried that, I was login in as a local user, I set that account with all the rights from the windows user manager, and still the same problem. I am getting desperate with this problem, because I haven't backup my database and I don't want any unsuspected problems, please any other help would be greatly appreciate it. thanks in advance for your time and comments!! At 03:25 PM 12/20/01 -0800, you wrote: leave windows and go to unix. joe Joe Raube wrote: I searched OTN and found this: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/em.817/a85247/ch6.htm Note: The Windows NT or Windows 2000 Domain User works only if the machine is a primary domain controller (PDC); otherwise, jobs will fail with VNI-2015 authentication error. In all non-PDC environments the account must be local to the machine. -Joe At 01:31 PM 12/20/01 -0800, you wrote: I have a Linux server running Oracle Standart 8I, I already setup the init file with the exclusive value to accept backup jobs, I also created a special account with sysdba, sysoper, and dba rights and a linux account same name password and with all rights to sysoper, sysdba and root groups. On the nt side I have the same account local and in the domain both with the log on as batch logs from the advance rights, same password, administrator rights for both, I also have the same name and password unde the OEM as a manager with superuser rights, and I have set the preferences for default node and linux node with the same name, even the service for the database is the same as sysdba, and still when I try to send a job, I get this VNI-2015 and the job reports failed, I even created a file with the orapwd with the same account name and the password. So if somebody could give a couple of ideas, out of this, I will appreciate it, I have read all of the messages and I tried all, I have no more ideas, I thanks for your help and time on this one in advance. Jose -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: tomas 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, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe 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: tomas 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 on AIX performance issue
Oracle 8.1.7 on AIX. Our database is rapidly expanding. Now it's approximately 80GB and for few months it's going to be at least double of that size. We are planning some reorganizations, so I'm wondering could you give me some advice. Is it better to have several big file systems or lot of smaller? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= 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).
Move DB to Another Schema
I can't find any details of this in any of my documentation. I originally created my DB as SYS. I have setup a new user and need to move my DB / Tables, etc. to the new schema. How do I go about this? Can I do it via SQL Plus or do I need to do it via svrmgr? Or, would it just be easier to create a new DB (DDL SQL script) as the new user? Thanks, Ken Janusz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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).
Little OT: CLOB, Oracle Text, and ADO
Hello It may be little OT but I am sure there are developers here. Also I hope some DBAs may know the answer... I am experimenting with Oracle Text - need to use the field from a VB application. I have a table with a CLOB column and a ctxcat index built on that column. If I insert records using SQL Plus, TOAD, or similar tool, the index is automatically updated so my query: select note_oid from lrmi_note where catsearch(note_data, 'SomeValue', null) 0; returns records matching the condition. In the application - if I use ADODB.Connection with parameters and execute my insert, the data is written, index automatically updated, and my query returns matching records. But if I use ADODB.Recordset to write the record, the data is written but the index doesn't get updated. If I open SQL Plus and run: select * from lrmi_note where note_oid = my_new_oid; it shows me the record with the CLOB column filled. But if I query the CLOB column using catsearch(), it doesn't return the record. If I rebuild the index, the query with catsearch() will return the records. But one of the reasons to use ctxcat indes is that it is updated with each transaction... While it may be specific to ADO I wonder if some Oracle gurus know, or can direct to some info, why Oracle doesn't update the ctxcat index even though the record is written and apears correctly. Witold== Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec 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: Num. of blocks multiple of 5?
This has been the documented behavior for non-LMT for quite a while. From the storage clause section of the SQL Reference Manual "Oracle rounds values up to the next multiple of the data block size for values less than 5 data blocks, and rounds up to the next multiple of 5 data blocks for values greater than 5 data blocks." Matt Adams - GE Appliances - [EMAIL PROTECTED]The thrill is gone - B. B. KingIf the thrill is gone, then it's time to take it back. - Meatloaf -Original Message-From: Vladimir Barac - posao [mailto:[EMAIL PROTECTED]]Sent: Friday, December 21, 2001 6:55 AMTo: Multiple recipients of list ORACLE-LSubject: Num. of blocks multiple of 5?Hi all!I have created tablespace where initial and next extents are same = 128KB.Block size is 4K.After creating test table and querying DBA_SEGMENTS, I see that new tableoccupies 35 blocks, instead of 32 blocks.Same happened with tablespace where initial = next = 256 and test tableoccupied 65 instead of 64 blocks.Why is this happening?Regards
Re: IMPORT TIME IS HIGH
well, yeah, depending on the number of indexes, I've seen a 6 hour export take almost 24 hours to import -- on the same box as the export was done. I was trying not to frighten anyone :) --- Stephane Faroult [EMAIL PROTECTED] wrote: Rachel Carmichael wrote: in addition, define what you mean by much time -- how much data are you loading? how slow is the load actually? I've found that in general, an import takes about twice as long as the export. Rachel, I don't know it's because of the festive season but I find you optimistic. I'd rather say 3 or 4 times as long as a conventional export. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Move DB to Another Schema
Ken. After creating the user, you can use export to move the tables one at a time. You will need to specify the owner of the table on the export (ie: SYS.table name) and then on the import you will say FROMUSER=SYS TOUSER=xxx on the command line. I would suggest examining the Utilities guide for additional information. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Friday, December 21, 2001 9:55 AM To: Multiple recipients of list ORACLE-L Subject:Move DB to Another Schema I can't find any details of this in any of my documentation. I originally created my DB as SYS. I have setup a new user and need to move my DB / Tables, etc. to the new schema. How do I go about this? Can I do it via SQL Plus or do I need to do it via svrmgr? Or, would it just be easier to create a new DB (DDL SQL script) as the new user? Thanks, Ken Janusz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: Karniotis, Stephen 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: Move DB to Another Schema
Ken Janusz wrote: I can't find any details of this in any of my documentation. I originally created my DB as SYS. I have setup a new user and need to move my DB / Tables, etc. to the new schema. How do I go about this? Can I do it via SQL Plus or do I need to do it via svrmgr? Or, would it just be easier to create a new DB (DDL SQL script) as the new user? Thanks, Ken Janusz -- Ooops. Simplest thing is to create a parameter file starting with TABLES= and listing all the tables you created at the wrong place, export, and then import using FROMUSER=SYS TOUSER=whomever. Then cleanup the SYS account but VERY VERY CAREFULLY. When you create the other account, first do not give it the RESOURCE privilege (or revoke UNLIMITED TABLESPACE immediately afterwards), but give it unlimited quota on two tablespaces, one for tables and one for indexes, and set the tablespace for tables as the default tablespace. You will have to ALTER INDEX ... REBUILD TABLESPACE tablespace for indexes on all indexes afterwards. Sequences, views, synonyms etc. will have to bre recreated manually. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Move DB to Another Schema
Ken, Do a full export as user sys.Then create a new userid to act as the owner of those non-sys and non-system tables. Do an alter user owner_of_tables default tablespace tablespace_for_application_tables; Do an import of the application tables using the table (or tables - I can't remember) option of the imp command. You probably will need to use fromuser=SYS touser=owner_of_tables as well. From the unix operating system prompt you can use the exp help=y and imp help=y commands to get help on the syntax for export and import. The Server Utilities User's Guide has lots of text and examples for export and import. You can also query Metalink for something moving tables from one schema to another using export and import. There should be a few notes in there outlining the exact steps to use. Cherie Ken Janusz ken.janusz@su To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fsys.comcc: Sent by: Subject: Move DB to Another Schema [EMAIL PROTECTED] om 12/21/01 08:55 AM Please respond to ORACLE-L I can't find any details of this in any of my documentation. I originally created my DB as SYS. I have setup a new user and need to move my DB / Tables, etc. to the new schema. How do I go about this? Can I do it via SQL Plus or do I need to do it via svrmgr? Or, would it just be easier to create a new DB (DDL SQL script) as the new user? Thanks, Ken Janusz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: 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: Move DB to Another Schema
Ken, Get rid of the SYS-owned tables that you created, and create a new tablespace, under which you can create your schema's objects. Do not try and export/import. Those tables have no business being in SYS tablespace. Carefully, drop them. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Friday, December 21, 2001 9:55 AM To: Multiple recipients of list ORACLE-L I can't find any details of this in any of my documentation. I originally created my DB as SYS. I have setup a new user and need to move my DB / Tables, etc. to the new schema. How do I go about this? Can I do it via SQL Plus or do I need to do it via svrmgr? Or, would it just be easier to create a new DB (DDL SQL script) as the new user? Thanks, Ken Janusz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: Sherman, Paul R. 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: IMPORT TIME IS HIGH
Everyone needs to remember that the Oracle Import Utility is just a 3GL C program with INSERT statements. It is widely publicized that the ratio is 1:4 so this should not come as a surprise to anyone. Some ways to improve performance is to use a large buffer size (10-20M) and set COMMIT=Y to facilitate array inserts. There are OS options for improving the I/O bandwidth on the file, but that's really it. Rachel is correct. She did not want to frighten anyone. Now the good news is with Oracle9i, Oracle has added Array Inserts to the tool so this may help. How many of us remember when Oracle claimed that EXP/IMP were to go away in 8i Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Friday, December 21, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Subject:Re: IMPORT TIME IS HIGH well, yeah, depending on the number of indexes, I've seen a 6 hour export take almost 24 hours to import -- on the same box as the export was done. I was trying not to frighten anyone :) --- Stephane Faroult [EMAIL PROTECTED] wrote: Rachel Carmichael wrote: in addition, define what you mean by much time -- how much data are you loading? how slow is the load actually? I've found that in general, an import takes about twice as long as the export. Rachel, I don't know it's because of the festive season but I find you optimistic. I'd rather say 3 or 4 times as long as a conventional export. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Karniotis, Stephen 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: Move DB to Another Schema
What about moving all the tables at one time (FULL=Y)? I have about 150 just for the application. And another bunch for the DB. -Original Message- Sent: Friday, December 21, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Subject:RE: Move DB to Another Schema Ken. After creating the user, you can use export to move the tables one at a time. You will need to specify the owner of the table on the export (ie: SYS.table name) and then on the import you will say FROMUSER=SYS TOUSER=xxx on the command line. I would suggest examining the Utilities guide for additional information. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Friday, December 21, 2001 9:55 AM To: Multiple recipients of list ORACLE-L Subject:Move DB to Another Schema I can't find any details of this in any of my documentation. I originally created my DB as SYS. I have setup a new user and need to move my DB / Tables, etc. to the new schema. How do I go about this? Can I do it via SQL Plus or do I need to do it via svrmgr? Or, would it just be easier to create a new DB (DDL SQL script) as the new user? Thanks, Ken Janusz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: Karniotis, Stephen 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: Ken Janusz 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: Move DB to Another Schema
export the tables and import them to the new user --- Ken Janusz [EMAIL PROTECTED] wrote: I can't find any details of this in any of my documentation. I originally created my DB as SYS. I have setup a new user and need to move my DB / Tables, etc. to the new schema. How do I go about this? Can I do it via SQL Plus or do I need to do it via svrmgr? Or, would it just be easier to create a new DB (DDL SQL script) as the new user? Thanks, Ken Janusz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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). __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Move DB to Another Schema
1 - never create objects as SYS 2 - svrmgr is gone in 9i - stop using it I would drop all user objects that you created as SYS, and recreate using a DDL script. -Joe At 06:55 AM 12/21/01 -0800, you wrote: I can't find any details of this in any of my documentation. I originally created my DB as SYS. I have setup a new user and need to move my DB / Tables, etc. to the new schema. How do I go about this? Can I do it via SQL Plus or do I need to do it via svrmgr? Or, would it just be easier to create a new DB (DDL SQL script) as the new user? Thanks, Ken Janusz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: Joe Raube 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: IMPORT TIME IS HIGH
and svrmgr was going in 8i too... took them until 9i oh, and of course, my personal favorite (this has been said since 7) you won't need a DBA anymore --- Karniotis, Stephen [EMAIL PROTECTED] wrote: Everyone needs to remember that the Oracle Import Utility is just a 3GL C program with INSERT statements. It is widely publicized that the ratio is 1:4 so this should not come as a surprise to anyone. Some ways to improve performance is to use a large buffer size (10-20M) and set COMMIT=Y to facilitate array inserts. There are OS options for improving the I/O bandwidth on the file, but that's really it. Rachel is correct. She did not want to frighten anyone. Now the good news is with Oracle9i, Oracle has added Array Inserts to the tool so this may help. How many of us remember when Oracle claimed that EXP/IMP were to go away in 8i Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email:[EMAIL PROTECTED] Web: www.compuware.com -Original Message- Sent: Friday, December 21, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Subject: Re: IMPORT TIME IS HIGH well, yeah, depending on the number of indexes, I've seen a 6 hour export take almost 24 hours to import -- on the same box as the export was done. I was trying not to frighten anyone :) --- Stephane Faroult [EMAIL PROTECTED] wrote: Rachel Carmichael wrote: in addition, define what you mean by much time -- how much data are you loading? how slow is the load actually? I've found that in general, an import takes about twice as long as the export. Rachel, I don't know it's because of the festive season but I find you optimistic. I'd rather say 3 or 4 times as long as a conventional export. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Karniotis, Stephen 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). __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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
RE: Excessive Paging - AIX Related?
Mount the file system that holds your temporary tablespace in Direct mode (non-buffered mode) and try to find if AIX has something similar to the priority paging in Solaris. Also Raw partitions are good at least (in your case) for temporary tablespace. Also check if your tablespace is defined as temporary. Regards, Waleed -Original Message- Sent: Thursday, December 20, 2001 6:10 PM To: Multiple recipients of list ORACLE-L I am resolved that the trouble is not enough swap and not enough aio processes. I think this will significantly improve the system. Spreading swap will be my next push if I still have trouble. vmtune will be last which is basically what I wanted to confirm. AIX vmstat shows kthr memory page faultscpu - --- --- r b avm fre re pi po fr sr cy in sy cs us sy id wa 0 0 522715 4737 0 1 1 39 115 0 147 440 151 3 1 92 3 0 2 522715 4646 0 0 0 00 0 522 1169 133 3 4 91 2 0 2 522715 4646 0 0 0 00 0 472 564 60 0 0 99 0 However topas shows more info about where the pageing is occuring i.e. good/normal paging as oposed to bad paging as seen below. PgspIn and PgspOut are the bad kind. Topas Monitor for host:FOO EVENTS/QUEUESFILE/TTY Thu Dec 20 18:10:02 2001 Interval: 2 Cswitch2625 Readch 11505467 Syscall 40623 Writech 883896 Kernel 42.7 || Reads 5506 Rawin 0 User 13.1 || Writes 514 Ttyout 318 Wait 9.3 |### | Forks 179 Igets 9 Idle 34.7 |## | Execs 177 Namei 6369 Runqueue7.5 Dirblk 49 Interf KBPS I-Pack O-Pack KB-In KB-Out Waitqueue 2.0 en19.425.916.9 3.1 6.3 en01.410.9 3.9 0.9 0.5 PAGING MEMORY Faults30366 Real,MB 4095 DiskBusy% KBPS TPS KB-Read KB-Writ Steals0 % Comp 39.2 hdisk0 47.4574.792.3 9.9 564.8 PgspIn2 % Noncomp 61.4 hdisk1 41.9572.889.8 0.0 572.8 PgspOut 0 % Client 348 hdisk31.4337.310.4 0.0 337.3 PageIn 66 2 0992 hdisk10 0.0 0.0 0.0 0.0 0.0 PageOut 229 PAGING SPACE hdisk40.0 3.9 0.4 0.0 3.9 Sios118 Size,MB 2992 % Used 22.3 dm_ep_eng(11094) 12.5% PgSp: 1.0mb root % Free 77.6 init (1) 6.0% PgSp: 0.6mb root ksh (35124) 5.0% PgSp: 0.3mb oracle ksh (15854) 4.0010.0.4mb oracle4 Press h for help screen. ksh (68298) 4.05 PgSp: 0.3mb oracle5 Press q to quit program. sadc (59690) 3.0% PgSp: 0.1mb root ksh (53722) 3.0% PgSp: 0.3mb oracle ksh (63038) 2.0% PgSp: 0.3mb oracle ksh (27478) 2.0% PgSp: 0.3mb oracle ksh (61336) 2.0% PgSp: 0.3mb oracle -Original Message- Sent: Thursday, December 20, 2001 3:40 PM To: Multiple recipients of list ORACLE-L Ethan, AIX performs all file i/o via the OS's virtual memory. In other words, the VM (which is a combination of both the RAM and the Swap) is used for both executable (OS/user code) and user's memory area as well as for I/O buffers. This allocation is dynamic and certain upper and lower limits are set by the parameters in vmtune. At times of high i/o, you will find that the 'fre' mem (seen in vmstat' goes down drastically and the po/fr/sr goes up drastically as a result of old memory pages that served file i/o buffers are paged out. This is normal and in line with what you are observing and is similar to Solaris. What you *should* be concerned about is excessive values in 'pi' as this indicates excessive paging-*in*, probably due to earlier pageouts of live pages that are still required. You are probably seeing high I/o waits since there is a lot of writes (paging out) to the swap area. 'iostat' will probably indicate that disks that host your swap area are almost 100% loaded. In this case, you should make sure that you (a) spread out swap on multiple disks, making sure that they are NOT on RAID-5. (b) allocate dedicated drives to swap areas if possible (no RAID5!). FWIW, vmstat in Solaris is able to distinguish between pi/po values for executable, file i/o and 'other' (?) types of paging. Can you find out for us if AIX also provides this? (Don't have access to an AIX box). Merry Christmas and a Blessed New Year! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services--
Using Designer/6i to reverse engineer entity relationship diagrams from
We have an existing Server Model within Designer/6i. Is there an easy way to reverse engineer an entity model from the server model? I am looking at OTN and can't figure out where the Designer/6i users guides, etc. are. All I can find are the installation guide, Configuration guide, migration manual, etc. Anybody know where I can find the documentation that tells me how to use the 6/i tool once I get it installed? Thanks, Cherie Machler -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
SNAPSHOTS vs MATERIALIZE VIEWS
Oracle 8.1.6.0 We're trying to recreate our snapshots. We used the syntax 'CREATE SNAPSHOT'. The snapshots won't refresh. Error message is ORA-12018. Everyone's gone for Christmas with their office's locked (documentation inside!) and the internet connection is down. So 'R'ing TFM is out of the question. Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Web Development Toolkit and memory per session
Patrice, How are you determining that a session is require 140M? This number may be misleading. Jared Boivin, Patrice J To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: mpo.gc.ca Subject: Web Development Toolkit and memory per session Sent by: [EMAIL PROTECTED] 12/21/01 03:45 AM Please respond to ORACLE-L Hi, Some of our developers are using the Web Development Toolkit, and we now find that some sessions from the web site require 140M of memory or more. This is placing a strain on the backend server, memory usage for sessions adds up quickly. Is it normal for Web Toolkit connections to use up that much memory per session? [I am obviously just fishing for information...] Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: 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: Little OT: CLOB, Oracle Text, and ADO
My experience with intermedia or context server, or whatever they call it this week, is in dealing with iFS, so I know just enough to be dangerous. :) It sounds like you need to have the context server running to periodically update the indexes. On unix it's 'ctxsrv'. I suggest you read the docs on this and do a search on metalink, there is some helpful information there. HTH Jared Witold Iwaniec wiwaniec@novali To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] stech.com cc: Sent by: Subject: Little OT: CLOB, Oracle Text, and ADO [EMAIL PROTECTED] 12/21/01 07:15 AM Please respond to ORACLE-L Hello It may be little OT but I am sure there are developers here. Also I hope some DBAs may know the answer... I am experimenting with Oracle Text - need to use the field from a VB application. I have a table with a CLOB column and a ctxcat index built on that column. If I insert records using SQL Plus, TOAD, or similar tool, the index is automatically updated so my query: select note_oid from lrmi_note where catsearch(note_data, 'SomeValue', null) 0; returns records matching the condition. In the application - if I use ADODB.Connection with parameters and execute my insert, the data is written, index automatically updated, and my query returns matching records. But if I use ADODB.Recordset to write the record, the data is written but the index doesn't get updated. If I open SQL Plus and run: select * from lrmi_note where note_oid = my_new_oid; it shows me the record with the CLOB column filled. But if I query the CLOB column using catsearch(), it doesn't return the record. If I rebuild the index, the query with catsearch() will return the records. But one of the reasons to use ctxcat indes is that it is updated with each transaction... While it may be specific to ADO I wonder if some Oracle gurus know, or can direct to some info, why Oracle doesn't update the ctxcat index even though the record is written and apears correctly. Witold== Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec 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: 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).
Ignore my question about SNAPSHOTS and MATERIALIZED VIEWS
There were other problems which were masquerading as a refresh problem. Merry Christmas and Happy New Year to all. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: IMPORT TIME IS HIGH
oh, and of course, my personal favorite (this has been said since 7) you won't need a DBA anymore And just who would hold the duhvelopers hands then? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: SNAPSHOTS vs MATERIALIZE VIEWS
Your internet connection is down? How are you reading this? Jared [EMAIL PROTECTED] Sent by: To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: om Subject: SNAPSHOTS vs MATERIALIZE VIEWS 12/21/01 09:25 AM Please respond to ORACLE-L Oracle 8.1.6.0 We're trying to recreate our snapshots. We used the syntax 'CREATE SNAPSHOT'. The snapshots won't refresh. Error message is ORA-12018. Everyone's gone for Christmas with their office's locked (documentation inside!) and the internet connection is down. So 'R'ing TFM is out of the question. Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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: Little OT: CLOB, Oracle Text, and ADO
Ctxserv has been deprecated. Check the directory $ORACLE_HOME/ctx/sample/script for the approved ways of keeping the indexes in synch. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, December 21, 2001 9:41 AM To: Multiple recipients of list ORACLE-L My experience with intermedia or context server, or whatever they call it this week, is in dealing with iFS, so I know just enough to be dangerous. :) It sounds like you need to have the context server running to periodically update the indexes. On unix it's 'ctxsrv'. I suggest you read the docs on this and do a search on metalink, there is some helpful information there. HTH Jared Witold Iwaniec wiwaniec@novali To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] stech.com cc: Sent by: Subject: Little OT: CLOB, Oracle Text, and ADO [EMAIL PROTECTED] 12/21/01 07:15 AM Please respond to ORACLE-L Hello It may be little OT but I am sure there are developers here. Also I hope some DBAs may know the answer... I am experimenting with Oracle Text - need to use the field from a VB application. I have a table with a CLOB column and a ctxcat index built on that column. If I insert records using SQL Plus, TOAD, or similar tool, the index is automatically updated so my query: select note_oid from lrmi_note where catsearch(note_data, 'SomeValue', null) 0; returns records matching the condition. In the application - if I use ADODB.Connection with parameters and execute my insert, the data is written, index automatically updated, and my query returns matching records. But if I use ADODB.Recordset to write the record, the data is written but the index doesn't get updated. If I open SQL Plus and run: select * from lrmi_note where note_oid = my_new_oid; it shows me the record with the CLOB column filled. But if I query the CLOB column using catsearch(), it doesn't return the record. If I rebuild the index, the query with catsearch() will return the records. But one of the reasons to use ctxcat indes is that it is updated with each transaction... While it may be specific to ADO I wonder if some Oracle gurus know, or can direct to some info, why Oracle doesn't update the ctxcat index even though the record is written and apears correctly. Witold== Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec 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: 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
RE: SNAPSHOTS vs MATERIALIZE VIEWS
I believe you will need to CREATE OR REPLACE SNAPSHOT or drop and then recreate it. Before dropping it, look at the view DBA_SNAPSHOTS for the contents of the snapshot. Secondly, you can, within SQL*Plus, type HELP SNAPSHOT, and get some syntactical help with the commands. Otherwise, you will need some on-line documentation. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Friday, December 21, 2001 12:25 PM To: Multiple recipients of list ORACLE-L Subject:SNAPSHOTS vs MATERIALIZE VIEWS Oracle 8.1.6.0 We're trying to recreate our snapshots. We used the syntax 'CREATE SNAPSHOT'. The snapshots won't refresh. Error message is ORA-12018. Everyone's gone for Christmas with their office's locked (documentation inside!) and the internet connection is down. So 'R'ing TFM is out of the question. Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Karniotis, Stephen 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: free buffer waits DISK I/O
Is it just me, or is something wrong with this site? I would love to see a copy of this paper. When I go to this url and click on the session search, I get an error document 404. Is there another way to get to the open world papers?? Thanks. Barb -- From: Post, Ethan[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Monday, December 17, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: free buffer waits DISK I/O Can't answer your question but sounds like you might benefit from reading Gaja Krishna Vaidyanatha's paper (Tuning Oracle Without Cache Hit Ratios) at the Open World site (http://www.oracle.com/openworld/us/conference) or reading Oracle Tuning 101 (book) by the same author. Sounds like you had a problem and immediatly threw memory at it as opposed to working to identify the SQL that was actually causing the problem. You saw a small improvement but not as much as you hoped. This is exactly the type of thing Gaja talks about in the papers and books. - Ethan -Original Message- Sent: Monday, December 17, 2001 3:55 PM To: Multiple recipients of list ORACLE-L HI list. I was tuning a database (Oracle 7.3.4) that was waiting for free buffer waits mostly. I tuned DBWn batch size properly (increased it till 4MB) as well as buffer cache size (it's 600MB now) too and I got some improvement but I didn't get a major improvement. But some weeks ago, when we changed the disk array (from one symmetrix to another) and made an appropiate disk distribution (to eliminate contention), free buffer waits went down (almost desappeared). We didn't change anything else. I noticed that the avg db file parallel write changed from 150ms to 30ms. Can someone explain me why free buffer waits dissapeared? TIA ___ Do You Yahoo!? Yahoo! Messenger Comunicación instantánea gratis con tu gente. http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20ksksksk?= 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: Post, Ethan 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: Baker, Barbara 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: Little OT: CLOB, Oracle Text, and ADO
Thanks Jared I understood that ctxsrv affects the index of type ctxsys.context only while the ctxsys.ctxcat gets updated with transactions but certainly will do some more reading... Witold My experience with intermedia or context server, or whatever they call it this week, is in dealing with iFS, so I know just enough to be dangerous. :) It sounds like you need to have the context server running to periodically update the indexes. On unix it's 'ctxsrv'. I suggest you read the docs on this and do a search on metalink, there is some helpful information there. HTH Jared Witold Iwaniec wiwaniec@novali To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] stech.com cc: Sent by: Subject: Little OT: CLOB, Oracle Text, and ADO [EMAIL PROTECTED] 12/21/01 07:15 AM Please respond to ORACLE-L Hello It may be little OT but I am sure there are developers here. Also I hope some DBAs may know the answer... I am experimenting with Oracle Text - need to use the field from a VB application. I have a table with a CLOB column and a ctxcat index built on that column. If I insert records using SQL Plus, TOAD, or similar tool, the index is automatically updated so my query: select note_oid from lrmi_note where catsearch(note_data, 'SomeValue', null) 0; returns records matching the condition. In the application - if I use ADODB.Connection with parameters and execute my insert, the data is written, index automatically updated, and my query returns matching records. But if I use ADODB.Recordset to write the record, the data is written but the index doesn't get updated. If I open SQL Plus and run: select * from lrmi_note where note_oid = my_new_oid; it shows me the record with the CLOB column filled. But if I query the CLOB column using catsearch(), it doesn't return the record. If I rebuild the index, the query with catsearch() will return the records. But one of the reasons to use ctxcat indes is that it is updated with each transaction... While it may be specific to ADO I wonder if some Oracle gurus know, or can direct to some info, why Oracle doesn't update the ctxcat index even though the record is written and apears correctly. Witold== Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec 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: Witold Iwaniec 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
Re: VNI-2015 LInux server / winNT station / Linux server
Guys!!! I found the problem, you just needed to change the ownership of the dbsnmp file from root to oracle, after that everything is working!!! thanks to the people who took of their time on this one. Jose At 06:05 AM 12/21/01 -0800, you wrote: Joe; I already tried that, I went to my linux server, I installed the OMS, it's up and working, I discovered the node and the database, the agent dsnmp is working, I am logon as oracle, I created an account under the same name, with all the rights and roles available, I have the credentials set to this accounts for linux and oracle database user, and I am still getting the same thing And about the article from Mr. Raube (thanks for your time on this one), I have already tried that, I was login in as a local user, I set that account with all the rights from the windows user manager, and still the same problem. I am getting desperate with this problem, because I haven't backup my database and I don't want any unsuspected problems, please any other help would be greatly appreciate it. thanks in advance for your time and comments!! At 03:25 PM 12/20/01 -0800, you wrote: leave windows and go to unix. joe Joe Raube wrote: I searched OTN and found this: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/em.817/a85247/ch6.htm Note: The Windows NT or Windows 2000 Domain User works only if the machine is a primary domain controller (PDC); otherwise, jobs will fail with VNI-2015 authentication error. In all non-PDC environments the account must be local to the machine. -Joe At 01:31 PM 12/20/01 -0800, you wrote: I have a Linux server running Oracle Standart 8I, I already setup the init file with the exclusive value to accept backup jobs, I also created a special account with sysdba, sysoper, and dba rights and a linux account same name password and with all rights to sysoper, sysdba and root groups. On the nt side I have the same account local and in the domain both with the log on as batch logs from the advance rights, same password, administrator rights for both, I also have the same name and password unde the OEM as a manager with superuser rights, and I have set the preferences for default node and linux node with the same name, even the service for the database is the same as sysdba, and still when I try to send a job, I get this VNI-2015 and the job reports failed, I even created a file with the orapwd with the same account name and the password. So if somebody could give a couple of ideas, out of this, I will appreciate it, I have read all of the messages and I tried all, I have no more ideas, I thanks for your help and time on this one in advance. Jose -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: tomas 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, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe 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: tomas 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: tomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858)
RE: Move DB to Another Schema
Ken, You can use a tables= option to list all the tables you want exported. And then use the fromuser= and touser= option to import them (to the right tablespace). Also, please remember that there is an upper limit on the number of characters in the tables= list. I can't remember the exact number, may be some one else can. (I think it is 2k or so). If this becomes a limitation, just export/impot a little less number of tables at a time. Good Luck. - Kirti -Original Message- Sent: Friday, December 21, 2001 11:30 AM To: Multiple recipients of list ORACLE-L If you move with FULL=Y, you will move the entire database. Because you have placed objects in SYS, in violation of general DBA guidelines, you have forced this upon yourself. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Friday, December 21, 2001 11:35 AM To: Multiple recipients of list ORACLE-L Subject:RE: Move DB to Another Schema What about moving all the tables at one time (FULL=Y)? I have about 150 just for the application. And another bunch for the DB. -Original Message- Sent: Friday, December 21, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Subject:RE: Move DB to Another Schema Ken. After creating the user, you can use export to move the tables one at a time. You will need to specify the owner of the table on the export (ie: SYS.table name) and then on the import you will say FROMUSER=SYS TOUSER=xxx on the command line. I would suggest examining the Utilities guide for additional information. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Friday, December 21, 2001 9:55 AM To: Multiple recipients of list ORACLE-L Subject:Move DB to Another Schema I can't find any details of this in any of my documentation. I originally created my DB as SYS. I have setup a new user and need to move my DB / Tables, etc. to the new schema. How do I go about this? Can I do it via SQL Plus or do I need to do it via svrmgr? Or, would it just be easier to create a new DB (DDL SQL script) as the new user? Thanks, Ken Janusz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: Karniotis, Stephen 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: Ken Janusz 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: Karniotis, Stephen 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
RE: Little OT: CLOB, Oracle Text, and ADO
Thanks for the reply I have tried ctx_ddl.sync_index() but it can be used to synchronize ctxsys.context indexes only. In my case it is ctxsys.ctxcat index. Since it gets updated properly when I use few different ways to insert records I believe it is something specific to the way ADODB.Recordset modifies database. The index gets updated properly when I run, in any way, an INSERT statement. I guess the ADODB.Recordset works on a different level. It may be something similar to differences in loading data with SQL Loader using conventional load and direct load - issuing INSERT statements vs. writing directly to the table. It is just a guess... Witold On 21 Dec 2001 at 10:00, MacGregor, Ian A. wrote: Ctxserv has been deprecated. Check the directory $ORACLE_HOME/ctx/sample/script for the approved ways of keeping the indexes in synch. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, December 21, 2001 9:41 AM To: Multiple recipients of list ORACLE-L My experience with intermedia or context server, or whatever they call it this week, is in dealing with iFS, so I know just enough to be dangerous. :) It sounds like you need to have the context server running to periodically update the indexes. On unix it's 'ctxsrv'. I suggest you read the docs on this and do a search on metalink, there is some helpful information there. HTH Jared Witold Iwaniec wiwaniec@novali To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] stech.com cc: Sent by: Subject: Little OT: CLOB, Oracle Text, and ADO [EMAIL PROTECTED] 12/21/01 07:15 AM Please respond to ORACLE-L Hello It may be little OT but I am sure there are developers here. Also I hope some DBAs may know the answer... I am experimenting with Oracle Text - need to use the field from a VB application. I have a table with a CLOB column and a ctxcat index built on that column. If I insert records using SQL Plus, TOAD, or similar tool, the index is automatically updated so my query: select note_oid from lrmi_note where catsearch(note_data, 'SomeValue', null) 0; returns records matching the condition. In the application - if I use ADODB.Connection with parameters and execute my insert, the data is written, index automatically updated, and my query returns matching records. But if I use ADODB.Recordset to write the record, the data is written but the index doesn't get updated. If I open SQL Plus and run: select * from lrmi_note where note_oid = my_new_oid; it shows me the record with the CLOB column filled. But if I query the CLOB column using catsearch(), it doesn't return the record. If I rebuild the index, the query with catsearch() will return the records. But one of the reasons to use ctxcat indes is that it is updated with each transaction... While it may be specific to ADO I wonder if some Oracle gurus know, or can direct to some info, why Oracle doesn't update the ctxcat index even though the record is written and apears correctly. Witold== Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Web Development Toolkit and memory per session
Ps -efl on Tru64 UNIX. e.g. 88008001 R 9001 1931 1 19.2 44 0 149M -16:52:15 03:59:11 oraclesid (LOCAL=NO) 88008001 R 9001 10017 1 17.0 44 0 146M -10:19:45 04:36:09 oraclesid (LOCAL=NO) 88008001 R 9001 10732 1 16.9 44 0 144M -10:19:44 04:23:29 oraclesid (LOCAL=NO) 88008001 R 9001 14278 1 19.2 44 0 157M -17:35:21 03:56:01 oraclesid (LOCAL=NO) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, December 21, 2001 1:36 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject:Re: Web Development Toolkit and memory per session Patrice, How are you determining that a session is require 140M? This number may be misleading. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: Move DB to Another Schema
Ken, SYS objects are NOT exported since an import of SYS would basically then import database metadata. The only method is to create another schema (not SYSTEM!) and move these tables into the new schema using a series of CTAS. If you have the DDL scripts, then run them against the new user rather than SYS (did you run them using SVRMGRL connected as INTERNAL before?) Hope everything goes well with you and the family this Christmas season! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Wanna know the reason for the season? Click on 'http://www.needhim.org' ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Ken Janusz [mailto:[EMAIL PROTECTED]] Sent: Friday, December 21, 2001 8:35 AM To: Multiple recipients of list ORACLE-L Subject: RE: Move DB to Another Schema What about moving all the tables at one time (FULL=Y)? I have about 150 just for the application. And another bunch for the DB. -Original Message- Sent: Friday, December 21, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Move DB to Another Schema Ken. After creating the user, you can use export to move the tables one at a time. You will need to specify the owner of the table on the export (ie: SYS.table name) and then on the import you will say FROMUSER=SYS TOUSER=xxx on the command line. I would suggest examining the Utilities guide for additional information. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email:[EMAIL PROTECTED] Web: www.compuware.com -Original Message- Sent: Friday, December 21, 2001 9:55 AM To: Multiple recipients of list ORACLE-L Subject: Move DB to Another Schema I can't find any details of this in any of my documentation. I originally created my DB as SYS. I have setup a new user and need to move my DB / Tables, etc. to the new schema. How do I go about this? Can I do it via SQL Plus or do I need to do it via svrmgr? Or, would it just be easier to create a new DB (DDL SQL script) as the new user? Thanks, Ken Janusz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: Karniotis, Stephen 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: Ken Janusz 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: John Kanagaraj 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).
Merry Christmas
List, I wish all of you a merry christmas and happy new year. You guys are great help for the beginners, like me. Thanks all of you !!! Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121
RE: Web Development Toolkit and memory per session
Patrice, I am not sure anout Tru64, but I believe these values include the SGA. Of so, you will have to use something equivalent to 'pmem' in Solaris to identify shared portions of SGA/executables and figure out the per session requirement. Merry Christmas and a Blessed New year! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Wanna know the reason for the season? Click on 'http://www.needhim.org' ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Friday, December 21, 2001 11:01 AM To: Multiple recipients of list ORACLE-L Subject: RE: Web Development Toolkit and memory per session Ps -efl on Tru64 UNIX. e.g. 88008001 R 9001 1931 1 19.2 44 0 149M - 16:52:15 03:59:11 oraclesid (LOCAL=NO) 88008001 R 9001 10017 1 17.0 44 0 146M - 10:19:45 04:36:09 oraclesid (LOCAL=NO) 88008001 R 9001 10732 1 16.9 44 0 144M - 10:19:44 04:23:29 oraclesid (LOCAL=NO) 88008001 R 9001 14278 1 19.2 44 0 157M - 17:35:21 03:56:01 oraclesid (LOCAL=NO) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, December 21, 2001 1:36 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject:Re: Web Development Toolkit and memory per session Patrice, How are you determining that a session is require 140M? This number may be misleading. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: John Kanagaraj 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: SNAPSHOTS vs MATERIALIZE VIEWS
Jared, Some places do have internet connections and email separated. Fujitsu for one. Department of National Defense is another. However, that being said, all Oracle CD box sets come with at least one CD that contains documentation. I have 6 million of them (roughly). I personally believe in keeping a copy at the office and a copy at home. I have yet to read my Oracle documentation via the internet. -Original Message- [EMAIL PROTECTED] Sent: Friday, December 21, 2001 9:55 AM To: Multiple recipients of list ORACLE-L Your internet connection is down? How are you reading this? Jared [EMAIL PROTECTED] Sent by: To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: om Subject: SNAPSHOTS vs MATERIALIZE VIEWS 12/21/01 09:25 AM Please respond to ORACLE-L Oracle 8.1.6.0 We're trying to recreate our snapshots. We used the syntax 'CREATE SNAPSHOT'. The snapshots won't refresh. Error message is ORA-12018. Everyone's gone for Christmas with their office's locked (documentation inside!) and the internet connection is down. So 'R'ing TFM is out of the question. Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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: Kimberly Smith 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: VNI-2015 LInux server / winNT station / Linux server
How did root end up owning it??? -Original Message- Sent: Friday, December 21, 2001 10:20 AM To: Multiple recipients of list ORACLE-L Guys!!! I found the problem, you just needed to change the ownership of the dbsnmp file from root to oracle, after that everything is working!!! thanks to the people who took of their time on this one. Jose At 06:05 AM 12/21/01 -0800, you wrote: Joe; I already tried that, I went to my linux server, I installed the OMS, it's up and working, I discovered the node and the database, the agent dsnmp is working, I am logon as oracle, I created an account under the same name, with all the rights and roles available, I have the credentials set to this accounts for linux and oracle database user, and I am still getting the same thing And about the article from Mr. Raube (thanks for your time on this one), I have already tried that, I was login in as a local user, I set that account with all the rights from the windows user manager, and still the same problem. I am getting desperate with this problem, because I haven't backup my database and I don't want any unsuspected problems, please any other help would be greatly appreciate it. thanks in advance for your time and comments!! At 03:25 PM 12/20/01 -0800, you wrote: leave windows and go to unix. joe Joe Raube wrote: I searched OTN and found this: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/em.817/a 85247/ch6.htm Note: The Windows NT or Windows 2000 Domain User works only if the machine is a primary domain controller (PDC); otherwise, jobs will fail with VNI-2015 authentication error. In all non-PDC environments the account must be local to the machine. -Joe At 01:31 PM 12/20/01 -0800, you wrote: I have a Linux server running Oracle Standart 8I, I already setup the init file with the exclusive value to accept backup jobs, I also created a special account with sysdba, sysoper, and dba rights and a linux account same name password and with all rights to sysoper, sysdba and root groups. On the nt side I have the same account local and in the domain both with the log on as batch logs from the advance rights, same password, administrator rights for both, I also have the same name and password unde the OEM as a manager with superuser rights, and I have set the preferences for default node and linux node with the same name, even the service for the database is the same as sysdba, and still when I try to send a job, I get this VNI-2015 and the job reports failed, I even created a file with the orapwd with the same account name and the password. So if somebody could give a couple of ideas, out of this, I will appreciate it, I have read all of the messages and I tried all, I have no more ideas, I thanks for your help and time on this one in advance. Jose -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: tomas 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, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe 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: tomas 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
RE: Little OT: CLOB, Oracle Text, and ADO
Really? Do you know which version? In 8i it seems to be alive and well, and iFS requires it. Maybe as of 9i? Jared MacGregor, Ian A. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: ford.EDUSubject: RE: Little OT: CLOB, Oracle Text, and ADO Sent by: [EMAIL PROTECTED] om 12/21/01 10:00 AM Please respond to ORACLE-L Ctxserv has been deprecated. Check the directory $ORACLE_HOME/ctx/sample/script for the approved ways of keeping the indexes in synch. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, December 21, 2001 9:41 AM To: Multiple recipients of list ORACLE-L My experience with intermedia or context server, or whatever they call it this week, is in dealing with iFS, so I know just enough to be dangerous. :) It sounds like you need to have the context server running to periodically update the indexes. On unix it's 'ctxsrv'. I suggest you read the docs on this and do a search on metalink, there is some helpful information there. HTH Jared Witold Iwaniec wiwaniec@novali To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] stech.com cc: Sent by: Subject: Little OT: CLOB, Oracle Text, and ADO [EMAIL PROTECTED] 12/21/01 07:15 AM Please respond to ORACLE-L Hello It may be little OT but I am sure there are developers here. Also I hope some DBAs may know the answer... I am experimenting with Oracle Text - need to use the field from a VB application. I have a table with a CLOB column and a ctxcat index built on that column. If I insert records using SQL Plus, TOAD, or similar tool, the index is automatically updated so my query: select note_oid from lrmi_note where catsearch(note_data, 'SomeValue', null) 0; returns records matching the condition. In the application - if I use ADODB.Connection with parameters and execute my insert, the data is written, index automatically updated, and my query returns matching records. But if I use ADODB.Recordset to write the record, the data is written but the index doesn't get updated. If I open SQL Plus and run: select * from lrmi_note where note_oid = my_new_oid; it shows me the record with the CLOB column filled. But if I query the CLOB column using catsearch(), it doesn't return the record. If I rebuild the index, the query with catsearch() will return the records. But one of the reasons to use ctxcat indes is that it is updated with each transaction... While it may be specific to ADO I wonder if some Oracle gurus know, or can direct to some info, why Oracle doesn't update the ctxcat index even though the record is written and apears correctly. Witold== Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Web Development Toolkit and memory per session
This figure includes the shared memory portion of Oracle. The memory usage per process can be determined by subtracting the size of the shared memory segments for that instance. 'ipcs -ma' will display the shared memory segments and sizes. Or you can use svrmgr to locate the correct segmemts: svrmgr oradebug ipc This will dump the IPC data to a trace file. Jared Boivin, Patrice J To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: mpo.gc.ca Subject: RE: Web Development Toolkit and memory per session Sent by: [EMAIL PROTECTED] 12/21/01 11:00 AM Please respond to ORACLE-L Ps -efl on Tru64 UNIX. e.g. 88008001 R 9001 1931 1 19.2 44 0 149M -16:52:15 03:59:11 oraclesid (LOCAL=NO) 88008001 R 9001 10017 1 17.0 44 0 146M -10:19:45 04:36:09 oraclesid (LOCAL=NO) 88008001 R 9001 10732 1 16.9 44 0 144M -10:19:44 04:23:29 oraclesid (LOCAL=NO) 88008001 R 9001 14278 1 19.2 44 0 157M -17:35:21 03:56:01 oraclesid (LOCAL=NO) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, December 21, 2001 1:36 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Web Development Toolkit and memory per session Patrice, How are you determining that a session is require 140M? This number may be misleading. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: 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: Move DB to Another Schema
Joe Raube wrote: 1 - never create objects as SYS 2 - svrmgr is gone in 9i - stop using it I would drop all user objects that you created as SYS, and recreate using a DDL script. -Joe Joe, I would beg to differ on the use of svrmgrl over sqlplus in 8.1.x. None other than Tom Kyte corrected me on the (non)use of sqlplus in running scripts as SYS such as catalog.sql. For 8.1.6, 8.1.7, you are still recommended to use svrmgrl for running scripts as SYS. you can find the post over at google - it was in comp.databases.oracle.server Paul happy holidays. http://www.planetchristmas.com/pictures_2001.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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: VNI-2015 LInux server / winNT station / Linux server
because root is supposed to own it. root.sh sets it, last i checked, joe Kimberly Smith wrote: How did root end up owning it??? -Original Message- Sent: Friday, December 21, 2001 10:20 AM To: Multiple recipients of list ORACLE-L Guys!!! I found the problem, you just needed to change the ownership of the dbsnmp file from root to oracle, after that everything is working!!! thanks to the people who took of their time on this one. Jose At 06:05 AM 12/21/01 -0800, you wrote: Joe; I already tried that, I went to my linux server, I installed the OMS, it's up and working, I discovered the node and the database, the agent dsnmp is working, I am logon as oracle, I created an account under the same name, with all the rights and roles available, I have the credentials set to this accounts for linux and oracle database user, and I am still getting the same thing And about the article from Mr. Raube (thanks for your time on this one), I have already tried that, I was login in as a local user, I set that account with all the rights from the windows user manager, and still the same problem. I am getting desperate with this problem, because I haven't backup my database and I don't want any unsuspected problems, please any other help would be greatly appreciate it. thanks in advance for your time and comments!! At 03:25 PM 12/20/01 -0800, you wrote: leave windows and go to unix. joe Joe Raube wrote: I searched OTN and found this: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/em.817/a 85247/ch6.htm Note: The Windows NT or Windows 2000 Domain User works only if the machine is a primary domain controller (PDC); otherwise, jobs will fail with VNI-2015 authentication error. In all non-PDC environments the account must be local to the machine. -Joe At 01:31 PM 12/20/01 -0800, you wrote: I have a Linux server running Oracle Standart 8I, I already setup the init file with the exclusive value to accept backup jobs, I also created a special account with sysdba, sysoper, and dba rights and a linux account same name password and with all rights to sysoper, sysdba and root groups. On the nt side I have the same account local and in the domain both with the log on as batch logs from the advance rights, same password, administrator rights for both, I also have the same name and password unde the OEM as a manager with superuser rights, and I have set the preferences for default node and linux node with the same name, even the service for the database is the same as sysdba, and still when I try to send a job, I get this VNI-2015 and the job reports failed, I even created a file with the orapwd with the same account name and the password. So if somebody could give a couple of ideas, out of this, I will appreciate it, I have read all of the messages and I tried all, I have no more ideas, I thanks for your help and time on this one in advance. Jose -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: tomas 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, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe 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: tomas 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
Re: How to backup MTS database with RMAN
Title: How to backup MTS database with RMAN Hi, Hulmet, I tried. To use RMAN on MTS database environment, both database server machine and the RMAN machine(the machine you run RMAN on it) should use dedicated server mode instead of shared mode. It means the tnsnames.ora file on these two machines(or one machine) should contain SERVER=DEDICATED line. Maybe only application box can use shared-mode(server=shared). example: SHAGGY = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.25)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = SHAGGY) (server = dedicated) ) ) Kevin Wang - Original Message - From: Daiminger, Helmut To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 19, 2001 5:25 AM Subject: How to backup MTS database with RMAN Hi! Since I'm pretty new to RMAN I have a rather basic question: is it possible to backup databases running in multithreaded server mode with RMAN? Or does this have to be dedicated server mode? $ rman target sys/@kpmgi rcvcat rman/x@admserv Recovery Manager: Release 8.1.7.2.0 - Production RMAN-06005: connected to target database: KPMGI (DBID=3995384462) RMAN-06008: connected to recovery catalog database RMAN register database; RMAN-03022: compiling command: register RMAN-03023: executing command: register RMAN-08006: database registered in recovery catalog RMAN-03023: executing command: full resync RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-07005: error during channel cleanup RMAN-07004: unhandled exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-19550: cannot use backup/restore functions while using dispatcher RMAN-10031: ORA-19550 occurred during call to DBMS_BACKUP_RESTORE.CFILEUSECURRENT RMAN-03008: error while performing automatic resync of recovery catalog RMAN-07004: unhandled exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-19550: cannot use backup/restore functions while using dispatcher RMAN-10031: ORA-19550 occurred during call to DBMS_BACKUP_RESTORE.CFILEMAKEANDUSESNAPSHOT Do I just have to take out mts_dispatchers = "(protocol=TCP)" from the init.ora file? This is 8.1.7.2.0 on Sun Solaris. Thanks, Helmut
Does Setting Transactions to a Specific Rollback Segment Affect T
Title: How to backup MTS database with RMAN Hey gang; If my developers use the large rollback segment to perform their updates to data, will any triggers firing on the affected tables also use that rollback segment ?? -Original Message-From: kevin wang [mailto:[EMAIL PROTECTED]]Sent: Friday, December 21, 2001 3:40 PMTo: Multiple recipients of list ORACLE-LSubject: Re: How to backup MTS database with RMAN Hi, Hulmet, I tried. To use RMAN on MTS database environment, both database server machine and the RMAN machine(the machine you run RMAN on it) should use dedicated server mode instead of shared mode. It means the tnsnames.ora file on these two machines(or one machine) should contain SERVER=DEDICATED line. Maybe only application box can use shared-mode(server=shared). example: SHAGGY = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.25)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = SHAGGY) (server = dedicated) ) ) Kevin Wang - Original Message - From: Daiminger, Helmut To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 19, 2001 5:25 AM Subject: How to backup MTS database with RMAN Hi! Since I'm pretty new to RMAN I have a rather basic question: is it possible to backup databases running in multithreaded server mode with RMAN? Or does this have to be dedicated server mode? $ rman target sys/@kpmgi rcvcat rman/x@admserv Recovery Manager: Release 8.1.7.2.0 - Production RMAN-06005: connected to target database: KPMGI (DBID=3995384462) RMAN-06008: connected to recovery catalog database RMAN register database; RMAN-03022: compiling command: register RMAN-03023: executing command: register RMAN-08006: database registered in recovery catalog RMAN-03023: executing command: full resync RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-07005: error during channel cleanup RMAN-07004: unhandled exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-19550: cannot use backup/restore functions while using dispatcher RMAN-10031: ORA-19550 occurred during call to DBMS_BACKUP_RESTORE.CFILEUSECURRENT RMAN-03008: error while performing automatic resync of recovery catalog RMAN-07004: unhandled exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-19550: cannot use backup/restore functions while using dispatcher RMAN-10031: ORA-19550 occurred during call to DBMS_BACKUP_RESTORE.CFILEMAKEANDUSESNAPSHOT Do I just have to take out mts_dispatchers = "(protocol=TCP)" from the init.ora file? This is 8.1.7.2.0 on Sun Solaris. Thanks, Helmut
RE: ODBC 8.1.7.5 ?
Gene: I'm currently unable to download any of the ODBC drivers. Seems like something's amiss at otn barb -- From: Gene Sais[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Friday, December 21, 2001 2:30 PM To: Multiple recipients of list ORACLE-L Subject: ODBC 8.1.7.5 ? Can anyone else download the odbc driver 8.1.7.5 from technet? It's been timing out on me for days now. Gene PS. Enjoy your holiday whatever that may be! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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: Baker, Barbara 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: VNI-2015 LInux server / winNT station / Linux server
Well, if root is suppose to own it then how come when it was changed it to oracle it worked? I must say, I never looked but I installed the 9i OEM and did not run root.sh after and it still worked. Since I don't have root access I don't see how it could be owned by root. That was on HP. Just confused. -Original Message- Sent: Friday, December 21, 2001 1:35 PM To: Multiple recipients of list ORACLE-L because root is supposed to own it. root.sh sets it, last i checked, joe Kimberly Smith wrote: How did root end up owning it??? -Original Message- Sent: Friday, December 21, 2001 10:20 AM To: Multiple recipients of list ORACLE-L Guys!!! I found the problem, you just needed to change the ownership of the dbsnmp file from root to oracle, after that everything is working!!! thanks to the people who took of their time on this one. Jose At 06:05 AM 12/21/01 -0800, you wrote: Joe; I already tried that, I went to my linux server, I installed the OMS, it's up and working, I discovered the node and the database, the agent dsnmp is working, I am logon as oracle, I created an account under the same name, with all the rights and roles available, I have the credentials set to this accounts for linux and oracle database user, and I am still getting the same thing And about the article from Mr. Raube (thanks for your time on this one), I have already tried that, I was login in as a local user, I set that account with all the rights from the windows user manager, and still the same problem. I am getting desperate with this problem, because I haven't backup my database and I don't want any unsuspected problems, please any other help would be greatly appreciate it. thanks in advance for your time and comments!! At 03:25 PM 12/20/01 -0800, you wrote: leave windows and go to unix. joe Joe Raube wrote: I searched OTN and found this: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/em.817/ a 85247/ch6.htm Note: The Windows NT or Windows 2000 Domain User works only if the machine is a primary domain controller (PDC); otherwise, jobs will fail with VNI-2015 authentication error. In all non-PDC environments the account must be local to the machine. -Joe At 01:31 PM 12/20/01 -0800, you wrote: I have a Linux server running Oracle Standart 8I, I already setup the init file with the exclusive value to accept backup jobs, I also created a special account with sysdba, sysoper, and dba rights and a linux account same name password and with all rights to sysoper, sysdba and root groups. On the nt side I have the same account local and in the domain both with the log on as batch logs from the advance rights, same password, administrator rights for both, I also have the same name and password unde the OEM as a manager with superuser rights, and I have set the preferences for default node and linux node with the same name, even the service for the database is the same as sysdba, and still when I try to send a job, I get this VNI-2015 and the job reports failed, I even created a file with the orapwd with the same account name and the password. So if somebody could give a couple of ideas, out of this, I will appreciate it, I have read all of the messages and I tried all, I have no more ideas, I thanks for your help and time on this one in advance. Jose -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: tomas 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, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe 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: tomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858)
RE: IMPORT TIME IS HIGH
yeah I think he went from you won't need a DBA to you will need lots of DBAs to manage all the different specialized features :) --- Karniotis, Stephen [EMAIL PROTECTED] wrote: True: If you listened carefully to Larry at OOW, he backed off that statement, saying that the DBA is necessary to make sure that all of the Oracle9i features are implemented properly. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email:[EMAIL PROTECTED] Web: www.compuware.com -Original Message- Sent: Friday, December 21, 2001 12:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: IMPORT TIME IS HIGH and svrmgr was going in 8i too... took them until 9i oh, and of course, my personal favorite (this has been said since 7) you won't need a DBA anymore --- Karniotis, Stephen [EMAIL PROTECTED] wrote: Everyone needs to remember that the Oracle Import Utility is just a 3GL C program with INSERT statements. It is widely publicized that the ratio is 1:4 so this should not come as a surprise to anyone. Some ways to improve performance is to use a large buffer size (10-20M) and set COMMIT=Y to facilitate array inserts. There are OS options for improving the I/O bandwidth on the file, but that's really it. Rachel is correct. She did not want to frighten anyone. Now the good news is with Oracle9i, Oracle has added Array Inserts to the tool so this may help. How many of us remember when Oracle claimed that EXP/IMP were to go away in 8i Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Friday, December 21, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Subject:Re: IMPORT TIME IS HIGH well, yeah, depending on the number of indexes, I've seen a 6 hour export take almost 24 hours to import -- on the same box as the export was done. I was trying not to frighten anyone :) --- Stephane Faroult [EMAIL PROTECTED] wrote: Rachel Carmichael wrote: in addition, define what you mean by much time -- how much data are you loading? how slow is the load actually? I've found that in general, an import takes about twice as long as the export. Rachel, I don't know it's because of the festive season but I find you optimistic. I'd rather say 3 or 4 times as long as a conventional export. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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). __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Karniotis, Stephen 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
Re: Does Setting Transactions to a Specific Rollback Segment Affect T
Kevin, Look up the excellent presentation at http://www.evdbt.com/library.htm on rollbacks. It's call Cats, Dogs and ORA-01555. There's a MS Word doc and a power point presentation. Also look up rollbacks at Steve Adams site and Jonathan Lewis' site. The short answer to your question is 'Maybe'. Jared Kevin Lange [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: Sent by: Subject: Does Setting Transactions to a Specific Rollback Segment [EMAIL PROTECTED]Affect T om 12/21/01 02:00 PM Please respond to ORACLE-L Hey gang; If my developers use the large rollback segment to perform their updates to data, will any triggers firing on the affected tables also use that rollback segment ?? -Original Message- From: kevin wang [mailto:[EMAIL PROTECTED]] Sent: Friday, December 21, 2001 3:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: How to backup MTS database with RMAN Hi, Hulmet, I tried. To use RMAN on MTS database environment, both database server machine and the RMAN machine(the machine you run RMAN on it) should use dedicated server mode instead of shared mode. It means the tnsnames.ora file on these two machines(or one machine) should contain SERVER=DEDICATED line. Maybe only application box can use shared-mode(server=shared). example: SHAGGY = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.25)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = SHAGGY) (server = dedicated) ) ) Kevin Wang - Original Message - From: Daiminger, Helmut To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 19, 2001 5:25 AM Subject: How to backup MTS database with RMAN Hi! Since I'm pretty new to RMAN I have a rather basic question: is it possible to backup databases running in multithreaded server mode with RMAN? Or does this have to be dedicated server mode? $ rman target sys/@kpmgi rcvcat rman/x@admserv Recovery Manager: Release 8.1.7.2.0 - Production RMAN-06005: connected to target database: KPMGI (DBID=3995384462) RMAN-06008: connected to recovery catalog database RMAN register database; RMAN-03022: compiling command: register RMAN-03023: executing command: register RMAN-08006: database registered in recovery catalog RMAN-03023: executing command: full resync RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-07005: error during channel cleanup RMAN-07004: unhandled exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-19550: cannot use backup/restore functions while using dispatcher RMAN-10031: ORA-19550 occurred during call to DBMS_BACKUP_RESTORE.CFILEUSECURRENT RMAN-03008: error while performing automatic resync of recovery catalog RMAN-07004: unhandled exception during command execution on channel default RMAN-10035: exception raised in RPC:
Re: Does Setting Transactions to a Specific Rollback Segment Affect T
they do set transaction ?? if so, yes, as the trigger is part of the same transaction --- Kevin Lange [EMAIL PROTECTED] wrote: Hey gang; If my developers use the large rollback segment to perform their updates to data, will any triggers firing on the affected tables also use that rollback segment ?? -Original Message- Sent: Friday, December 21, 2001 3:40 PM To: Multiple recipients of list ORACLE-L Hi, Hulmet, I tried. To use RMAN on MTS database environment, both database server machine and the RMAN machine(the machine you run RMAN on it) should use dedicated server mode instead of shared mode. It means the tnsnames.ora file on these two machines(or one machine) should contain SERVER=DEDICATED line. Maybe only application box can use shared-mode(server=shared). example: SHAGGY = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.25)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = SHAGGY) (server = dedicated) ) ) Kevin Wang - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 5:25 AM Hi! Since I'm pretty new to RMAN I have a rather basic question: is it possible to backup databases running in multithreaded server mode with RMAN? Or does this have to be dedicated server mode? $ rman target sys/@kpmgi mailto:sys/@kpmgi rcvcat rman/x@admserv mailto:rman/x@admserv Recovery Manager: Release 8.1.7.2.0 - Production RMAN-06005: connected to target database: KPMGI (DBID=3995384462) RMAN-06008: connected to recovery catalog database RMAN register database; RMAN-03022: compiling command: register RMAN-03023: executing command: register RMAN-08006: database registered in recovery catalog RMAN-03023: executing command: full resync RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-07005: error during channel cleanup RMAN-07004: unhandled exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-19550: cannot use backup/restore functions while using dispatcher RMAN-10031: ORA-19550 occurred during call to DBMS_BACKUP_RESTORE.CFILEUSECURRENT RMAN-03008: error while performing automatic resync of recovery catalog RMAN-07004: unhandled exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-19550: cannot use backup/restore functions while using dispatcher RMAN-10031: ORA-19550 occurred during call to DBMS_BACKUP_RESTORE.CFILEMAKEANDUSESNAPSHOT Do I just have to take out mts_dispatchers = (protocol=TCP) from the init.ora file? This is 8.1.7.2.0 on Sun Solaris. Thanks, Helmut __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: VNI-2015 LInux server / winNT station / Linux server
well if it is owned by oracle then only oracle type jobs can be executed by the (un)intelligent agent), if you needed to run a job that needed privileges outside of oracle, it wont run, hence the reason it needed to be owned and setuid of root. is it a security risk, no doubt, would i run it on my prod machines, probably not but for development, i would. joe Kimberly Smith wrote: Well, if root is suppose to own it then how come when it was changed it to oracle it worked? I must say, I never looked but I installed the 9i OEM and did not run root.sh after and it still worked. Since I don't have root access I don't see how it could be owned by root. That was on HP. Just confused. -Original Message- Sent: Friday, December 21, 2001 1:35 PM To: Multiple recipients of list ORACLE-L because root is supposed to own it. root.sh sets it, last i checked, joe Kimberly Smith wrote: How did root end up owning it??? -Original Message- Sent: Friday, December 21, 2001 10:20 AM To: Multiple recipients of list ORACLE-L Guys!!! I found the problem, you just needed to change the ownership of the dbsnmp file from root to oracle, after that everything is working!!! thanks to the people who took of their time on this one. Jose At 06:05 AM 12/21/01 -0800, you wrote: Joe; I already tried that, I went to my linux server, I installed the OMS, it's up and working, I discovered the node and the database, the agent dsnmp is working, I am logon as oracle, I created an account under the same name, with all the rights and roles available, I have the credentials set to this accounts for linux and oracle database user, and I am still getting the same thing And about the article from Mr. Raube (thanks for your time on this one), I have already tried that, I was login in as a local user, I set that account with all the rights from the windows user manager, and still the same problem. I am getting desperate with this problem, because I haven't backup my database and I don't want any unsuspected problems, please any other help would be greatly appreciate it. thanks in advance for your time and comments!! At 03:25 PM 12/20/01 -0800, you wrote: leave windows and go to unix. joe Joe Raube wrote: I searched OTN and found this: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/em.817/ a 85247/ch6.htm Note: The Windows NT or Windows 2000 Domain User works only if the machine is a primary domain controller (PDC); otherwise, jobs will fail with VNI-2015 authentication error. In all non-PDC environments the account must be local to the machine. -Joe At 01:31 PM 12/20/01 -0800, you wrote: I have a Linux server running Oracle Standart 8I, I already setup the init file with the exclusive value to accept backup jobs, I also created a special account with sysdba, sysoper, and dba rights and a linux account same name password and with all rights to sysoper, sysdba and root groups. On the nt side I have the same account local and in the domain both with the log on as batch logs from the advance rights, same password, administrator rights for both, I also have the same name and password unde the OEM as a manager with superuser rights, and I have set the preferences for default node and linux node with the same name, even the service for the database is the same as sysdba, and still when I try to send a job, I get this VNI-2015 and the job reports failed, I even created a file with the orapwd with the same account name and the password. So if somebody could give a couple of ideas, out of this, I will appreciate it, I have read all of the messages and I tried all, I have no more ideas, I thanks for your help and time on this one in advance. Jose -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: tomas 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, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe 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
RE: SNAPSHOTS vs MATERIALIZE VIEWS
I don't even bother with the CD, I just copy the docs to my PC. Right now I have 7.3.4/8.0.5/8.1.7 and 9i on the machine. doesn't take much space and since when I travel the CD is external and therefore optional for me to carry, I always have the docs when I'm writing --- Kimberly Smith [EMAIL PROTECTED] wrote: Jared, Some places do have internet connections and email separated. Fujitsu for one. Department of National Defense is another. However, that being said, all Oracle CD box sets come with at least one CD that contains documentation. I have 6 million of them (roughly). I personally believe in keeping a copy at the office and a copy at home. I have yet to read my Oracle documentation via the internet. -Original Message- [EMAIL PROTECTED] Sent: Friday, December 21, 2001 9:55 AM To: Multiple recipients of list ORACLE-L Your internet connection is down? How are you reading this? Jared [EMAIL PROTECTED] Sent by: To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: om Subject: SNAPSHOTS vs MATERIALIZE VIEWS 12/21/01 09:25 AM Please respond to ORACLE-L Oracle 8.1.6.0 We're trying to recreate our snapshots. We used the syntax 'CREATE SNAPSHOT'. The snapshots won't refresh. Error message is ORA-12018. Everyone's gone for Christmas with their office's locked (documentation inside!) and the internet connection is down. So 'R'ing TFM is out of the question. Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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: Kimberly Smith 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). __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Little OT: CLOB, Oracle Text, and ADO
From the Intermedia New Features for 8.1.6 - We now recommend processing pending DML through a dbms_job -- an individual job for each index, a ctxsys job for all indexes, or some combination of the two. This eliminates the need for ctxsrv, and thus eliminates the problem of starting ctxsrv each time the database starts. The ctxsrv program itself is now deprecated, and may be removed in some future release. -- Is it required for IFS? I haven't tried to use that beast, but checking a Metalink forum, indicates that ctx_ddl.synch_index is preferred over ctxstv. Ian MacGregor -Original Message- Sent: Friday, December 21, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Really? Do you know which version? In 8i it seems to be alive and well, and iFS requires it. Maybe as of 9i? Jared MacGregor, Ian A. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: ford.EDUSubject: RE: Little OT: CLOB, Oracle Text, and ADO Sent by: [EMAIL PROTECTED] om 12/21/01 10:00 AM Please respond to ORACLE-L Ctxserv has been deprecated. Check the directory $ORACLE_HOME/ctx/sample/script for the approved ways of keeping the indexes in synch. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, December 21, 2001 9:41 AM To: Multiple recipients of list ORACLE-L My experience with intermedia or context server, or whatever they call it this week, is in dealing with iFS, so I know just enough to be dangerous. :) It sounds like you need to have the context server running to periodically update the indexes. On unix it's 'ctxsrv'. I suggest you read the docs on this and do a search on metalink, there is some helpful information there. HTH Jared Witold Iwaniec wiwaniec@novali To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] stech.com cc: Sent by: Subject: Little OT: CLOB, Oracle Text, and ADO [EMAIL PROTECTED] 12/21/01 07:15 AM Please respond to ORACLE-L Hello It may be little OT but I am sure there are developers here. Also I hope some DBAs may know the answer... I am experimenting with Oracle Text - need to use the field from a VB application. I have a table with a CLOB column and a ctxcat index built on that column. If I insert records using SQL Plus, TOAD, or similar tool, the index is automatically updated so my query: select note_oid from lrmi_note where catsearch(note_data, 'SomeValue', null) 0; returns records matching the condition. In the application - if I use ADODB.Connection with parameters and execute my insert, the data is written, index automatically updated, and my query returns matching records. But if I use ADODB.Recordset to write the record, the data is written but the index doesn't get updated. If I open SQL Plus and run: select * from lrmi_note where note_oid = my_new_oid; it shows me the record with the CLOB column filled. But if I query the CLOB column using