FAQ

Oracle > oracle-l > October 2002

Search Discussions

592 discussions - 2,708 posts

  • In my company, we require Oracle D.B.A. to maintain development and production Oracle databases. This is a permanent position. Our compnay is 24 yrs. old company. Our company is situated on Route 128 ...
    Rao.rao_at_attbi.comRao.rao_at_attbi.com
    Oct 2, 2002 at 3:50 pm
    Oct 2, 2002 at 5:39 pm
  • Gurus! Any docs / URLs / do's don'ts / tips for 8.1.6 to 8.1.7 upgrade? I have gone throught the metalink docs and Oracle Documentation. Thanks, -Rachna -- Please see the official ORACLE-L FAQ ...
    Rachna VaidyaRachna Vaidya
    Oct 1, 2002 at 3:48 pm
    Oct 2, 2002 at 2:58 am
  • Hi Gurus, Hardware: HP rp5470 OS: HP-UX 11i (11.11) Oracle Version: Enterprise Edition 9.2.0.1.0 I'm in the process of installing Oracle 9.2.0.1 and while the DBCA is trying to create and start the ...
    Scott StefickScott Stefick
    Oct 30, 2002 at 10:03 pm
    Oct 31, 2002 at 11:48 pm
  • I always like to create my databases by hand via the create database statement. However, whenever a new version comes out I use the dbca assistant to generate the create database script so I can see ...
    Adams, Matthew (GECP, MABG, 088130)Adams, Matthew (GECP, MABG, 088130)
    Oct 31, 2002 at 7:41 pm
    Oct 31, 2002 at 10:40 pm
  • Reboot and open a TAR. Jared "Sinardy Xing" Sent by: root_at_fatcity.com 10/31/2002 12:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L cc: Subject: RE: Unkillable Background ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Oct 31, 2002 at 7:44 pm
    Oct 31, 2002 at 10:40 pm
  • Solaris 8 Oracle 8.1.7.3 We have a field level_id defined as raw(5) in a table called objects. I can pull data from this table from sqlplus as follows: select name, obj_id, level_id from objects ...
    Baker, BarbaraBaker, Barbara
    Oct 31, 2002 at 5:49 pm
    Oct 31, 2002 at 8:28 pm
  • I am having problems getting OS authentication to work on a Win2K oracle server (8.1.7.1.1). All parameters are set properly (from what I can see). There cannot be a prefix so the following parameter ...
    Mike SardinaMike Sardina
    Oct 30, 2002 at 5:24 pm
    Oct 31, 2002 at 7:40 pm
  • Dear Friends, Does anybody help me to defrag / reorganise the user tablespaces which is large in size. Is there any script for that ? If available can somebody send it to me ? Regards, Pradeep ...
    Pradeep_at_ibsplc.comPradeep_at_ibsplc.com
    Oct 31, 2002 at 12:13 pm
    Oct 31, 2002 at 4:28 pm
  • Friends I would like to know about snapshots. Can I create a index on snapshot ? How to do it ? Why refresh with rowid is not recomended ? How to do when master table doesn't have a PK ? Regards ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Oct 31, 2002 at 1:03 am
    Oct 31, 2002 at 2:03 pm
  • the only way i see it can work is to implement a snapshot in the remote database and create a trigger there. regards Paulo -----Original Message----- Sent: quarta-feira, 30 de Outubro de 2002 15:09 ...
    Paulo GomesPaulo Gomes
    Oct 30, 2002 at 3:38 pm
    Oct 30, 2002 at 6:20 pm
  • Hello What are the limitations of partitioning a table in Oracle. Regards, Deepa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: PK_Deepa/VGIL_at_vguard.satyam.net.in ...
    PK_Deepa/VGIL_at_vguard.satyam.net.inPK_Deepa/VGIL_at_vguard.satyam.net.in
    Oct 30, 2002 at 8:43 am
    Oct 30, 2002 at 5:39 pm
  • Hi all I need to record the time, sun process id and oracle proc id when a user connects. This needs to be done via a trigger, does someone have something like this handy, I am battling trying to ...
    Leonard, GeorgeLeonard, George
    Oct 22, 2002 at 6:44 pm
    Oct 30, 2002 at 4:23 pm
  • Ups colegas !!!!! @lex Lic. Alexander Ordóñez Arroyo Soporte Tru64Unix & BD Oracle Caja Costarricense del Seguro Social Telefono: 295-2004, San José, Costa Rica Aordonez_at_ccss.sa.cr Celular ...
    Alexander OrdonezAlexander Ordonez
    Oct 24, 2002 at 7:05 pm
    Oct 29, 2002 at 9:38 pm
  • Hello, I have a problem and I hope you can help me. We have a Oracle 9 installation two users with two different default tablespaces. The problem is to move data between theese two users with ...
    Adrian CiocildauAdrian Ciocildau
    Oct 29, 2002 at 8:18 am
    Oct 29, 2002 at 4:13 pm
  • Guys, which is the best......9i Release 1 or 9i Release 2 ? my company has decided to move to 9i. so cost does not matter. the environment is win2k. please let me know. TIA. -- Please see the ...
    Oraora oraoraOraora oraora
    Oct 28, 2002 at 10:03 am
    Oct 28, 2002 at 5:18 pm
  • Dear Listers, Given below is a script that I execute from within SQL*Plus for WinNT: temp.sql: set echo off set pagesize 0 set feedback off SELECT * FROM tab WHERE ROWNUM < 10; set pagesize 1000 set ...
    Charu JoshiCharu Joshi
    Oct 24, 2002 at 4:24 pm
    Oct 28, 2002 at 1:28 pm
  • copy the init.ora look at the size of the redo logs, size of the datafiles. make all the directories on the new machine. Wait, how did you create the first database? I'm 99% sure you didnt type ...
    Joe TestaJoe Testa
    Oct 26, 2002 at 1:03 pm
    Oct 27, 2002 at 3:54 am
  • I often met SQL phrase in sql scripts as "ALTER SESSION SET EVENTS '...' " for example: ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT FOREVER, LEVEL 10'; (Oracle 8.1.7.3 patches install ...
    Michael IvanovMichael Ivanov
    Oct 25, 2002 at 4:44 pm
    Oct 26, 2002 at 12:48 am
  • Is there any way to do pattern matching in a PL/SQL trigger? In other words, if I had two strings and one ended with a character (ie. "g") and one ended with a number, is there a way to search for it ...
    Mike SardinaMike Sardina
    Oct 25, 2002 at 7:39 pm
    Oct 25, 2002 at 8:09 pm
  • Has anyone started using the Oracle streams feature? I'm wondering how this compares to Advanced Rep. I am guessing this approach will provide better performance but thought I'd check with the list ...
    David TurnerDavid Turner
    Oct 24, 2002 at 9:30 pm
    Oct 25, 2002 at 12:18 am
  • Hi DBAs, Does anyone have a table & index sizing utility program/script they can share? Also where can I find out exactly how much storage Oracle allocates for every datatype? I checked the concepts ...
    Rick_Cale_at_teamhealth.comRick_Cale_at_teamhealth.com
    Oct 24, 2002 at 8:35 pm
    Oct 24, 2002 at 10:54 pm
  • To do an import from a full export of a database, do the tablespaces already need to be set up before the import? How can you query the database to get the tablespace name and the total space needed ...
    Mike SardinaMike Sardina
    Oct 24, 2002 at 7:25 pm
    Oct 24, 2002 at 8:29 pm
  • Environment: Oracle 8.1.6 AIX server behind a firewall db is accessed by a Windows application running on a IIS web server sitting outside the firewall db uses port 1521 After a flurry of email ...
    DonDon
    Oct 24, 2002 at 6:13 am
    Oct 24, 2002 at 11:53 am
  • Hello, How to get the ROWID of the rows being updated in an After update statement trigger ? Thanks in advance, Deepa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET ...
    PK_Deepa/VGIL_at_vguard.satyam.net.inPK_Deepa/VGIL_at_vguard.satyam.net.in
    Oct 22, 2002 at 8:23 am
    Oct 23, 2002 at 10:38 pm
  • Hi All, When looking at v$latch it gave me the following stats for 'redo copy' GETS: 35 MISSES: 21 IMMEDIATE_GETS: 326975 IMMEDIATE_MISSES: 65 according to my understanding 'redo copy' is required ...
    Naveen NahataNaveen Nahata
    Oct 22, 2002 at 10:54 am
    Oct 23, 2002 at 8:05 pm
  • Hello All, We are running oracle 9.2 on a sun box in a DW env. Data loads are thorugh informatica. During one such load of fact table, the load time per sec is about 300 rows per sec. The table is ...
    Sat0789_at_fastmail.fmSat0789_at_fastmail.fm
    Oct 23, 2002 at 4:30 pm
    Oct 23, 2002 at 5:54 pm
  • Hi, DBA Guru, I have a stored procedure of a package which is called with "execute immediate" in a loop with runtime input parameters. I found that no. of parse calls(451983) is equal to no. of ...
    Chuan ZhangChuan Zhang
    Oct 23, 2002 at 7:43 am
    Oct 23, 2002 at 5:08 pm
  • Our data warehouse return this mysterious result: SQL select * 2 FROM v$sysstat 3 WHERE name = 'physical reads' 4 or name = 'db block gets' 5 or name = 'consistent gets' 6; STATISTIC# NAME CLASS ...
    Ofer HarelOfer Harel
    Oct 22, 2002 at 11:18 am
    Oct 23, 2002 at 4:30 pm
  • Hi, I have table x with 2 columns: ID1 ID2 ---- ---- 1 0 1 5 2 0 2 10 I want to update ID2, set the 0s to the other value for the same ID1. So, i would have: ID1 ID2 ---- ---- 1 5 1 5 2 10 2 10 Whats ...
    Imran AshrafImran Ashraf
    Oct 23, 2002 at 9:33 am
    Oct 23, 2002 at 3:15 pm
  • We have ORACLE 8.1.7 running on server. My question is what difference on following select statement: select col1 form table1; select all col1 form table1; Look like output are the same. Thanks. Surf ...
    Dist cashDist cash
    Oct 23, 2002 at 1:28 pm
    Oct 23, 2002 at 2:18 pm
  • Hi I create a table as follows: create table a ( a number(1)); Then I create index as : create index ia on a(a desc); If i see the index columns as : select index_name, table_name, column_name, ...
    Rahul MehendaleRahul Mehendale
    Oct 22, 2002 at 1:58 pm
    Oct 22, 2002 at 8:00 pm
  • I wonder if anyone could provide me with some insight on a problem our Sr. DBA is facing. We are trying to install Oracle 8.1.7 SE Release 3 on Win2K Server but our DBA believes that the problem lies ...
    Saira SomaniSaira Somani
    Oct 22, 2002 at 3:09 pm
    Oct 22, 2002 at 3:49 pm
  • When we compile this package body, we are getting the error - PLS - 00323. Please help. Platform: Solaris 7. Oracle 8.1.6. Package is getting created without any errors. When we try to compile ...
    Maheswara.rao_at_sungard.comMaheswara.rao_at_sungard.com
    Oct 21, 2002 at 8:43 pm
    Oct 21, 2002 at 10:03 pm
  • Except in the case of maintenance on rollback segments. You can take a private segment offline at anytime, whereas a public one has to be done with the database unmounted. Dick Goulet ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Oct 17, 2002 at 4:46 pm
    Oct 17, 2002 at 8:59 pm
  • This is something I'm not sure can be done. Can somebody help me out? I have a single table with a DEVICE_TYPE field, and four views - one for each valid device type. DEVICE_TYPE is a NOT NULL ...
    Vergara, Michael (TEM)Vergara, Michael (TEM)
    Oct 17, 2002 at 12:23 am
    Oct 17, 2002 at 3:24 pm
  • Anybody get the web client to work. I launch from ie 5.5 and get a window that "console applet has been launched" but nothing happens. In apache error log is: [Wed Oct 16 12:36:04 2002] [error] ...
    Jeffrey BeckstromJeffrey Beckstrom
    Oct 16, 2002 at 7:40 pm
    Oct 16, 2002 at 9:19 pm
  • To ALL, The following came in the mail this morning. I visited the web site (www.topcoder.com) and find it somewhat odd, but!!! It could spawn into a lot of things, like sparing on a database ...
    Dgoulet_at_vicr.comDgoulet_at_vicr.com
    Oct 15, 2002 at 2:23 pm
    Oct 15, 2002 at 5:34 pm
  • hi! 8.1.7. on WIN: due to a bug - it seems - the following query returns an error: SQL SELECT TO_CHAR(SYSDATE, 'dd.mm.yyyy') from dual; SELECT TO_CHAR(SYSDATE, 'dd.mm.yyyy') from dual * ERROR at line ...
    Daniel WisserDaniel Wisser
    Oct 15, 2002 at 9:03 am
    Oct 15, 2002 at 4:55 pm
  • Santosh. Putting a subject on your e-mails is useful to everyone I suggest you look at sqlloader. There are some good pages on the FAQ associated with this site http://www.orafaq.com ...
    John.Hallas_at_vodafone.co.ukJohn.Hallas_at_vodafone.co.uk
    Oct 10, 2002 at 11:44 am
    Oct 11, 2002 at 5:13 am
  • Hi all, does anyone know a good site or have good white papers or presentations concerning physical storage recommendation for different size Oracle databases... and also for different platforms ...
    Joshua BeckerJoshua Becker
    Oct 10, 2002 at 5:23 am
    Oct 11, 2002 at 12:28 am
  • Hi, Is there any way to identify values in a field, defined in Oracle as number(11,2), with a packed decimal format? Or to update the field with packed decimal values? Thanks, Russ -- Please see the ...
    Brooks, RussBrooks, Russ
    Oct 9, 2002 at 7:09 pm
    Oct 10, 2002 at 6:05 pm
  • I'm trying to use RMAN and TSM to backup multiple databases spread across various nodes with some nodes hosting more than one database. The RMAN catalog database will reside on a node different from ...
    MacGregor, Ian A.MacGregor, Ian A.
    Oct 9, 2002 at 10:13 pm
    Oct 10, 2002 at 1:28 pm
  • Hi, Solaris 8, Oracle 9i listener It seems that anyone who has a login on Solaris can shut the listener down. I have tried with a non-dba userid and could stop the listener. The default file ...
    Long.Nguyen_at_csiro.auLong.Nguyen_at_csiro.au
    Oct 8, 2002 at 5:43 am
    Oct 9, 2002 at 11:08 pm
  • Hi, Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? I need to clone Oracle Applications 11I from one machine (source ...
    CHAN Chor Ling Catherine (CSC)CHAN Chor Ling Catherine (CSC)
    Oct 9, 2002 at 7:13 am
    Oct 9, 2002 at 9:33 pm
  • How would I find out the exact SQL statement? I can locate the SQL_ADDRESS from the v$session table but I do not know where to go from there. I am running a query via an OLAP tool (Cognos Impromptu) ...
    Saira SomaniSaira Somani
    Oct 8, 2002 at 7:08 pm
    Oct 9, 2002 at 1:33 pm
  • Hi everyone, A developer who is working on an application to retrieve data from an 8.1.7 database using ODBC asked me this question, "Are the connection handles for the odbc version 8.1.7.6 shareable ...
    Rodrigues, BryanRodrigues, Bryan
    Oct 4, 2002 at 9:23 pm
    Oct 9, 2002 at 12:48 am
  • FYI, I think Coriolis no longer exists. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services ...
    Boivin, Patrice JBoivin, Patrice J
    Oct 7, 2002 at 2:44 pm
    Oct 8, 2002 at 2:18 pm
  • List Is it possible to pass a comma seperated list of variables to make up a portion of the in clause in a stored procedure I have a list of variables IdList that looks like this ...
    Bob MetelskyBob Metelsky
    Oct 7, 2002 at 4:53 pm
    Oct 7, 2002 at 6:49 pm
  • Guys, i want to clone DB1 on host HOST1 to HOST2. i have installed oracle on HOST2 with the default DB created. the disk layout on HOST1 is different from that of HOST2. the environment is ...
    Oraora oraoraOraora oraora
    Oct 7, 2002 at 9:33 am
    Oct 7, 2002 at 3:00 pm
  • All Im trying to run the following statement EXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE) And get the following error ERROR at line 1: ORA-06550: line 1, column 7: PLS-00201: identifier ...
    Bob MetelskyBob Metelsky
    Oct 3, 2002 at 6:18 pm
    Oct 6, 2002 at 5:08 pm
Oct 2002
1…34567…12
Group Navigation
period‹ prev | Oct 2002 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions592
posts2,708
users383
websiteoracle.com

383 users for October 2002

DENNIS WILLIAMS: 106 posts Jared.Still_at_radisys.com: 95 posts Tim Gorman: 79 posts Rachel Carmichael: 70 posts Deshpande, Kirti: 65 posts Dgoulet_at_vicr.com: 53 posts Yechiel Adar: 50 posts Jamadagni, Rajendra: 49 posts Naveen Nahata: 47 posts Fink, Dan: 45 posts Mercadante, Thomas F: 44 posts Jesse, Rich: 43 posts Rajesh.Rao_at_jpmchase.com: 38 posts Igor Neyman: 37 posts Gogala, Mladen: 36 posts Ray Stell: 35 posts Connor McDonald: 33 posts Grabowy, Chris: 31 posts Paquette stephane: 31 posts Rick_Cale_at_teamhealth.com: 31 posts
show more
Archives