Re: Replicating data from SYBASE to ORACLE

You really should check into Sybase Replication. Very powerful ( and complex ) replication product. It can replicate Sybase to Oracle. Jared On Wednesday 30 May 2001 18:25, Vikas Kawatra wrote: Anyone have any ideas about replicating data from SYBASE tables to ORACLE in real-time - We

Re: OT: Archiving not possible with SQL Server?

Are you an idiot? Jared On Wednesday 30 May 2001 14:55, Gary Weber wrote: Guess what happens when a long running transaction marks the log near the end, and not too long afterward the log needs truncated? If memory serves, ( hasn't worked too well lately :) the database will hang. It

RE: How to create 2 unique indexes (Field1, Field2) and (Field1,

Hi, I would like to thank those who replied. Yes, my problem has been resolved after removing duplicate values in the table. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City

need site address for Form and Reports discussion

Hi Here we can discuss about Dba related things, like wise any site to discuss about Forms and Reports -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Senthil Ganapathi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Replicating data from SYBASE to ORACLE

Thanks I have been reading up on the sybase replication I am not very hopeful though ! Concerns include the maturity of the product for replicating to 8.1.6 ,performance ,complexity etc vikas -Original Message- Sent: Thursday, May 31, 2001 12:01 AM To: Multiple recipients of list

How to encrypt Password in Export script file ?

Hi Unix Gurus, My daily export file (daily_exp.sh) contains : exp userid='system/password' file=file_name.dmp grants=y rows=y constraints=y compress=y full=y inctype=complete log=file_name.log The system password is stated clearly in the export script file. Has anyone encrypt/decrypt the

Pls how to install SQL LOADER

Hi, i'm having forms4.5 and repots2.5, i need to install SQL loader, pls give some idea for this -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Senthil Ganapathi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

what's hash-join

Hi Rukmini could tell me what's that hash-join GSK Rukmini DeviTo: Multiple

Re: How to send email from pl/sql in 806?

hi Jared, my execution cmd goes like.. EXECUTE SEND_MAIL('[EMAIL PROTECTED]','[EMAIL PROTECTED]','urgent','hello') it's giving the following error msgs.. ORA-04068: existing state of packages has been discarded ORA-04067: not executed, package body SYS.UTL_TCP does not exist ORA-06508: PL/SQL:

RE: Missing DDL?

Anita, Followed your suggestion BUT... does not seem to be working. The export log is showing that it exports tablespace definitions but using INDEXFILE parameter with Import utility does not seem to show the DDL for creating the tablespaces. Perhaps this is the way it is meant to be, I'd just

Re: 4 join methods?

There's an article by Tim Gorman, The Search for Intelligent Life in the Cost-Based Optimizer http://www.evdbt.com/library.htm where he talks about the CBO having knowledge about how the four methods of joining tables operate. I asked the question because I've only heard of nested loops, sort

RE: How many times has an index been used?

Hi, Thanks for the replies to this question. Looks like I need = 8i or trawl through the v$sqlarea either by spending money or writing a simple bit of pl/sql. Thanks, Steve Wilkes npower [EMAIL PROTECTED] -Original Message- Sent: 29 May 2001 14:03 To: Multiple recipients of list

RE: Database Links

Can I give a suggestion , how about create a unique user which will have all the link db , so much so that we will know where is the link come from , and it seen easily to manage ? Will it be a solution to this ? -Original Message- Sent: Thursday, May 31, 2001 2:46 PM To: Multiple

RE: Working with a BLOB

just a guess but try select dbms_lob.instr(blob_col, '.com') from atable where dbms_lob.instr(blob_col, '.com') between 0 an 75 -Original Message- Sent: 30 May 2001 23:30 To: Multiple recipients of list ORACLE-L I've been through the documentation on LOBs but am still stuck

Re: 4 join methods?

At 22:55 -0800 30/5/01, Rukmini Devi wrote: 1. Equi-join 2. Self-join 3. Outer-join 4. Hash-join Outer join is a logical type not an access method. the four types of join that Oracle can use: Nested Loops join Sort Merge join (equi-join only) Cluster join (equi-join on cluster key

ORACLE NAMES /LDAP

Anyone using this product as an alternative to Local Naming ? How about LDAP ? Any info /suggestions/comments are welcome vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: what's hash-join

A method of joining two tables. You scan each and use a hashing algorithm to isolate/match keys. hth connor --- Senthil Ganapathi [EMAIL PROTECTED] wrote: Hi Rukmini could tell me what's that hash-join GSK

No Subject

SET ORACLE-L DIGEST ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not

SQL TRACE

i have take trace file with SYS.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(sid,serial,TRUE). and trace file size is the 5MB but outpu of tkproff 31KB . is it normal.? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arslan Bahar INET: [EMAIL PROTECTED] Fat

RE: Script examples for NT. (yuk!)

Hi Greg, I came to NT world from VMS and was used to DCL. I find the following book a useful reference: Windows NT Shell Scripting 1-57870-047-7 HTH, Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon

RE: Pls how to install SQL LOADER

when you installed forms and reports you have the option to install oracle client database utilities ... they are installed with that option -Original Message- Sent: 31 May 2001 09:10 To: Multiple recipients of list ORACLE-L Hi, i'm having forms4.5 and repots2.5, i need to

RE: Analyze table and locking

Thought of trying this out... I analyzed a huge table in our system and simultaneously checked for locks... Oracle did not lock the concerned table being analysed, but aquired locks on sys tables for sometime, both in estimate and compute options. On oracle 8.1.7. rgds amar -Original

RE: Missing DDL?

Sean, You need to export with the full=y option to do this. Try it out with rows=n to test. Then do as Anita says and import with show=y. Cheers Lee -Original Message- Sent: 31 May 2001 10:25 To: Multiple recipients of list ORACLE-L Anita, Followed your suggestion BUT... does not

RE: OT: Archiving not possible with SQL Server?

Jared is having a bad day. : ) 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

Re: 4 join methods?

Where can I get the documentation for join methods ? rukmini - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 3:45 PM At 22:55 -0800 30/5/01, Rukmini Devi wrote: 1. Equi-join 2. Self-join 3. Outer-join 4. Hash-join

RE: Performance tuning

Database parameters were slightly changed for the second run and SGA was made only 140 MB. Loading was done without indexes and SQL loader parameters were changed to Readsize=10m, Bindsize=10m and Rows=5000. It took almost same time for about 21 hours but again it committed 8-10 times ( first

Re: 4 join methods?

the four types of join that Oracle can use: Ah ha. Thank you! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

How does Oracle use the parameter GLOBAL_DBNAME in listener.ora ?

How does Oracle use the parameter GLOBAL_DBNAME in listener.ora ? I faced this problem: Note: The SERVICE_NAMES parameter was set to SFA in the init.ora file File listener.ora is SID_LIST_JLISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = SFA) (ORACLE_HOME =

Test

_ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SRIVIDYA ARUN INET: [EMAIL PROTECTED] Fat City Network Services

Re: Snapshot Logs Explanation Needed

Tracy, You may know that there were no modifications to the master table made from the time the snapshot log was dropped until it was recreated, but Oracle can't take that chance, otherwise data could get out of sync. That's why you have to either recreate your snapshot or do a complete refresh

Re: querry..

select col1, col2 from table1 where (col1 = 'A' and col2 between 'A' and 'E') or (col1 = 'B' and col2 between 'A' and 'X') Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED]

Re: How to create 2 unique indexes (Field1, Field2) and (Field1, Fiel

Advice? Yes -- find out which records in your table have the duplicate combination of ACCTNO,PAYGRP and either delete the duplicate row, correct the problem row or don't create a unique index From: CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple

Re: 4 join methods?

And with all the hoopla that Oracle are spouting, I'm sure they'll be trying to convince us that (8i) partition wise join is a new type as well.. :-) Connor --- PD Miller [EMAIL PROTECTED] wrote: At 22:55 -0800 30/5/01, Rukmini Devi wrote: 1. Equi-join 2. Self-join 3. Outer-join 4.

Re: alter session set events 'immediate trace name redohdr level 10'

Linda, This information is covered in the Backup and Recovery Internals course offered by Oracle. In addition to the info provided by Riyaj, here are some more details: flg values: 0x01 log has been archived 0x02 no more space available in log 0x04 the next log to be used 0x08 the

Re: How to encrypt Password in Export script file ?

a) Changet the script to print system/password | exp full=y ... so no-one can see it with a 'ps' b) chmod 700 daily_exp.sh so no-one except the (presumably) oracle account can see the script hth connor --- CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] wrote: Hi Unix Gurus, My daily

Re[2]: 4 join methods?

I wonder if their thinking of the star join?? Dick Goulet Reply Separator Author: =?iso-8859-1?q?Connor=20McDonald?= [EMAIL PROTECTED] Date: 5/31/2001 5:00 AM And with all the hoopla that Oracle are spouting, I'm sure they'll be trying to convince

Re: How to encrypt Password in Export script file ?

instead of that, I create an account in the database that is identified externally (can only run from that server, and does not have a login password). You will need a matching Unix account for it, if the unix account is exportacct then create the database account as ops$exportacct grant this

RE: what's hash-join

Huh? Is this jeporady? Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Thursday, May 31, 2001 6:00 AM To: Multiple recipients of list ORACLE-L Probably a cartesian

Re:ORACLE NAMES /LDAP

Vikas, LDAP, NO. Oracle Names, YES. It's been just peachy. Dick Goulet Reply Separator Author: Vikas Kawatra [EMAIL PROTECTED] Date: 5/31/2001 1:05 AM Anyone using this product as an alternative to Local Naming ? How about LDAP ? Any info

RE: Analyze table and locking

It is a forum post I believe, I think I did a search on analyze lock. I have seen numerous articles were Oracle claims locking during analyze, that is the only one I found with quick parusal. Like many other things, Oracle is to blame on this old wives tale. Walking on water and developing

RE: Missing DDL?

Sean, Importing with INDEXFILE will show TABLE create statements as well as INDEX create statements but will not show TABLESPACE create statements. To get the tablespace create statements (this will not be a pretty output file!): imp userid=userid/password file=file log=show.log show=y

RE: Analyze table and locking

Yes, the library cache object is locked so it is not dropped during an analyze. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Thursday, May 31, 2001 5:25 AM To: Multiple

RE: Working with a BLOB

Sometimes the obvious isn't obvious... I had the bulk of the query but was just getting hung up on the 1st 75 bytes requirement. It never clicked with me that the instr( ) function in the dbms_log package already gave me a position and all I needed to do was simply constrain it with a between

Auto Extend

I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City

RE: querry..

hi well, one way to do it is to create a stored function create or replace package pkg_select is function cmb(p1 varchar2, p2 varchar2) return varchar2; end; create or replace package body pkg_select is function cmb(p1 varchar2, p2 varchar2) return varchar2 is begin if p1 = 'A' and

Rebuilding indexes

For those of you that have implemented a standby database, what method do you use to rebuild your indexes tablespace. My plan was to create a new tablespace and rebuild the indexes into the new tablespace and then reverse the process to move back to the original tablespace after I drop and

Re: Your views on Quest - Shareplex

Marc, You didn't mention the Oracle version, but I wouldn't be surprised if it was O7 as the serial push using the two-phase commit process doesn't scale well at all. The completely new architecture (AQ, parallel propagation, min communication, etc...) in O8 makes replication quite scalable

RE: what's hash-join

What's the performance (gain/loss) on such a join, when would you want to use one? Kev -Original Message- McDonald Sent: Thursday, May 31, 2001 6:00 AM To: Multiple recipients of list ORACLE-L A method of joining two tables. You scan each and use a hashing algorithm to isolate/match

DB2 vs Oracle

Hi people, A few weeks back somebody posted a message regarding an eval they are doing comparing Oracle/DB2/SQLServer. I came across a great document today for an Oracle/DB2 comparison, so if that person - sorry I can't remember who it was - is interested, contact me back channel, and I'll send

Re: querry..

Hey Saurabh, try using dynamic query as per your requirement. pp. hi list, how can i select two columns from a table based on condition that they are selected in specified combinations. let me.. table 1 has 2 columns col1, col2. both cols have values , say, alphabets. a,b,c,d,e,f,...

Re: Re[2]: About parallel server

Dick, Just curious, I can see putting the control file on a file system but I failed to see how can you put online redo logs on file system in OPS. Unless you are using distributed file system? How does one node do instance recovery for the failed node? Richard Ji [EMAIL PROTECTED]

RE: what's hash-join

Kev: How well a HASH join works depends on the data you are working with. In my experience it works best when you are joining a large table against a very small table. I've seen up to 50% improvement when I forced the optimizer to use HASH joins instead of Nested Loops or Merge Joins Kevin

Re: cannot drop snapshot with partition.

Sandesh, This is a known bug (1335477) that allows you to rename a snapshot/materialized view, which you shouldn't be allowed to do. What you've got now is data dictionary corruption because not all of the data dictionary entries were changed when the snapshot was renamed. You can try renaming

RE: backspace in Oracle.

No doubt Novell at the time was more stable than NT at the time. But some of these stories, which can start off as My Novell box seems more stable than that NT 3.51 SP 1 box mutate into internet apocrypha faster than you can spell telephone. Before you know it, it's a heartlung machine,

RE: 4 join methods?

Search this page for the word hash, you will find a good article on hash joins. http://www.itsystems.lv/gints/files/oracle/oracle.htm - Ethan Post -Original Message- Sent: Thursday, May 31, 2001 4:57 AM To: Multiple recipients of list ORACLE-L Where can I get the documentation for

RE: what's hash-join

It will perform better than sort and merge and nested loops in most cases. They tend to be fast. But will not out perform index nested loops in most cases. Although in some cases a sort and merge can out perform a hash join. Walking on water and developing software from a specification are

RE: OT: Archiving not possible with SQL Server?

Yeah? But you know what? After few hours with SQL manual I'm starting to feel like an idiot. Supreme Council says: All Aboard MS SQL! Me says: Abandon Ship! Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Patrice J Sent: Thursday, May 31, 2001 7:35 AM

RE: Rebuilding indexes

FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. Richard, You could always use the

RE: Unix File Open Port Open

you could also look into using the /proc filesystem. that's what it's there forsorry, but this'll be another RTFM drill, I don't have my unix web site available for easy clicking. || -Original Message- || From: Kevin Lange [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 31, 2001

RE: URGENT ODBC HELP REQUIRED

Title: URGENT ODBC HELP REQUIRED be something like this (check for errors): open database data1LOCAL lcCursorName, lnreturnlcCursorName = "SQLRESULT"gcODBCDataSource = 'odbcname'gcSQLUserID = 'oracleuser'gcSQLPassword = 'oraclepass' gnConnHandle = SQLCONNECT(gcODBCDataSource,

Oracle Applications

Still no response from Oracle Canada, I left a message again - they didn't know what to do when people order CD Packs... Meanwhile I saw on the 'net a job posting that had as one of the competency requirements: 4 years experience with Oracle Applications. I guess this is supposed to be funny.

RE: multiple versions of SQLPlus.exe [now evolved to: multiple versions of tnsnames.ora in NT/W2K]

Yup it is a string and not a key - thanks for pointing that out :) -Original Message- Sent: Wednesday, May 30, 2001 05:36 To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] If under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE you have one or multiple folders, like:

Re:About parallel server

Dick As far as I know, at least in Sun, sequent, hp and linux, you need to have control files and redo log files in raw disk. Every instance needs access to other thread's redo log files to do instance recovery for the failed instances. Only if the data is in the raw disk, multiple nodes can

RE: Database Links

Tracy, I have a similar deal going on here. If you are on version 8.1.x and the lookup tables are large, you can use Materialized Views, and since they are lookup tables that shouldn't change much, you should only have to refresh them every once in a while. If they are really small tables,

RE: need site address for Form and Reports discussion

[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') You may also send the HELP command for other information (like subscribing). list name: ODTUG-DEV2K-L rgds amar -Original Message- Sent: Thursday, May 31, 2001 11:31 AM To: Multiple recipients of list ORACLE-L Hi Here we can

RE: About parallel server

Title: RE: About parallel server Dick, What are you using for your source for this information? This does not jibe with other things I have read. If your not going to use a shared raw device for the online redo logs, how can one instance to instance recovery for another instance that

RE: ORACLE NAMES /LDAP

Vikas, I just implemented Oracle Names (8.1.6) for Verizon Wireless...corporate-wide. I've setup three ONAMES servers: 1. At Corporate Headquarters in NJ. This server contains the region database for ONAMES. It also serves as the Secondary ONAMES server corporate-wide. 2. In data center

RE: problem with trunc()

Title: RE: problem with trunc() Steve, we need to see you explain plan! Can you at least post an autotrace? it's possible you have wide range scans going on, even with an index. Send us your autotrace, the query does not have to execute in order for that to be done SET AUTOTRACE TRACEONLY

RE: Re[2]:Your views on Quest - Shareplex

Bear in mind, Oralce is not always 100% accurate, specially when something competes with their product. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, May 29, 2001

lsnrctl question

If I want to know the status of the external procedure listener for the current SID, but do not know what the external procedure listener's name is, how can I use lsnrctl to find out it's status. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn

Partition Elimination

Hi All, Can anyone help me with this. I have range partitioned a table (no indexes) and then computed statistics. I have now queried the table using the partition key as the only criteria in the where clause. Why does Oracle still do a full table scan, why is it not clever enough to only scan

RE: problem with trunc()

Doing that now. The last time I tried it hung out there for over 5 hours and I had to kill it for other reasons. Isn't there a faster analysis tool? It seems to be an Oracle Catch-22 that analyzing queries that take too long takes too long ... Steve Sapovits Global Sports Interactive

RE: OT: Archiving not possible with SQL Server?

Bet you aren't an idiot: bet you're suffering from Microsoft-induced aphasia. I hate MS's habit of taking perfectly good industry vocabulary and making the words mean too-specific proprietary things. Works in MS's favor: helps the MSCEs makes the rest of the world feel like idiots! As far as the

RE: what's hash-join

Title: RE: what's hash-join Hi Kevin, It's quick if you have the temp space to support it. however with larger tables my experience has been that it blows temp, isn't that much faster even if you do have the temp space, and in most cases you are better off with index-driven nested loops

Re: SQL*LOADER problem

Thanks Diana for letting me know about the replace function. A little more research and my problem was solved. Satish IyerDBACCSS Team 684-3016 [EMAIL PROTECTED] 05/30/01 07:50PM Satish,You can do a couple of things...in the query you could to areplace(column1, chr(10), '~') (or some

RE: How to encrypt Password in Export script file ?

I also did this on all my databases - works very slick. Julie Fisher Sandia National Laboratories Oracle 8i DBA - OCP8i Solaris 2.6,7/HP-UX 11.0 System Administrator Web Server Administrator -Original Message- Sent: May 31, 2001 7:20 AM To: Multiple recipients of list ORACLE-L

RE: Rebuilding indexes

You might be mistaken, since Oracle Manual (Oracle 8.1.5 Backup and Recovery) , chapter 16 -- Managing a standby database --- Adding Datafiles states the following: Adding a datafile to your primary database generates redo data that, when applied at your standby, automatically adds the datafile

RE: querry..

Saurabh, If you know your exact conditions and they don't change, you can write a select statement representing each combination and finally have a 'union' of all your sqls. HTH Prakash -Original Message- Sent: Thursday, May 31, 2001 4:50 AM To: Multiple recipients of list ORACLE-L

Listener problems

Has anybody come across the following error message in the listener.log, and know what the resolution is. TNS-12500: TNS:listener failed to start a dedicated server process TNS-12540: TNS:internal limit restriction exceeded TNS-12560: TNS:protocol adapter error TNS-00510: Internal limit

Suggestions on SCSI

Hi all, Just thought I would throw this one out there and see what all of you hot shots think. I am going to rebuild a server into a DB Server. Currently it has IDE drives in there and obviously I am not going to be using those. So I need to invest in some new SCSI drives. Here's what

LOGON TRIGGER

Hi, all we are using Oracle 8.1.7 and WebSphere on Solaris. We use a connection pool that allows 20 sessions from the app server to the database. In order to prevent anyone to connect to the datebase other than the app server, we would like to implement a security feature based on a LOGON

problem with trunc()

I have a query that contains these lines as part of the WHERE clause: WHERE trunc(it.transaction_date) = to_date('May-19-2001', 'Mon-dd-') This works fine -- the query returns in about a minute, which is what I'd expect for the table sizes, the rest of the joins, etc. Changing to the

RE: Oracle Applications

Finding Oracle DBAs with 4 years experience is tough enough...forget about 4 years experience with Apps!! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, May 31, 2001 10:51 AM To: Multiple recipients of list ORACLE-L Still no response from Oracle Canada, I

RE: Auto Extend

If the system is not setup to allow files bigger than 2 GB then the datafiles WILL NOT EXTEND and you will get an oracle error. -Original Message- Sent: Thursday, May 31, 2001 9:31 AM To: Multiple recipients of list ORACLE-L I have taken over an Oracle database that is setup with

Re: Rebuilding indexes

there IS no way to do that with a standby database. Once you open it for anything other than read-only (8i) you invalidate the standby status. From: Richard Huntley [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Rebuilding

Urgent: PL/SQL lock timer event

Hi, I need urgent assistance is resolving issues with PL/SQL lock timer. My query is waiting on this event more than an hour. waited duration is incrementing when I query v$session_wait. Do you know what this PL/SQL lock timer event is? why my query is waiting on this event for so long? How do

starting seperate external procedure listener

If I have a seperate external procedure listener does it get automatically started when the database is started?. If not how can I ensure it is started when the database is started. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL

RE: Update Query

Hi, I'm on DIGEST, so I don't know if that's been answered already, or not. But anyhow, what about: update ( select t.field1 f, t.field2 v, d.field1 g, d.field2 w from testtable1 t, testtable2 d where t.id = d.id) set f = g, v = w HTH Dieter Buecherl From: Eric D. Pierce [EMAIL PROTECTED]

Re: 4 join methods?

There is certainly something new called an index join around in 8i. [EMAIL PROTECTED] wrote: I wonder if their thinking of the star join?? Dick Goulet Reply Separator Author: =?iso-8859-1?q?Connor=20McDonald?= [EMAIL PROTECTED] Date:

RE: How to send email from pl/sql in 806?

Saurabh; Have you looked at ALL of the packages involved ?? Does the SYS.UTL_TCP exist and does the ID using SEND_MAIL have the correct access to it ?? (I know these are basic questions, but its usually the basic ones that get us first !) Kevin -Original Message- Sent: Thursday, May

RE: problem with trunc()

I have always been told that using functions on fields would stop the efficient use of indexes so . what if you said WHERE it.transaction_date BETWEEN to_date('May-19-2001.00.00.00', 'Mon-dd-.hh24.mi.ss') AND to_date('May-28-2001.23.59.59', 'Mon-dd-') This would

Re: Rebuilding indexes

Adding a datafile does not cancel recovery - you just need to 'pause' it, transport the appropriate files to the standby and resume standby operations. hth connor --- Richard Huntley [EMAIL PROTECTED] wrote: For those of you that have implemented a standby database, what method do you use to

RE: problem with trunc()

You seem to have lost your sig. Are you no longer a 'Wanton Kickboxing Goddess'? ;-) Todd Carlson Oracle 8i Certified DBA Bunge North America -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: Auto Extend

Depends is the standard answer. Oracle can handle files over 2g, some unixes can, some unixes cannot, some say they can but cannot etc etc... To compound things, in some versions, Oracle will let the file go beyond 2g, only then to complain because the unix won't let Oracle get to the bits

RE: DB2 vs Oracle

I wouldn't mind a copy of that doc Mark? -Original Message- Sent: 31 May 2001 13:34 To: Multiple recipients of list ORACLE-L Hi people, A few weeks back somebody posted a message regarding an eval they are doing comparing Oracle/DB2/SQLServer. I came across a great document today for

RE: Unix File Open Port Open

The only I know of way to see which process has a port open in Solaris is to use lsof (there's a package on sunfreeware.com -- including source). netstat and /proc aren't enough as far as I can see... It's not clear what exactly you need to know, but hope this helps... Steve -Original

RE: Listener problems

Out of space on the file system I believe. -Original Message- Sent: Thursday, May 31, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Has anybody come across the following error message in the listener.log, and know what the resolution is. TNS-12500: TNS:listener failed to

Re: Auto Extend

Hi, When using autoextend always set max size and monitor. Turn off auto extend if a small possibility exists to do so. Check if your OS has large file size enabled and there won't be any problems. jack

RE: lsnrctl question

On unix you can look for the process running the listener. In our shop this is done by : $ ps -ef | grep tnslsnr oracle 413 1 0 May 18 ?2:36 /u03/home/oracle/product/8.0.5/bin/tnslsnr listener.1526 -inherit oracle 447 1 0 May 18 ?0:08

Re: what's hash-join

And it will skip partitions that it can see will not match any other corresponding partition. PD Miller wrote: At 0:16 -0800 31/5/01, Senthil Ganapathi wrote: could tell me what's that hash-join Straight from the concepts manual: To perform a hash join, Oracle follows these steps: 1. Oracle

  1   2   3   >