RE: Oracle Label Security
SELECT USERNAME FROM DBA_USERS WHERE USERNAME = 'LBACSYS'; if returns row then Label security installed. naren -Original Message- Sent: Wednesday, 29 May 2002 10:25 To: Multiple recipients of list ORACLE-L Hi List, How can I find out "Oracle Label Security" is installed or NOT? Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === 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. = End Confidentiality Statement = -- 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: Narender Akula 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).
unix df -k .. not giving extact space at point in time
hi gurus, This is unix question but hope someone got the answer I ran df -k yesterday on my oracle directories. /oradata4 81% /oradata3 77% /oradata6 72% ( this not exact out put only inclueded mount on ,capacity) I removed some files from /oradata4 and added some files to /oradata4 the figure didnot changed on /oradata4 .. but increased to 87% . today agian I ran df -k which showed. /oradata4 as at 76% capacity. my question why df -k command took some time to give exact figures on disk usage ? Is there any why to refresh this command or are there any alternatives ? naren narender akula Oracle DBA OCP TERRALINK INTERNATIONAL LIMITED ddi:04 915 6055 fax:04 915 6030 mobile: 021470971 email: [EMAIL PROTECTED] mail: PO Box 2872, Wellington -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula 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).
Migration errors
hi all, Is any body encountered following errors... this happening while I try to migrate 8.1.7.2 database to 9.0.1 using manual upgradation or ODMA tool. ALTER TABLE system.aq$_queues * ERROR at line 1: ORA-04045: errors during recompilation/revalidation of SYS.AQ$_SUBSCRIBERS ORA-00600: internal error code, arguments: [15456], [AQ$_SUBSCRIBERS], [13], [7], [tdo generation], [], [], [] ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [], [] ORA-04045: errors during recompilation/revalidation of SYS.AQ$_AGENT ORA-00600: internal error code, arguments: [15456], [AQ$_AGENT], [13], [7], [tdo generation], [], [], [] ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [], [] ALTER TABLE system.aq$_queues * ERROR at line 1: ORA-04045: errors during recompilation/revalidation of SYS.AQ$_SUBSCRIBERS ORA-00600: internal error code, arguments: [15456], [AQ$_SUBSCRIBERS], [13], [7], [tdo generation], [], [], [] ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [], [] ORA-04045: errors during recompilation/revalidation of SYS.AQ$_AGENT ORA-00600: internal error code, arguments: [15456], [AQ$_AGENT], [13], [7], [tdo generation], [], [], [] ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [], [] and alert log has following errors Errors in file /usr2/app/oracle/admin/TIMSTEST/udump/timstest_ora_7587.trc: ORA-00600: internal error code, arguments: [15456], [AQ$_AGENT], [13], [7], [tdo generation], [], [], [] ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [], [] Wed Jan 30 10:36:04 2002 Errors in file /usr2/app/oracle/admin/TIMSTEST/udump/timstest_ora_7587.trc: ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [], [] ORA-04045: errors during recompilation/revalidation of SYS.AQ$_AGENT ORA-00600: internal error code, arguments: [15456], [AQ$_AGENT], [13], [7], [tdo generation], [], [], [] ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [], [] Wed Jan 30 10:36:06 2002 Errors in file /usr2/app/oracle/admin/TIMSTEST/udump/timstest_ora_7587.trc: ORA-00600: internal error code, arguments: [15456], [AQ$_SUBSCRIBERS], [13], [7], [tdo generation], [], [], [] ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [], [] ORA-04045: errors during recompilation/revalidation of SYS.AQ$_AGENT ORA-00600: internal error code, arguments: [15456], [AQ$_AGENT], [13], [7], [tdo generation], [], [], [] ORA-00600: internal error code, arguments: [19502], [], [], [], [], [], [], [] Wed Jan 30 10:36:08 2002 TIA narender akula Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula 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: providing 24*7 database ---
- 2 original data from partitioned table SQL> select * from user_indexes; output snipped SQL> select * from user_part_indexes; output snipped SQL> drop table x; Table dropped. SQL> drop table y; Table dropped. SQL> spool off -Original Message- From: Narender Akula [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 5:30 PM To: Multiple recipients of list ORACLE-L Subject: providing 24*7 database --- hi gurus, Our shop ( GIS oracle spatials ) attempting to provide a production database (7x 24 hours) , currently we have to offline database for users while loading of data. we donot what users to access data while loading. We are thinking of provide 24* 7 services to customers with out going offline. What are the best possible solutions ? I had few but I donot know its right direction . Possible Solutions Replication - * not possible until Oracle 9i spatial (because of the restriction on replicating objects). * Even then expense of additional licensing/machinery may be too great Duplicate instances - have 2 instances and users switch from one to other after production load.-- how to implement ? Duplicate schema within current database. Have 3 schemas inside a single TIPSPROD instance. The schema with the current data remains in production until the second schema is loaded with the new data. This is can only work if we introduce a third schema that holds the views. At certain time, we redefine all the views in the DATAVIEWS schema. --- its kind of duplication --- certainly not my option Can some body direct me where to look or any ideas ? TIA > narender.akula > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula 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).
providing 24*7 database ---
hi gurus, Our shop ( GIS oracle spatials ) attempting to provide a production database (7x 24 hours) , currently we have to offline database for users while loading of data. we donot what users to access data while loading. We are thinking of provide 24* 7 services to customers with out going offline. What are the best possible solutions ? I had few but I donot know its right direction . Possible Solutions Replication - * not possible until Oracle 9i spatial (because of the restriction on replicating objects). * Even then expense of additional licensing/machinery may be too great Duplicate instances - have 2 instances and users switch from one to other after production load.-- how to implement ? Duplicate schema within current database. Have 3 schemas inside a single TIPSPROD instance. The schema with the current data remains in production until the second schema is loaded with the new data. This is can only work if we introduce a third schema that holds the views. At certain time, we redefine all the views in the DATAVIEWS schema. --- its kind of duplication --- certainly not my option Can some body direct me where to look or any ideas ? TIA > narender.akula > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula 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: Checking Oracle user Process in unix
kirti, user2(dcook) already running a shell script after login to mechine which invokes sql connection. dcook 27408 26250 0 11:46:27 pts/70:00 sqlplus tlcrsdev/tlcrsdev@crsprod @/home/dcook/TIPS/BDE/v1/tlcrs_load_tables FYI naren -Original Message- Sent: Thursday, 16 August 2001 14:21 To: Multiple recipients of list ORACLE-L User2 has not yet logged in after running sqlplus, when he connects oracle's shadow process will start. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Narender Akula [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, August 15, 2001 7:56 PM > To: Multiple recipients of list ORACLE-L > Subject: Checking Oracle user Process in unix > > hi List, > I am checking some oracle users (user1 and user2) processes (sunsolaris) > using ps -ef|grep. > > $ps -ef|grep sqlplus > user1 26671 5991 0 10:36:35 pts/20 0:00 sqlplus sys > me 27415 25766 0 11:47:36 pts/17 0:00 grep sqlplus > user2 27408 26250 0 11:46:27 pts/70:00 sqlplus > tlcrsdev/tlcrsdev@crsprod @/home/dcook/TIPS/BDE/v1/tlcrs_load_tables/lo > > checking oracle process...for user1 > $ps -ef|grep 26671 > user1 26671 5991 0 10:36:35 pts/20 0:00 sqlplus sys > oracle 26672 26671 0 10:36:38 ?0:00 oracleTERAPROD > (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) > > checking oracle process .. for user2 (running script for shell program- > updating table) > $ps -ef|grep 27408 >dcook 27408 26250 0 11:46:27 pts/70:00 sqlplus > tlcrsdev/tlcrsdev@crsprod @/home/dcook/TIPS/BDE/v1/tlcrs_load_tables/lo > > My question is for user2 why I am not able to see the oracle process. > > can somebody tell me what is happening here? am i missing something. > > > > narender.akula > > http://www.terralinkinternational.com > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Narender Akula > 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: Deshpande, Kirti 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: Narender Akula 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: Checking Oracle user Process in unix
Hi Babette, 1) the Instance and user2,user1 are on same mechine. so no dblink...no listener involved. 2) user1,user2 is not using any sql* net connections.but still for user1 shadow process shows but not for user2. the only difference is user1 is connecting explicitly (sqlplus username/password) and user 2 is connecting via shell scripts. (/BDE/v1/tlcrs_load_tables/x.sh --> sqlplus username/password). naren -Original Message- Sent: Thursday, 16 August 2001 14:16 To: Multiple recipients of list ORACLE-L Two possible reasons 1) crsprod (the database for the db link) is on a remote machine. In that case, the dedicated server will not show on this machine. 2) For SQL*net connections, the dedicated server sessions are created and owned by the oracle user. - Babette - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, August 15, 2001 8:55 PM > hi List, > I am checking some oracle users (user1 and user2) processes (sunsolaris) > using ps -ef|grep. > > $ps -ef|grep sqlplus > user1 26671 5991 0 10:36:35 pts/20 0:00 sqlplus sys > me 27415 25766 0 11:47:36 pts/17 0:00 grep sqlplus > user2 27408 26250 0 11:46:27 pts/70:00 sqlplus > tlcrsdev/tlcrsdev@crsprod @/home/dcook/TIPS/BDE/v1/tlcrs_load_tables/lo > > checking oracle process...for user1 > $ps -ef|grep 26671 > user1 26671 5991 0 10:36:35 pts/20 0:00 sqlplus sys > oracle 26672 26671 0 10:36:38 ?0:00 oracleTERAPROD > (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) > > checking oracle process .. for user2 (running script for shell program- > updating table) > $ps -ef|grep 27408 >dcook 27408 26250 0 11:46:27 pts/70:00 sqlplus > tlcrsdev/tlcrsdev@crsprod @/home/dcook/TIPS/BDE/v1/tlcrs_load_tables/lo > > My question is for user2 why I am not able to see the oracle process. > > can somebody tell me what is happening here? am i missing something. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood 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: Narender Akula 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).
Checking Oracle user Process in unix
hi List, I am checking some oracle users (user1 and user2) processes (sunsolaris) using ps -ef|grep. $ps -ef|grep sqlplus user1 26671 5991 0 10:36:35 pts/20 0:00 sqlplus sys me 27415 25766 0 11:47:36 pts/17 0:00 grep sqlplus user2 27408 26250 0 11:46:27 pts/70:00 sqlplus tlcrsdev/tlcrsdev@crsprod @/home/dcook/TIPS/BDE/v1/tlcrs_load_tables/lo checking oracle process...for user1 $ps -ef|grep 26671 user1 26671 5991 0 10:36:35 pts/20 0:00 sqlplus sys oracle 26672 26671 0 10:36:38 ?0:00 oracleTERAPROD (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) checking oracle process .. for user2 (running script for shell program- updating table) $ps -ef|grep 27408 dcook 27408 26250 0 11:46:27 pts/70:00 sqlplus tlcrsdev/tlcrsdev@crsprod @/home/dcook/TIPS/BDE/v1/tlcrs_load_tables/lo My question is for user2 why I am not able to see the oracle process. can somebody tell me what is happening here? am i missing something. > narender.akula > http://www.terralinkinternational.com > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula 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).
PERL PROGRAMMING
Hi gurus, We have Lot of PERL scripts. (Previous DBA). I am newby to perl . please suggest sites , to start. TIA naren -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula 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: extent management
hi hermanto, Do a export of table and use improt with indexfile option you will get nice initial extent with larger value. eg: imp scott/tiger file=scott.dmp full=y indexfile=tablex.sql modify the tablex.sql to your needs. HTH naren -Original Message- Sent: Thursday, 12 July 2001 14:45 To: Multiple recipients of list ORACLE-L Hi gurus, I have a problem with the table extent. Actually, the table extent growth too fast. Maybe I set the extent configuration wrong. So, I have to adjust the next extent almost every two months. Now the maxextents value already reach 80 (oracle 7.3). Is there anyone knows about how I should manage the extent of table ? What I have to do if I have reach 121 maxextents value ? Thanks before for your kind advise. Warm Regards, Hermanto P Application Engineer PT Riau Andalan Pulp And Paper - IT/IS Dept. Phone : (0761) - 95529 Ext. 1147 - 1266 HP : 0812-752-3092 "Our greatest glory is not in never falling but in rising every time we fall" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hermanto P 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: Narender Akula 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: view contents of datafile
hi joe, You can use Tablespace Map in OEM 2.2 (may be 2.1) and also you can reorganise them. or you can use TOAD ( tablespace Map). naren -Original Message- Sent: Thursday, 12 July 2001 11:45 To: Multiple recipients of list ORACLE-L If my tablespace became so big that it had 3 datafiles and became so fragmented, then I export and import the whole databse, how can I tell if the REORG only used up one or two datafiles. OR is there a utility to see contents of a datafile? Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph 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: Narender Akula 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 DIGEST INDEX ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula 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).
9i installtion -
Hi list, We are planning to upgrade 9i spatial Where I will find minimum hardware requirements for 9i ? how much memory usage compared to 8i ? we are looking at following option Sun workstation and BCL Rackmount disk & tape in RAID caddies Sun Blade 1000 Model 2750; DVD; 1GB Ram; 1 x 36GB 10,000rpm & 1 x 18GB FC-AL disks; Creator3D 2 x Rackmount systems, 6 x 18GB's and 2 x 36GB's 10,000rpm disks, Ultra3 Dual Channel controller I need to know what are best for 9i ? Any body has some figures > narender > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula 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: Implementing Stored Procedures
Title: Implementing Stored Procedures hi lisa, we do have staging area (dba -directory) in production where all the scripts ...(sql,forms,reports) are kept and with change request forms they are implemented... if any problems with the scripts they willl go to owner of change requester. And We use version control (PVCS, MS visual source safe) to track changes done to the prodecures and scripts. naren -Original Message-From: Yttri, Lisa [mailto:[EMAIL PROTECTED]]Sent: Friday, June 01, 2001 5:02 AMTo: Multiple recipients of list ORACLE-LSubject: Implementing Stored Procedures Hi - I'd like some advice on implementing stored procedures containing application logic (ie. written by developers). We have several applications where the developers use stored procedures for much of their coding. We let the developers create or replace their procedures in a development environment under their own schema (with access to all application tables, etc.) to test the logic, but it currently requires a DBA to implement the proc under the application schema. It has gotten to be a very time-consuming job. We don't want to give out the schema owner password to the developers, nor do we know of a way they could add them as the schema owner without giving them more privileges than we want. I am curious of how others are handling stored procedure additions and modifications. Do you somehow allow developers this access? If so, how do you restrict them from damaging other things? If not, does the DBA do it? Does anyone have an automated way? Also, do you keep track of the original "source code" for the procedure, or do you extract it out of the database as needed? Thanks so much for your input - Lisa
RE: Sun Solaris 8 - Listener failed to start a dedicated server p
Title: RE: Sun Solaris 8 - Listener failed to start a dedicated server p hi jacques, I have a similar issue quite some time back., when everything was fine at oracle level. Try finding problem at unix level. like memory being less, heavy swapping. In my case, it turned out to be unix memory problem. A reboot of unix box solved it. here are some of options to check.. Here are some options for an intermittent TNS-12500: Intermittent TNS-12500 errors are caused by a lack of resources on the server. Finding which resource is depleted may be difficult. 1. The TNS-12500 can be a result of the 'processes' parameter in the init.ora file being too low. 2. If the init.ora 'processes' parameter seems ok then you may need to increase the Unix kernel parameters for the maximum number of processes or users (for example, nproc or maxuprc). Check the manuals for the Unix operating system for more information on these parameters. 3. Check that you have adequate swap space. 4. Disable OTRACE. OTRACE is a tracing feature that can cause many problems. OTRACE is enabled by default. To disable OTRACE: a. Stop the Oracle database. b. Go to the $ORACLE_HOME/otrace/admin directory. c. Delete all files with a '.dat' extension. d. Restart the Oracle database. Oracle support recommenda this...5. Use the Multi-Threaded Server (MTS) option. MTS will fix the problem since the listener does not spawn dedicated server processes in this environment. MTS also cuts down on the amount of resources being utilized by having connections threaded through dispatchers and by having shared server processes read dispatcher requests from queues. To invoke MTS: a. Stop the database b. Modify the init.ora file to include these parameters: mts_dispatchers="," mts_max_dispatchers= mts_servers= mts_max_servers= mts_service= mts_listener_address= An example of a working MTS configuration would be: mts_dispatchers="tcp,3" mts_max_dispatchers=10 mts_servers=2 mts_max_servers=4 mts_service=ORCL mts_listener_address= "(address=(protocol=tcp)(host=mars1)(port=1521))" Please note for Oracle 8i the MTS configuration would be: mts_dispatchers = "(protocol=tcp)(dis=2)" mts_max_dispatchers = 4 mts_servers = 4 mts_max_servers = 6 local_listener = "(ADDRESS_LIST = (ADDRESS=(PROTOCOL=TCP)(HOST=mars1)(PORT=1521)))" c. Restart the database. if above options donot work check following things... Use the "truss" command to trace the system calls when you get the ORA-12500. Example: truss -f -o error.log sqlplus do you have any 32 bit versions and 64 bit database on the same box... rg naren -Original Message-From: eric harrington [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 2001 11:05 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Sun Solaris 8 - Listener failed to start a dedicated server p Jacques, I've seen a similar error with processes and Solaris memory structures. Someone mentioned increasing SEMMNS, this helped in my situation, however you can try decreasing the PROCESSES parameter temporarily (as low as possible) to test whether the Solaris memory setup is an issue. There is a formula for sizing SEMMNS, cannot currently find it. Good luck! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jacques KilchoerSent: Tuesday, May 22, 2001 5:26 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Sun Solaris 8 - Listener failed to start a dedicated server p Thank you for the suggestions so far. Rocky Welch suggesting increasing the "processes" parameter in the init.ora I tried that with one of the 8.1.6 databases. The "processes" parameter was set to 50, I increased it to 200, shut down that database, restarted the listener (lsnrctl>stop and lsnrctl>start) and restarted the database. I still got "ORA-12500: TNS:listener failed to start a dedicated server process" when trying to connect to that database from the client. John Kangaraj has suggested checking the number of semaphores. I forgot to mention before that I had already looked at that also (I've been bitten by semaphores before.) I counted 780 semaphores being used (from ipcs) and 1024 being the maximum allowed (from /etc/system). (see below) I'm still new to Sun Solaris and I'm totally stumped. Does anyone else have any other ideas? I really would prefer not running multi-threaded server (MTS) if I don't have to, which was one of the suggestions on Metalink. Am I interpreting the available memory information correctly? (see below) For physical memory, I think I see 4GB available and 622 MB being used. As far as swap, I see approx. 4GB available. semaphores In /etc/system I see this: set semsys:seminfo_semmns=1024 ipcs shows me this: $ ipcs -sa IPC status from as of Tue May 22 12:46:4
RE: how to make a file writable by anybody?
chmod ugo+w dbbackup_sched.dat where u user , g group, o other ... + to add, w for write. naren -Original Message- Sent: Tuesday, May 22, 2001 11:15 AM To: Multiple recipients of list ORACLE-L Hi all, How to make a Unix file writable by anybody? The file should be owned by dba, but also writable by non-dbas. -rw-rw-rw- 1 jcsora dba0 May 21 16:00 dbbackup_sched.dat -rw-rw-r-- 1 jcsora dba0 May 21 16:01 del_base_sched.dat Currently dbbackup_sched.dat file can be written by tester and other people, I'd like to make del_base_sched.dat the same thing. After I did chmod +w del_base_sched.dat, it only changes the 6th character to be w, but not the 9th. Thanks, Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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: Narender Akula 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: ??? strange database link problem
hi andrea, create using connect_data as in Tnsnames.ora. create database link test connect iccssowner indentified by icssowner using '(DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(Host = XYZ)(Port = 1521)) )(CONNECT_DATA = (SID = ORCL)))' then test... select sysdate from dual@test; HTH reg naren ORACLE DBA -Original Message- Sent: Thursday, May 17, 2001 3:31 PM To: Multiple recipients of list ORACLE-L Hi all, I tried to create a database link like this: create database link test connect icssowner identified by icssowner using 'AU40CNV'; when I used it, I got: ERROR at line 1: ORA-02085: database link TEST.WORLD connects to AU34TD.WORLD I created other links to AU40CNV, but I got that err again, the link ALWAYS goes to AU34TD.WORLD!!! why? Thanks Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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: Narender Akula 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: does oracle supports oracle 8.1.7. on sun solaris 8 (64bit) -
ya true, I contacted supported. according to them suppose to release in may but scehduled to june. narender -Original Message- Sent: Wednesday, May 16, 2001 7:11 AM To: Multiple recipients of list ORACLE-L (64bit) - pro I am confused again... I thought Oracle was developed on solaris, then ported to the other UNIX flavours? I would have expected them to have the latest version available for solaris before any other OS. Although lately they seem to be putting the emphasis on development for NT, which confuses me even more. 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]> -Original Message- From: paquette stephane [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 2:20 PM To: Multiple recipients of list ORACLE-L Subject:Re: does oracle supports oracle 8.1.7. on sun solaris 8 (64bit) - pro Oracle 817 is not available yet on Solaris. I asked Oracle support a while ago and they told me it would be for the beginning of may. I check yesterday at Oracle store and it was not available. I'll probably go for the 817 32bit. --- Narender Akula <[EMAIL PROTECTED]> a écrit : > > hi Gurus, > > I would like know wheather oracle supports oracle > 8.1.7. on sun solaris 8 > (64bit) ? Where do i find more info.I searched in > product life cycle in > metalink.. i could not find much info.. > can some body tell or where to look. > what are the pros and cons ? does any body had > problems or issues after > upgrade the OS from 7 to 8 ? > > > narender.akula > > http://www.terralinkltd.com > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Narender Akula > 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: 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: N
unable to create spatial index via dynamic_sql
hi list, I am able to create index from Sqlplus as... create index i_sptl_test on ADDRESSED_PROPERTY_(polygon_geometry) indextype is mdsys.spatial_index; Thisstatement works fine and I ma able to create index. But the same statement when executing through package - procedure p_crt_sptl_index ( it fails listed error messages. Of course by using Dynamic Sql. DDL Statement: create index i_sptl_test on ADDRESSED_PROPERTY_(polygon_geometry) DDL Statement: indextype is mdsys.spatial_index DDL Statement: ** Fatal Exception p_crt_sptl_index** ORA-29855: error occurred in the execution of ODCIINDEXCREATEroutine ORA-13231: failed to create index table [Create index table failed forI_SPTL_TEST_rt$] during R-tree creation ORA-29400: data cartridge error ORA-01031: insufficient privileges ORA-010 ** Fatal Exception incrt_metadata_entries ** *** p_crt_sptl_indexes: creation of SpatialIndex on ADDRESSED_PROPERTY_.polygon_geometry via p_crt_sptl_index failed *** Anybody got ideas why this is Oracle Saptial database 8.1.7 on sunsparc solaris 7. > narender.akula > http://www.terralinkltd.com > Oracle DBA, Terralink Limited > Wellington, NZ. > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula 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: strange problem
hi pat... thanks for info. I granted explicit previleges to user, narender -Original Message- Sent: Tuesday, May 15, 2001 2:50 PM To: Multiple recipients of list ORACLE-L > > hi gurus, > I am able to select from every hting from v$session at command line. > but when i write in procedure it fails why. > > SQL> select osuser from v$session where username = 'IMAGE_INDEX' and rownum > = 1; > > OSUSER > -- > MLOBO > this is ok... > > CREATE OR REPLACE PROCEDURE n2 IS > tmpVar varchar2(100); > BEGIN > select osuser into tmpvar from v$session where username = 'MLOBO' > and rownum = 1; > dbms_output.put_line ('name '||tmpvar); >EXCEPTION > WHEN NO_DATA_FOUND THEN >Null; > WHEN OTHERS THEN >Null; > END n2; > > this is failing says sys.V_$session must be declared. > what could be reason ? > How was select on v$session granted to user who owns the procedure? If via a role this is the expected result. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand 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: Narender Akula 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).
strange problem
hi gurus, I am able to select from every hting from v$session at command line. but when i write in procedure it fails why. SQL> select osuser from v$session where username = 'IMAGE_INDEX' and rownum = 1; OSUSER -- MLOBO this is ok... CREATE OR REPLACE PROCEDURE n2 IS tmpVar varchar2(100); BEGIN select osuser into tmpvar from v$session where username = 'MLOBO' and rownum = 1; dbms_output.put_line ('name '||tmpvar); EXCEPTION WHEN NO_DATA_FOUND THEN Null; WHEN OTHERS THEN Null; END n2; this is failing says sys.V_$session must be declared. what could be reason ? > narender.akula > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula 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).
does oracle supports oracle 8.1.7. on sun solaris 8 (64bit) - pro
hi Gurus, I would like know wheather oracle supports oracle 8.1.7. on sun solaris 8 (64bit) ? Where do i find more info.I searched in product life cycle in metalink.. i could not find much info.. can some body tell or where to look. what are the pros and cons ? does any body had problems or issues after upgrade the OS from 7 to 8 ? > narender.akula > http://www.terralinkltd.com > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula 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).
why index taking more space.
Hi gurus, I am try to create index on table ... and after esimating the size of index ... then I created the index the estimated size is different from actaul allocated size... I am missing something. Non unique index calculation: block size - 161 16384-161 = 16223 2) pct free of table 8% 16223 * (8/100) = 1297.84 3)avilable space to store index entries 16223 - 1297.84 = 14925.16 4)space used per row: avg.row length + no of columns + number oof long columns + 8 header bytes avg row size : select avg(nvl(vsize(rollno),0)) + avg(nvl(vsize(asses_no),0)) "avg length" from lis.parcel = 6.56 space used per row: 6.56 + 2 + 0 + 8 = 16.56 bytes 5) entries /block = trunc(14925.16/16.56) = 901 entries. 6) no of blocks needed = totno of rows/entries per block = 1874863 /901 = 2080.9 (approx) size of index = no of blocks * block size = 2080.9* 16384 = 32 mb aproximately around 32 -33 mb So when I created index CREATE INDEX VNZ_PARCEL_INDEX ON VNZ_PARCEL(ROLL_NO, ASSESS_NO) TABLESPACE LIS_IDX3 PCTFREE 5 STORAGE(INITIAL 56623104 NEXT 1048576 PCTINCREASE 0 ) ; and I cheked the size of index by going through the extents it is around 59 mb with 4 extens. Can some body explain me why the index space more than expected ? Am I missing some thing. regards naren -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula 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: export and import advise
hi rafiq, My question was other way round. Now I solved the poblem by creating dummy database of 7.3.4 version and from this version I connected to 8I insatance and created dmp file for client and it worked fine. narender -Original Message- Sent: Saturday, May 05, 2001 5:20 PM To: Multiple recipients of list ORACLE-L Yes, U r right. This method is used basically for migration. I was asked in an interview as to how I will do migration. I said, Export - Create DDL in Ora * - and import. The guy at the other end was a jerk - he says - why do u need to do a DDL? We need to do a DDL to take care of storage params. Correct me if I am wrong. Raj -Original Message- From: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Sent: Saturday, May 05, 2001 12:35 AM To: Multiple recipients of list ORACLE-L Subject:Re: export and import advise If you want to say that export dmp is under 7.3.4 to be imported in 8.1.7 database, You can import it without running any thing. If different operating systems like NT/UNIX, ftp file with binary option. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Thu, 03 May 2001 20:46:15 -0800 hi Gurus, One of myclients wants a import file (version 7.3.4) but our database is ver 8.1.7 . I know that for doing this I have to run expcat7.sql file against 8.1.7 database and run exp/imp utility on client database agianst our database using sql*net . But the problem here is the client is no way connected to our database. earlier before we upgrade both databases are at same level so there was no problems. has any one got other ideas. rgs > narender.akula > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram 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: Narender Akula 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).
V$RECENT_BUCKET and V$CURRENT_VIEWS
hi gurus, Are there any equivalent views in 8i ? If I want know the value (after increasing db_block_buffers). I know they are not suppported in latest versions ... but are there any alternatives to tune? > narender.akula > http://www.terralinkltd.com > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula 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).
export and import advise
hi Gurus, One of myclients wants a import file (version 7.3.4) but our database is ver 8.1.7 . I know that for doing this I have to run expcat7.sql file against 8.1.7 database and run exp/imp utility on client database agianst our database using sql*net . But the problem here is the client is no way connected to our database. earlier before we upgrade both databases are at same level so there was no problems. has any one got other ideas. rgs > narender.akula > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula 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).