RE: OEM Book Recommendation

I am afraid I have seen 0, Nada, Zilch on OEM. Even the Oracle based instructions are prety bad. The best source yet has been the online manuals. At least they are searchable. -Original Message- Sent: Wednesday, May 30, 2001 1:37 PM To: Multiple recipients of list ORACLE-L Rahul !

RE: Problems with CharArrayType after upgrade from 7.3.4 to 8.1.7

VARCHAR is the older version. VARCHAR2 is for 8.0 and above. Changing from VARCHAR to VARCHAR2 for 8.1.7 will solve the problem. -Original Message- Sent: Wednesday, May 30, 2001 11:47 AM To: Multiple recipients of list ORACLE-L 8.1.7.1 Cherie, I have no idea if this could be the

RE: Is DBMS_OBFUSCATION free in Enterprise Edition?

It is free - very definite answer :-) Alex Hillman -Original Message- Sent: Wednesday, May 30, 2001 2:02 PM To: Multiple recipients of list ORACLE-L We have Enterprise Edition 8.1.7.1 on Sun Solaris 2.6. My manager needs a definitive answer. Is DBMS_OBFUSCATION free with this

RE: Build an exact copy of a database using export / import

Title: RE: Build an exact copy of a database using export / import A full export is supposed to allow for a full recovery. Thus, if you do a full export, the import will try to create all the tablespaces that existed when you exported. That is the first item in the export file (see below).

RE: Analyze table and locking

At 8:10 -0800 30/5/01, [EMAIL PROTECTED] wrote: In earlier versions (7.3 ?) 'analyze ..compute' used to take table level locks. From 8 onwards, compute or estimate does not take any table level or row level locks at all... Sorry, not true. From at least 7.2.3 (the oldest I have here) there

RE: Archiving not possible with SQL Server?

Correct. SQL Server can have multiple transaction logs (I discovered this last week while reading so I am correcting a previous post of mine here), but these inevitably fill up. You then either do a backup log filename to device truncate only to clear the log. This is the equivalent of running

RE: Is DBMS_OBFUSCATION free in Enterprise Edition?

Free...unless you look at the TCO (Total Cost of Ownership). ;-) Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Wednesday, May 30, 2001 3:51 PM To: Multiple recipients of list ORACLE-L It is free - very definite answer :-) Alex Hillman -Original Message-

Re: OT: Effective Living

as a descendant of (english) indentured servants, i say let those freaking idiots burn in hell until the end of time. until you understand the concept of social death (Dr. Orlando Patterson, Harvard) that underlies the institution of slavery, you can't understand the significance, and limits,

RE: OT: RE: Fire your DBA's you don't need them anymore...

Thanks...after checking this site, I find out that I'm paid LOTS more than most of those bozos out there... 8-) [EMAIL PROTECTED] 05/30/01 01:16PM Yeah, I think they've got a retention problem, since the money is better outside, and consultants have a good idea of what they're being billed

RE: Performance tuning

Yes, Agreed. Raid of any level will not change the number of writes in terms of DBWR. But will change how many physical reads and writes needed to implement parity and data to the disks. Walking on water and developing software from a specification are easy if both are frozen. Christopher R.

RE: OEM Book Recommendation

Technet if i remember has some good things on OEM. I generally never use it. Although it does have some nice features. But I remember seeing some good docs on it. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA

Re: Build an exact copy of a database using export / import

On Wed, May 30, 2001 at 08:25:44AM -0800, Smith, Ron L. wrote: When I build a new test database I create the database and run all the required Oracle scripts. Then I do a full import of a production export. This works pretty well but I miss some of the grants and The full import wants to

Connection auditing

I am interested to find info about connections with wrong userid/password - which userid/password were used and other tns errors. For example if tnsnames group use wrong sid - it will be recorded in listener.log. I did not try tracing - maybe somebody did it alredy. Alex Hillman -- Please see

Fwd: RE: Would you increase the shared pool? --URGENT

Hi Christopher, thanks for answering 1. I would check to see if the buffer busy waits are on the same file/block. Perhaps the same object is being hit constantly. I would also base my action on the type of block being waited on. I'm doing exactly this, mostly of my waits are data block waits

RE: Build an exact copy of a database using export / import

Nechama Glasrot Oracle DBA Seisint, Inc. 6601 Park of Commerce Blvd. Boca Raton, Florida 33487 nglasrot @seisint.com mailto:[EMAIL PROTECTED] Direct 561.999.3977 Main 561.999.4400 Fax 561.999.4695 -Original Message- Sent: Wednesday, May 30, 2001 1:57 PM To: Multiple recipients

Update Query

Seems like Oracle Doesn't have to the query like this: update tablea set firstname=tableb.firstname, lastname=tableb.lastname where tableb.id = tablea.id; I can have one, it works if it has a match for the two tables, otherwise the two columns updated to null: update tablea set

RE: RE: RE:

Dam_...my tractor broke. -Original Message- Spence Sent: Wednesday, May 30, 2001 1:50 PM To: Multiple recipients of list ORACLE-L Actually I say: You know what the farmer said when the cow died? Geesh, it never did that before. Walking on water and developing software from a

RE: Effective Living

LOL!! Now that sounds like fun. Just immagine the frustrated users and damagers running around trying to deal with that answer! Rodd Holman Original Message On 5/30/01, 2:12:06 PM, Kevin Kostyszyn [EMAIL PROTECTED] wrote regarding RE: Effective Living: Yeah, but just because something

Re: Effective Living

What did the Buddhist say to the hotdog vendor? Make me one with everything. (Sorry that was from Motherless Brooklyn which I just finished reading.) Denise Gwinn [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City

RE: Build an exact copy of a database using export / import

Thanks! Ron -Original Message- Sent: Wednesday, May 30, 2001 3:08 PM To: Multiple recipients of list ORACLE-L A full export is supposed to allow for a full recovery. Thus, if you do a full export, the import will try to create all the tablespaces that existed when you exported. That

RE: OEM Book Recommendation

Technical libraries section under metalink has white papers, manuals etc on OEM packs. hth, Prasad Christopher Spence [EMAIL PROTECTED]@fatcity.com on 05/30/2001 04:21:20 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L

Re: Connection auditing

Hillman, Alex wrote: I am interested to find info about connections with wrong userid/password - which userid/password were used and other tns errors. For example if tnsnames group use wrong sid - it will be recorded in listener.log. I did not try tracing - maybe somebody did it alredy.

RE: Build an exact copy of a database using export / import

Title: RE: Build an exact copy of a database using export / import Let me rephrase that first sentence... A full export is supposed to allow you to recreate your base entirely at the point of export. A bit different from a "full recovery" which means all transactions to the point of failure

RE: Analyze table and locking

Oracle actually claims this statement. There are numerous docs stating this, for example DOC ID: 213220.999. But I agree 100% with Jeremiah's claims, in fact it can be verified very easily looking at v$lock while analyzing a large table. (I have actually done this in the past and present) and

RE: Analyze table and locking

nice to see you posting again :) Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 4:03 PM To: Multiple recipients of list ORACLE-L At 8:10 -0800

RE: OT: RE: Fire your DBA's you don't need them anymore...

This is a problem that not many people put their data. I did not do it myself for couple of years. Alex Hillman -Original Message- Sent: Wednesday, May 30, 2001 3:31 PM To: Multiple recipients of list ORACLE-L Thanks...after checking this site, I find out that I'm paid LOTS more than

RE: backspace in Oracle.

Oh come on Ross, it wasn't running solitaire for seven years, it would have been brought to it's knees in a month if solitaire was open! -Original Message- Sent: Wednesday, May 30, 2001 3:26 PM To: Multiple recipients of list ORACLE-L Kim, Did you hear the one about the NT box that

RE: Effective Living

We could implement it and be the inventors of a new kind of DBA theory. The hands off DBA. When it breaks you can tell us, by are not going to tell you why it broke, it's just broke, deal with it. -Original Message- Sent: Wednesday, May 30, 2001 3:37 PM To: Multiple recipients of list

Re: Update Query

ha, ha. you got bit by the null update thing too, I remember it well! :) except for maybe some newfangled oracle8 features, the ugly one is the traditional way the manual says to do it (iirc). I have many many scripts with that kind of code in them since we load mainframe datafiles into the

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

Title: alter session set events 'immediate trace name redohdr level 10' Hello, I'm looking for documentation to name and label the output from the dump of redo headers and logs. For example, siz: 0x5000 seq: 0x1087 hws: 0x2 bsz: 512 nab: 0x5001 flg: 0x0 dup: 2 The size parameter is

Re: Archiving not possible with SQL Server?

Actually, MS transaction log(s) combine the functions of Oracle's redo logs and Rollback segments (and that's bad). As for archiving - nop, no archiving in MS SQL Server. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients

RE: RE: Would you increase the shared pool? --URGENT

Responding to item 4 and 5. 4) I would recommend doing this at beginging of instance startup or fresh after pool flush. I am not a fan of pinning everything that moves, although sizing them sp with this in mind doesn't pose any notable problems I know of. 5) I would look at v$sql and

Job remove?

Hi I have some job which is available in dba_jobs_running but it is not available in dba_jobs How can I remove these job? Thx -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official

RE: Update Query

if it was for one column you could use nvl or decode update tablea set firstname=nvl((select firstname from tableb where tablea.id=tablea.id), firstname); Alex Hillman -Original Message- Sent: Wednesday, May 30, 2001 3:56 PM To: Multiple recipients of list ORACLE-L Seems like Oracle

Resolved: Yes, DBMS_OBFUSCATION is free in Enterprise Edition

Thanks to all who replied. Since all replies were a strong yes, I will tell my manager a definitive yes. Thanks again, Cherie Diana_Duncan@ttpa

RE: backspace in Oracle.

I personally vouch for the machine running Novell for 6 years, I built it. It was taken down about 3 months ago. It happened to be a server use to store drivers and os builds to zap down to machines as they are being built at PC manufacture. Walking on water and developing software from a

RE: Analyze table and locking

Oracle actually claims this statement. There are numerous docs stating this, for example DOC ID: 213220.999. But I agree 100% with Jeremiah's claims, in fact it can be verified very easily looking at v$lock while analyzing a large table. (I have actually done this in the past and present) and

RE: random equipment seen ???/ RE: V$SESSION.OSUSER returns NT-D

oh yeah, I want one of these... of course, my cats, American shorthairs, have all been over 16 pounds anyway (mom feeds them good she does!) From: Eric D. Pierce [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: random

RE: Analyze table and locking

Yes, thats true... you need a lock on an object only when you are changing the object. So, analyze table does not have anything to do with locks.. Rajaram. -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 4:31 PM To: Multiple

RE: backspace in Oracle.

I am all for NLMs, DLMs, and MM. But, if you let me bounce most any NT box once a month for, say, a DEFRAG, I'll be able to keep it up for one helluva long time too. Ross NMN Mohan || -Original Message- || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, May 30,

RE: backspace in Oracle.

It kept trying to win. It couldn't || -Original Message- || From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, May 30, 2001 4:31 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: backspace in Oracle. || || || Oh come on Ross, it wasn't running solitaire

Re: OT: Archiving not possible with SQL Server?

I'd get frantic phone calls from the programmers... in the version of Sybase we were using (4.something), truncate actually archived off the log info. But it needed to write to the log. If the log was full, I had to trash it and then pray that nothing went wrong before I could get a full

RE: Performance tuning

I am impressed. Alex Hillman -Original Message- Sent: Wednesday, May 30, 2001 5:18 PM To: Multiple recipients of list ORACLE-L You are above average in awareness, so one would have to work harder than normal to slip something by you. In my fractured metaphor, early-ness in the

RE: OT: Archiving not possible with SQL Server?

-Original Message- Sent: Wednesday, May 30, 2001 1:03 PM To: Multiple recipients of list ORACLE-L Oracle's archived logs = MS transaction log dump files. If you enable truncate log on chkpt, the transaction log will be truncated every time there is checkpoint. Another way to do is to

Re: OEM Book Recommendation

The only book that I've found that touches the OEM in an ok way is ORACLE8 on Windows NT by Lilian Hobbs ISBN 1-8-190-0 begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL

App/web login - how do you handle?

How do you handle logins for applications that log into the database using a common login? I've seen it handled through hard-coded username/pass in the app, password file in 'secure' directories and ops$ account with remote_os_authent set to true on a server being accessed from a 3rd tier web

RE: Your views on Quest - Shareplex

I verified this today actually. I had a conference call with Quest regarding SharePlex, and asked specifically about the chained rows. They said there is a reorganization step on the target database, so chained rows are not a problem. Jim Jim Hawkins Lead SAPR/3 Oracle Database

RE: OEM Book Recommendation

as in: Installation Guide for Enterprise Manager with Change Mangement, Diagnostics, and Tuning Pack(pdf, 129879 bytes) Installation Guide for Oracle Enterprise Manager with Management Pack for SAP R/3 Release 2.2.0 for Windows NT, Windows 95 and Windows 98(pdf, 144481 bytes)

RE: OT: Archiving not possible with SQL Server?

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 may just truncate back to the mark, and start from there, but you always have the

RE: Your views on Quest - Shareplex - Thank you all

Thank you all for giving your time to express your opinions. I would be consolidating all the opinions I received in the list and send a mail within the next two days. I hope, this consolidation would help for any future queries on this subject. Thanks, Rao [EMAIL PROTECTED] -- Please see

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

Hi Linda Welcome to Oracle! I am aware that db2 has wealth of documentation and manuals, but you would n't find these information any where in the Oracle documentation.. Anyway , here is the info that you are looking for: Again, this is from my memory so use caution.. siz: Indicates the size

RE: backspace in Oracle.

compaq Pentium 133Mhz 128Mb, 6 raid disks if I remember correctly. two disk failures over the life of the box if memory serves correct. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original

RE: App/web login - how do you handle?

Our method was as follows: 1. Give each user an ID on the system.. a very limited ID. 2. The ID would have roles that were given to it but were password protected . This way the user could not log into something like SQL+ and see the tables (it was secured radiation dose level

RE: Job remove?

dbms_job.remove(job#); (AS the owner of the job) Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 4:59 PM To: Multiple recipients of list ORACLE-L

Working with a BLOB

I've been through the documentation on LOBs but am still stuck trying to figure out how to interrogate the contents of a BLOB. We have a table with a BLOB column in it. All it contains in text data (i.e. memo notes). Why it was created as a BLOB and not a CLOB is unknown to me and done before I

Re: OT: RE: Fire your DBA's you don't need them anymore...

And for those of us looking now, we know where the market is going, and Oracle's salaries are getting more in line with everyone else's anyway. I'm about to start looking. Curious to know where you believe the market is going. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: Your views on Quest - Shareplex - Thank you all

Title: RE: Your views on Quest - Shareplex - Thank you all If anyone wants to learn more about SharePlex for Oracle by Quest Software, I will be hosting an interactive conference call next Wednesday. This technical presentation describes SharePlex and how it offers live, up-to-the-minute

Installing Oracle on UNIX

We have oracle 8.1.6 installed on our SUN server .As part of the upgrade process to 8.1.7 (we decided to install into a new HOME)- I staged the 2 CD's into one of our free disks (not the existing oracle home) .Now to run the Installer - I took the following steps: cd $ORACLE_HOME ( obviously

Re:RE: Your views on Quest - Shareplex

Jacques, Your last statement is one place where I will agree on the superiority of SharePlex to Oracle's replication. In my experiences under replication a transaction will take longer than it should since you have to complete that transaction on the remote system as well as the local.

RE: Analyze table and locking

Sorry but it is true. I have a 7.3.3 database and if it can't acquire a table lock it cannot do the compute. -Original Message- Sent: Wednesday, May 30, 2001 1:03 PM To: Multiple recipients of list ORACLE-L At 8:10 -0800 30/5/01, [EMAIL PROTECTED] wrote: In earlier versions (7.3 ?)

RE: alter session set events 'immediate trace name redohdr level

Hi Riyaj, Thank you!It's very nice to be here among such kind and knowledgeable people. I appreciate the definitions. I'll write again as I move through the log maps, as I'm sure other questions will arise. Regards, Linda -Original Message-From: [EMAIL PROTECTED]

RE: OT: Archiving not possible with SQL Server?

In Sybase, you can just dump tran to a file device, that should clear the log and keep a copy of it in case you need point in time recovery. you shouldn't just truncate it -Original Message- Carmichael Sent: Wednesday, May 30, 2001 2:33 PM To: Multiple recipients of list ORACLE-L

RE: Analyze table and locking

It could be a bug with my version... I don't think it actually keeps a lock but it wants to be able to get the lock. For the most part we don't get our analyzes in due to this. Fortunately for me, we no longer want to and have deleted the stats. -Original Message- Sent: Wednesday, May

Re: Analyze table and locking

On May 30, 2001 03:21 pm, Jeremiah Wilton wrote: I have used compute statistics since version 7.3.2 up through 8.1.6, and never had it hold a table lock for the duration of the analyze. I don't know where people are getting the idea that compute statistics holds a lock and estimate doesn't.

Re:About parallel server

Fernando, Replies included in your original mail, but in addition: Parallel server is a separately priced option from Oracle and it is pricey. Second you may need specific software from you OS vendor to coordinate the file sharing between the servers, again an additional expense. Dick

Snapshot Logs Explanation Needed

I would like to reorg many tables which have snapshots associated with them. I understand that if the master table is dropped the snapshot log is also dropped. When a log is dropped, oracle states that you need to do a complete refresh of the affected snapshot. My question is why? If you do

RE: Working with a BLOB

Walter; The package that comes with Oracle, DBMS_LOB, has functions to Append, Compare, Copy, Erase, GetLength, INSTR, LoadFromFile, Read, Substr, Trim, and Write BLOBS.You should probably try starting from that one. Oracle Built-In Packages from Oriely Press (ISBN 1-56592-375-8) Chapter

Re: Working with a BLOB

All I need to do is determine if a particular string ('.com') pattern exists in the column, within the first 75 bytes, and return its starting position. The secret is the built-in DBMS_LOB.INSTR. Haven't actually run this code, but something along these lines ought to work: DECLARE

Database Links

We have several large look-up tables that we use in development as well as in production environments. The data is the same in both environments. I am looking for some comments regarding whether or not we store duplicate data in each environment or should we allow the development users to

RE: Installing Oracle on UNIX

You need to execute the runInstaller.sh script from a location other than the CD. ie: /export/home/oracle$ /cdrom/runInstaller.sh Your device is locked since you are physically in the device where you started from. This is documented in Metalink, but not in the readme docs that come

RE: Installing Oracle on UNIX

You have to run the installer for the new version of Oracle. It should be on the CD (or the directory you copied the cd to) Kevin -Original Message- Sent: Wednesday, May 30, 2001 6:30 PM To: Multiple recipients of list ORACLE-L We have oracle 8.1.6 installed on our SUN server .As

RE: multiple versions of SQLPlus.exe [now evolved to: multiple ve

I've actually had better luck setting it as a (system) environment variable rather than in the registry. Depends what software you are using to (eg OEM 2.0.4 did not work with the environment variable). Regards, Bruce -Original Message- Sent: Thursday, 31 May 2001 5:07 To: Multiple

RE: Installing Oracle on UNIX

Thanks Holman ! I was able to rsolve it by running the installer from the staging area on DISK -where I copied the 8.1.7 CD .I was running the installer from my 8.1.6 HOME - and hence the problems -Original Message- Sent: Wednesday, May 30, 2001 4:10 PM To: Multiple recipients of list

RE: Snapshot Logs Explanation Needed

Been a while since I worked with snapshots, but if I remember correctly, each record in a fast refresh snapshot keeps a mapping back to the rowid on the master. If you drop and recreate the master table, the mapping is hosed and updates/deletes do not propagate to the snapshot. Brian Norrell

RE: About parallel server

Title: RE: About parallel server Several things: You will have to re-license (your honest aren't you) for the faster machines and OPS; Build the new database on raw and export/import. Maybe dd would get your datafiles from cooked ufs to raw but it's to much FUD for me; You can backup

RE: About parallel server

Title: RE: About parallel server Your point 1: Unless things have changed redo and controlfiles must be raw. When I took the OPS course several years ago and worked with OPS we needed the redo/controlfiles to be on raw so that one instance could recover when another instance failed. Your

Re: Database Links

We have several large look-up tables that we use in development as well as in production environments. The data is the same Developers shouldn't work against production tables. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED]

Re: Job remove?

Bismillah Hi Seema ! Any Jobs in DBA_JOBS_RUNNING Shows the jobs which are currently being run by oracle. To remove these enteries you have to kill the sessions which are running those jobs manually using : alter system kill session 'sid,serial#'; Hope it help you. Regards Your DBA Salman

Re: About parallel server

Fernando, You will need cluster manager and shared disk drives to build this cluster. You need at least Oracle 8.1.6 or 8.1.7 Solaris 2.6 Sun Cluster Manager 2.2 Some volume manager preferably Veritas 2.2.1+ or 3.0.4+ Solaris 8 (2.8) Sun Cluster Manager 2.2 or 3.0 ( If you use SC 3.0 then

RE: Job remove?

Hi Christopher ! dbms_job.remove (job#) Remove an existing job from the job queue.But it does not stop a job if it is currently running. Comments ! Best Regards Your DBA Salman Faheem --- Christopher Spence [EMAIL PROTECTED] wrote: dbms_job.remove(job#); (AS the owner of the job)

RE: Your views on Quest - Shareplex

Title: RE: Your views on Quest - Shareplex -Original Message- From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] The person giving the presentation on Shareplex stated that there could be no chained rows when the sharepex file, apparently analogous to the log miner dictionary file

NT-Oracle memory, page file, ...

Windows 2000 Oracle product line: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=111040.1 - http://technet.oracle.com/tech/nt/rdbms/rdbmswin.htm ---excerpt--- Oracle8i on Windows NT/2000: Architecture, Scalability, and Tuning April, 2000

OT: Unix File Open Port Open

Hello, This is an off topic, UNIX question. Can any one please tell me how to get the Unix File Open and Port Open in SCO or AIX, or SUN? I am not sure whether they are part of sar output, so please help. I am not sure whether I can get this kind of information. thanks every one in advance.

URGENT ODBC HELP REQUIRED

Title: URGENT ODBC HELP REQUIRED Hi dba's, I want to communicate between Oracle 8 and Clipper.I want to get data from Clipper/Foxpro Dbf file into oracle through ODBC. can anybody guide me how to do that. Any links, ? TIA Arslan

(Fwd) NT./yuk! (scripting)

http://groups.google.com/groups?hl=enlr=safe=offgroup=alt.msdos.batch.nt --- Forwarded message follows --- [ via Date sent: Wed, 30 May 2001 16:48:22 -0400 Send reply to: Windows NT/2000 Discussion List [EMAIL PROTECTED] To: Recipients of WINNT-L digests [EMAIL PROTECTED] ] Date sent:

RE: How to drop unique index

Thanks to all who replied. The command Drop Unique index_name works. 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 Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

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

Hi Gurus, How do I create 2 unique indexes (STDID,PAYGRP) and (ACCTNO,PAYGRP) on the same table ? I created the first index successfully but encountered the error ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found when I tried to create the 2nd index. SELECT

RE: Job remove?

Oh, I don't think I saw that part. Find the sid from dba_jobs_running and alter system kill session or kill the unix process. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 5/30/01 8:15 PM Hi Christopher ! dbms_job.remove (job#) Remove an existing job from the

RE: Analyze table and locking

Christopher, Is this document perhaps a TAR as I cannot find it on Metalink (but maybe the search engine doesn't like me today). Do you have the exact URL for this note 213220.999? Thanks, Bruce -Original Message- Sent: Thursday, 31 May 2001 6:59 To: Multiple recipients of list

4 join methods?

Hi, I just read there are four join methods. I know three: Nested loops Sort merge Hash join What's the fourth? - Greg -- 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)

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

Hi, The second index failed because of dups found. You will need to check the data and correct them before creating the index. The following should tell you which ones have dupl. values and how many occured: SELECT ACCTNO,PAYGRP,count(*) from SPY_ADHOC_PAYMENT group by ACCTNO,PAYGRP having

RE: URGENT ODBC HELP REQUIRED

Title: URGENT ODBC HELP REQUIRED What version of Oracle? What OS? If the need is one off maybe use MS Access to link both Oracle and Clipper via ODBC. If regular need and on 816 or above on NT then you can use Heterogeneous services. See Metalink notes: I found note 114820.1 helpful

Re: SQL*LOADER problem

Satish, You can do a couple of things...in the query you could to a replace(column1, chr(10), '~') (or some other unlikely character or string), then do a replace again in the SQL*Loader script to get the carriage returns back in there. Or you could use the query to put a character in the

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

Title: RE: How to create 2 unique indexes (Field1, Field2) and (Field1, Fiel -Original Message- From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]] How do I create 2 unique indexes (STDID,PAYGRP) and (ACCTNO,PAYGRP) on the same table ? I created the first index

Re:About parallel server

Even more importantly, if you are planning on implementing parallel server just to increase your processing power then you are going to be in trouble! If you haven't specifically designed your application for parallel server, you can end up DECREASING performance by increasing locking and

RE: backspace in Oracle.

One thing for sure... it was not in CA !! Or was it ? - Kirti -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Subject: RE: backspace in Oracle. Now *that's* details. So, what

Re[2]: About parallel server

Brian, I was looking at parallel server for an application we were developing last year. In 8.1.6 at least the control and on-line redo (not rollback segment) files no longer had to be on raw devices. And I stand corrected, there is one and only one standard unix command that does

Re: 4 join methods?

i feel the fourth one is self join. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 8:10 AM Hi, I just read there are four join methods. I know three: Nested loops Sort merge Hash join What's the fourth? -

RE: 4 join methods?

Hi Greg, Maybe they consider Cartesian as 4th method ? :-) Ed Hi, I just read there are four join methods. I know three: Nested loops Sort merge Hash join What's the fourth? - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Re: Database Links

Tracy, Allowing developers to muck around in your production system is not generally a good idea. If you create db links for them, that's what they will be doing. In addition, have you ever managed an environment like that? I have and it's not pretty. How will you administer the privileges?

<    1   2   3   >