Re: Rollback Segment Too Old !!!!!!!
I think you forgot to assign a transaction to the increased RBS Suppose the increased RBS is RBS2 then SET TRANSACTION USE ROLLBACK SEGMENT RBS2; After that do an export again . I think it will work. --- Jackson Dumas [EMAIL PROTECTED] wrote: Yeah I had a problem recently were I was exporting a 45Gigg database, the export will continue until at a end it will come up with a warning that export was completed successfully with warnings because rollback segment was too old. I increased the tablespace RBS where the rollback segments are residing and also created some more rollback segments. This did not work also, I had a problem similar to this but this was happening when the user was trying to delete some records with a where clause, it would come up with the error rollback segment too old. Can somebody give me an idea of how to go about this problem, I would appreciate you input dearly Thank you, Mtabaruka ! ___ http://www.webmail.co.za the South-African free email service -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jackson Dumas 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!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH 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: Rollback Segment Too Old !!!!!!!
I think you forgot to assign a transaction to the increased RBS Suppose the increased RBS is RBS2 then SET TRANSACTION USE ROLLBACK SEGMENT RBS2; After that do an export again . I think it will work. --- Jackson Dumas [EMAIL PROTECTED] wrote: Yeah I had a problem recently were I was exporting a 45Gigg database, the export will continue until at a end it will come up with a warning that export was completed successfully with warnings because rollback segment was too old. I increased the tablespace RBS where the rollback segments are residing and also created some more rollback segments. This did not work also, I had a problem similar to this but this was happening when the user was trying to delete some records with a where clause, it would come up with the error rollback segment too old. Can somebody give me an idea of how to go about this problem, I would appreciate you input dearly Thank you, Mtabaruka ! ___ http://www.webmail.co.za the South-African free email service -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jackson Dumas 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!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH 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: Problems with Linking PROC Code
You could try making sure that LD_LIBRARY_PATH=/oracle/ora01/ora805/lib:${LD_LIBRARY_PATH} ehsan sinavalda wrote: Hello All Could someone please tell me which libraries should be linked with the output of Proc precompiler? Using g++ -L /oracle/ora01/ora805/lib/ test.c -lsql where test.c is output of precompiler I get a lot of undefined refrence errors that originates from libsql.a library. Thanks E. __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ehsan sinavalda 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: Charlie Mengler 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).
selftest q's doubt
Title: selftest q's doubt Helo guru's I had small doubts, may be it's trival too. Please remind me, How the following statements are true: a) Imiplicit cursors process only one row at a time Eg. Suppose a delete statement wipe off 10 rows from a table. This case How many rows are processes?, Is't 10 rows or 1 row? b) When using an ORDER BY clause to sort the rows returned by a query, the sort limit is the number of columns that exist in the tables(s) listed in the FROM clause. Eg. Assume that a table t having 2 columns c1, c2. In this case i can do the following query: sql select c1, c2, c1||'a', 'abc' from t order by 1,2,3,4; Here the table having only 2 columns, however i can able to sort in a query upto the number of columns exists in the select list. If so, how come quoted statement becomes true?. Is i'm missing something?. PS:. These hints got from the selftest. Rgds, Nirmal.
ora-03113 ora-03114
I recently rebuild several tables/indexes on a v7.3.3 database on nt 4.0 sp4. Most to all of the table rebuilds included changing the initial extent. A fews days later we started experiencing ora-03113/03114 errors on the client side. This is a small database/applications which serves a small user base, 10 - 15 users. There is no relevant information in the alter log, nor am I generating any trace files. This listener is up and from a network stand point we are not receiving any packet errors or collisions. The database starts up fine and everyone can connect with no problems. After being logged in and working for a certain amount time the users loose their connection. This problem isn't isolated to certain users or machines. For that matter nor the views or tables they are accessing either. Has anyone ran into this situation and if so how did you identify and resolve the issue. thanks, Donnie Shaw This transmittal may contain confidential information intended solely for the addressee. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. If you have received this communication in error, please notify us immediately by reply or by telephone (collect at 907-564-1000) and ask to speak with the message sender. In addition, please immediately delete this message and all attachments. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, Donnie 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: VMS equivalent of ls -lrt
Maybe something like this: dir/owner/prot/date/size/page disk$name:[directory.subdirectory] I enclose some VMS documents. I apologise because I don't remember the URL. However some are from metalink. Regards. PS: It's a zip file. --- Santosh Varma [EMAIL PROTECTED] wrote: VMS equivalent of ls -lrtI wanted to know of any site where VMS documentation is there. can anybody help me out ?? detailed knowledge of VMS !! thanks in advance , santosh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Hallas John Sent: Friday, November 16, 2001 3:30 PM To: Multiple recipients of list ORACLE-L Subject: VMS equivalent of ls -lrt A user has asked me about identifying most recently created trace files on a VMS system. I have shown him where they are and how to do a DIR/SIN=TODAY command to get todays files. However he was complaining that there was no equivalent on VMS to ls -lrt to list all files oldest first. I have looked at PIPE DIR *.TRC |SORT commands but you need a key and it is not to obvious how to do it easily. Does anybody know an easy way of doing it. I have never needed to do it because I have always find the date parameter to DIR to be sufficient but it would be nice to help a user out for a change !!! John Oracle DBA BTcellnet * [EMAIL PROTECTED] ( 0113 388 6062Desk ) 07713 066194 BT Mobile ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. ** = ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com vms.zip Description: Zip compressed data
RE: Repairing corrupt datablocks
You should issue the procedure like this: exec dbms_repair.check_object('SCOTT','EMP',null,object_type=DBMS_REPAIR.TABLE_OBJECT,repair_table_name=DBMS_REPAIR.REPAIR_TABLE,null,null,null,null,:x); I put the four nulls because of your bind variable. If you don't want to know the corrupt_count, you won't need the four nulls and the last parameter. Remember that the REPAIR_TABLE has to be created through dbms_repair.admin_tables before the dbms_repair.check_object invocation. Regards. --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi lists, I tried execting the dbms_repair with the following steps: sql variable x number; sql exec dbms_repair.check_object('SCOTT','EMP',:x); it is giving the error: PLS-00306: wrong number or types of arguments in call to 'CHECK_OBJECT' can anybody tell me how to execute this procedure. Thnx and Regards, Srinivas + Hello By using DBMS_REPAIR.CHECK_OBJECT I have found 3 corrupt datablocks in our database, all with error: Block Checking: DBA = 184607007, Block Type = KTB-managed data block kdbchk: the amount of space used is not equal to block size used=8169 fsc=0 avsp=112 dtl=8120 My plan now is to fix these data blocks. I have never done this before, so I consulted my Oracle manual and the manual recomends the following: First run DBMS_REPAIR.CHECK_OBJECT on the object to find out if the object contains any corrupt blocks. Then I run DBMS_REPAIR.FIX_CORRUPT_BLOCKS to mark the block as corrupt. After that run DBMS_REPAIR.DUMP_ORPHAN_KEYS to dump all the index references to these blocks. Then run DBMS_REPAIR.SKIP_CORRUPT_BLOCKS on the object, and after that recreate the table. By doing this the corrupt blocks are removed from the object. Now I have some questions about this. (My environments is a Oracle 8.1.7 on a Windows 2000 Advanced Server): Is this a good way, or is there a better way? Can I access the data in the corrupt blocks in anyway so I can se whats in the blocks? I'm afraid that i will loose some data by doing it this way. Regards Jonas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonas A Wetterberg 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: Tatireddy, Shrinivas (MED, Keane) 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). = ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: Disk to Disk backups and RMAN
Thank you John and Ron! This is exactly what I was looking for. Thanks again, Jared On Friday 16 November 2001 13:40, John Kanagaraj wrote: Jared/Tom, As Tom pointed out, the problem is how to have the software, ( RMAN in this case ) automatically load the correct tapes when the backup was made to disk, and then the disks were later backed up to tape. Ahh - now I understand the question. You *will* need the MML (Media Management Layer) and an automated tape library that is supported by the sofware and version that provides the MML. In actual terms, say you use Legato Networker and the provided MML that interfaces to RMAN: In this case, the Legato agent will be prompted by the Legato server to backup the database - this agent in turn will execute the named RMAN script, which will then create your DATAFILE COPY on disk and kick off a backup of these to tape. The Legato server index will then be used to store the tag name, bar-code number, filename/date/size, etc. of bar-coded tape on which this particular datafile copy was placed - this tape will then be placed in the tape silo. Upon a request to perform a restore as of a particular day/time, this index will then 'remember' the right tape, the robotic eye/arm will then locate/load the right tape (identified by the bar-code) into the drive from the silo and presto - your datafile copy is back where it should be, all automated of course thanks to robotics and bar-codes! This should work in a similar manner with other vendors such as Veritas Netbackup, Arcserve, IBM (now Tivoli) ADSM, etc. Does this clarify (or make it murkier)? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Kill your killer-commute! Listen to great commercial-free christian music 24x7 (details at www.klove.com) ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).
Linux client error
We have Oracle 9i under Suse Linux. I installed DOA for Kylix. After putting an Oracle Session on the form and made a Connect I received the following error message: Initialization error Could not load home/oracle/OraHome/lib/libcIntsh.so OCIDLL forced to home/oracle/OraHome/lib/libcIntsh.so Load library home/oracle/OraHome/lib/libcIntsh.so returned 0 This seems crazy because this libcIntsh.so _is_ in the directory. On the other hand Oracle works perfectly, I can connect via Sql Plus and the Orahome is in path and environment settings. I've been told that It turned out that the Oracle client library ($ORACLE_HOME/lib/libclntsh.so) contained an undefined symbol __cmpdi2. Can somebody help me? Thank you in advance Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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).
Dba studio under 9i for Linux?
Hi, Can you tell me where can I find Dba Studio under Oracle 9i for Linux. I've tried the different files in the Bin directory with no result. T.I.A. Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: Linux client error
-- Csillag Zsolt [EMAIL PROTECTED] Initialization error Could not load home/oracle/OraHome/lib/libcIntsh.so OCIDLL forced to home/oracle/OraHome/lib/libcIntsh.so Load library home/oracle/OraHome/lib/libcIntsh.so returned 0 Config error? Notice the lack of a leading '/' on the paths. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: Rollback Segment Too Old !!!!!!!
Hi Mr Dumas , Why not using direct path load In export specify : Direct = y Regards -Original Message- From: ASHRAF SALAYMEH [SMTP:[EMAIL PROTECTED]] Sent: Saturday, November 17, 2001 1:30 PM To: Multiple recipients of list ORACLE-L Subject: Re: Rollback Segment Too Old !!! I think you forgot to assign a transaction to the increased RBS Suppose the increased RBS is RBS2 then SET TRANSACTION USE ROLLBACK SEGMENT RBS2; After that do an export again . I think it will work. --- Jackson Dumas [EMAIL PROTECTED] wrote: Yeah I had a problem recently were I was exporting a 45Gigg database, the export will continue until at a end it will come up with a warning that export was completed successfully with warnings because rollback segment was too old. I increased the tablespace RBS where the rollback segments are residing and also created some more rollback segments. This did not work also, I had a problem similar to this but this was happening when the user was trying to delete some records with a where clause, it would come up with the error rollback segment too old. Can somebody give me an idea of how to go about this problem, I would appreciate you input dearly Thank you, Mtabaruka ! ___ http://www.webmail.co.za the South-African free email service -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jackson Dumas 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!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH 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: Ahmed Gholam Hussain 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).