Re: How to encrypt Password in Export script file ?

put your userid and password and all other parameters in parfile and run. exp parfile=abc.parfile It will hide your password on unix level. your password file should be readable by you only... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]

RE: How do I corrupt a block

Do a "dd" on unix and change the contents of any particular block. -Original Message-From: novicedba [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 31, 2001 2:16 PMTo: Multiple recipients of list ORACLE-LSubject: How do I corrupt a block hi,   This  may sound funny. I wa

Re: Resizing Log file

Add some new ones, drop the old ones... hth connor --- Nirmal Kumar Muthu Kumaran <[EMAIL PROTECTED]> wrote: > hi dba's, > > In my DB, oracle 816, NT4, the redolog member's > size is only 50kb. I'm > having only two groups with a single member each. > > I tried with alter database command, t

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

"CHAN Chor Ling Catherine (CSC)" wrote: > > 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 t

RE: ORACLE NAMES /LDAP

OiD is a "separately licensable product"...not included as part of the DB license. If I remember correctly, you have the UPU license calculation or a per entry license @ $50/, with 5000 entries being the minimum!! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday

Re: Snapshot Logs Explanation Needed

Hi Tracy, Oracle still won't let you do a fast refresh if the creation time stamp on the snapshot log is more recent than the creation time stamp or last complete refresh of the snapshot. An attempt to do so will generate the dreaded ORA-12004: "REFRESH FAST cannot be used" (see note 1035524.6 "

RE: OT: Archiving not possible with SQL Server?

HELP I have no sense of humour : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Gary Weber [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 4:50 PM To: Multiple recipients of list ORACLE-L Subject:

RE: ORACLE NAMES /LDAP

Hi, Actually, it's not so bad. OiD is licensed separately ONLY when used as general purpose directory service. Check Metalink Note:135696.1 "13. Do I need to license OID when deploying the directory for NET8 ? Answer -- No, deploying OID for NET8 is free of charge." Vadim Gorbounov Oracle

RE: Oracle 8.1.7 and Apache

Ken, (FYI, I used a version of Apache (1.3.12) that came from Apache's web site, not the version that came with Oracle. And my web servers and database servers are on different machines. And my web servers are running Kerberos and SSL. And I still can't believe it all works together.) Check A

Re[2]: Re[2]: 4 join methods?

Jared, Yes and No. As I understand them it uses both a merge and a hash join, but then you know marketing types!! BTW: that was a guess on my part too. And yes, I do need to RTFM to be sure. Dick Goulet Reply Separator Author: Jared Still <[EMAIL P

No Subject

SET ORACLE-L DIGEST = Hamid Alavi 4268 Flintlock LN Westlake Village 91631 PH: 818-8790966 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORAC

RE: Suggestions on SCSI

Kevin, You did not state the OS you will be using. If it is a flavor of LINUX them 3ware makes a ISA card that will handle disk drives like they were SCSI drives. You save the high cost of disks and spend it on the card. But I bought 2- 40 GIG WD drives last week for $109.00 each and put them i

Re: Partition Elimination

The docs actually do a good job of showing what the explain plan will look like for a partition elimination. Look at the 'Explan Plan' chapter of 'Designing and Tuning for Performance' Are you using ?/rdbms/admin/utlxplp.sql to examine your explain plan? Jared On Thursday 31 May 2001 09:00,

Re: Implementing Stored Procedures

Just to be more specific, the product you'd look for is the "Oracle Accelerator" for Kintana, see the URL here http://www.kintana.com/products/accelerators/oracle_technologies/oracle_technologies.htm Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 9

RE: Auto Extend

By the way ... For your own sake . never use data files that big !!My personal opinion is multiple files of 500 Megs or less . Or, on a system that has a file limit, 1 GB files as a Max. Larger than that and you can have problems with backup software long running FTPs if yo

RE: Rebuilding indexes

Jeremiah, Thanks -- I knew someone would know better than me how to do this! Another post to save for when I get to have a standby db again :) Rachel >From: Jeremiah Wilton <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject:

RE: Auto Extend

On our old AIX system we had to set a system parameter for the file system that allowed us to have files bigger than 2 GB. I do not know if your system has something like that. -Original Message- Sent: Thursday, May 31, 2001 2:29 PM To: Multiple recipients of list ORACLE-L What do you

Re: OT: Archiving not possible with SQL Server?

You mean like the programmers of the Oracle Applications? What would we need for that, a missile? (What kills me is that, they don't use declared foreign key constraints in the database. Presumably, since the code base is so old, if they introduced them now everything would break. You'd think

Re: Re[2]: 4 join methods?

On Thursday 31 May 2001 06:41, [EMAIL PROTECTED] wrote: > I wonder if their thinking of the star join?? > > Dick Goulet Isn't that actually just a sort merge? Just guessing here, didn't RTFM. No flames please! :) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

RE: OT: Archiving not possible with SQL Server?

Title: RE: OT: Archiving not possible with SQL Server? I protest Jared's removal from the list for telling jokes!    Henry please reconsider!  :) --Chris [EMAIL PROTECTED]     -Original Message-     From:   Gary Weber [SMTP:[EMAIL PROTECTED]]     Sent:   Thursday, May

OT: web page counter needed

Hello, sorry for this OFF-OFF-OFF... topic question. I'm looking for a counter which counts all visited pages, not just current page visited. thanks... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat

RE: TOAD v/s PL/SQL Developer

There is a massive concern here about the cost of Toad. Since it is so high we have been forced to get only a few licenses only give it to the most prolific users. This is the pits ! If you have an alternative I would ABSOLUTELY APPRECIATE any information you have on it !! Kevin -Origina

RE: Auto Extend

OK .. Never is a harsh word.Depending on your environment and in my opinion based on the environments I was in I still say never. -Original Message- Sent: Thursday, May 31, 2001 3:31 PM To: Multiple recipients of list ORACLE-L Never say never :) I opted for 4 GB files

RE: SQL TRACE

Merhaba, If aggeragate=false, which is not default, SQL statement length does not make sense since each SQL are same lenght in raw file and output. in addition to Ed, check your output. If there ara a lot of kernel calls such as parse,fetch, etc. row file will be larger than output. regards.

RE: Rebuilding indexes

Hello, Richard, If you want to use NOLOGGING operation on primary database, this is still possible to keep STANDBY in sync. Regularly check output of select FILE#, UNRECOVERABLE_CHANGE# from v$datafile; on primary and standby database, and , in case UNRECOVERABLE_CHANGE# on

RE: Auto Extend

On Thu, 31 May 2001, Kevin Lange wrote: > By the way ... For your own sake . never use data files that big > !!My personal opinion is multiple files of 500 Megs or less . Or, on a > system that has a file limit, 1 GB files as a Max. Larger than that and > you can have problems w

RE: select question

Title: RE: select question > -Original Message- > From: Ron Rogers [mailto:[EMAIL PROTECTED]] > > If you know the size of the number (in position count not > value) you can use the RPAD(sum(field),count,0) to populate > the right end of the return value to zero.  > ex. the sum valu

RE: select question

Lisa - I liked your old signature better :). >>> [EMAIL PROTECTED] 05/31/01 03:17PM >>> I believe you'll want to rpad your return value. select rpad(26.5,5,0) from dual returns 26.50 or format it in SQL*Plus. HTH > Lisa Koivu > Oracle Database Administrator > 954-935-4117 > > The informat

RE: Auto Extend

I am running multiple Oracle 7.3-8i databases on NT. Is there someone on this forum who can answer my question:which parameter I need to set up to increase the file size limit? I have a feeling there may not be one. I was told by one of the super-senior Oracle people :-) there is an Oracle (not

Rebuilding indexes(simple way)

Hi Friends I have 20Gb Table with 3 indexes each 3,6,6Gb size. Recenly we deleted some 2 yrs data from it. So I want to rebuild the Indexes..Iam planning add some datafiles to it and just rebuild it, so that the new and old indexes fits easily. Is there any better way??? Thanks Raghu

Re:RE: About parallel server

Matt, I know I read that somewhere and yes it could also have referenced a different OS. If I manage to find the reference I'll happily share it with the rest of the group, I'm just so in vacation mode right now that I really don't give a *&^%. But, I will admit that the docs on MetaLink sa

RE: DB2 vs Oracle

Mark, I'd like to have a copy of that document too.. - Uma -Original Message- Sent: Thursday, May 31, 2001 3:24 PM To: Multiple recipients of list ORACLE-L Ditto -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 10:16 AM To: Multiple recipients of list

RE: 4 join methods?

No, Oracle 8i will actually merge indexes and perform a pseudo join when possible without going to either table directly. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Th

Tablespace Allocation Type & Extent Management

I seem to be confused about the relationship between tablespace management and allocation methods. What is the USER allocation_type (as reported by DBA_TABLESPACES)? I thought this corresponded only to dictionary-managed tablespaces--I see it associated with locally-managed tablespaces as well.

Re:TOAD v/s PL/SQL Developer

Kirti, Have used both, do not really have a preference. Dick Goulet Reply Separator Author: "Deshpande; Kirti" <[EMAIL PROTECTED]> Date: 5/31/2001 11:38 AM Folks, Just got an e-mail from my Damager that there is a concern about the cost of TOA

Re: deadlock error in oracle8.1.7 on sun solaris

Hi, It's most likely that you should change your code. If you need furher help, please attach trace file. -- Web: htpp://www.unal-bilisim.com Questions and Answers: http://www.unal-bilisim.com/qa/discus/index.html Seema Singh wrote: > Hi > Some time I am receiving the following informatio

RE: ORACLE NAMES /LDAP

Interesting...Oracle must have changed their minds on this issue. I know we complained that it seemed crazy for us to pay for OiD when ONAMES is free...considering Oracle is de-supporting ONAMES and practically forcing customers to go with OiD (LDAP). I guess they actually used some of the feedb

RE: TOAD v/s PL/SQL Developer

I have been using PL/SQL Developer for many years and put alot of functionality requests for some of the new features in the 3.x and 4.x product. I would be more than happy to answer any questions you have about the product. But to answer your question. The debugger in PL/SQL developer simply r

Re: How do I corrupt a block

You can write a little perl script to write over the block. Just open the datafile, sysseek to (block_number)*(block_size), then syswrite(chr(0),block_size). Strangely though, the naive approach of overwriting a block entirely with nulls results in a block which is not detectable with dbms_repai

Re: TOAD v/s PL/SQL Developer

We have been using free TOAD for over a year and have gotten from them somehow an extenstion of the expire license to not expire for the next 5 years. This version of TOAD meets our needs so we see no reason to upgrade for most of us. Randy Pace Phone 801 495 9300 9662 S 700 E Fax 801

Re: Resizing Log file

You need to add new log groups/members of the appropriate size, and drop the old ones. -Joe - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 31, 2001 3:38 PM > hi dba's, > > In my DB, oracle 816, NT4, the redolog member's size

RE: TOAD v/s PL/SQL Developer

Did you try EZSQL? Alex Hillman -Original Message- Sent: Thursday, May 31, 2001 3:38 PM To: Multiple recipients of list ORACLE-L Folks, Just got an e-mail from my Damager that there is a concern about the cost of TOAD licensees and an effort is being made to find a suitable replacemen

Re: Urgent: PL/SQL lock timer event

Someone is doing: dbms_lock.sleep(x) where 'x' is seconds. It won't be causing any performance problems - its a 'quiet' wait hth connor --- "Naik, Sandesh S" <[EMAIL PROTECTED]> wrote: > Hi, > I need urgent assistance is resolving issues with > PL/SQL lock timer. My > query is waiting on thi

Re: How do I corrupt a block

unfortunately i am on NT I can not use BBED because i don't know the password is there any other way - Original Message - To: "'novicedba'" <[EMAIL PROTECTED]> Sent: Thursday, May 31, 2001 11:40 PM > I do not recommend this, but since you are bent on doing this: > (Hope you are on Unix)

Re: Resizing Log file

offline, drop, create, online in that sequence for the inactive logfiles. ROR mª¿ªm >>> [EMAIL PROTECTED] 05/31/01 03:38PM >>> hi dba's, In my DB, oracle 816, NT4, the redolog member's size is only 50kb. I'm having only two groups with a single member each. I tried with alter database command,

RE: How do I corrupt a block

There are un-documented init.ora parameters that can be used to corrupt such things as the rollback segments and tablespaces. Maybe there is one that can be used to corrupt a specific block of a datafile as well. Contact ORacle Support and see if they have any of these. They would be undocum

RE: How do I corrupt a block

talk to your lead duhveloper..they are usally good at that ;-) Sunil Nookala Dell Corp Austin, TX -Original Message- Sent: Thursday, May 31, 2001 5:06 PM To: Multiple recipients of list ORACLE-L unfortunately i am on NT I can not use BBED because i don't know the password is there any

Re: How do I corrupt a block

BBED isn't an option unless you can talk Oracle support into taking part in your experiment - unlikely. (Or perhaps find an appropriate WaReZ site! (8-o) Any hex editor will do if you aren't particular about exactly what you change in the block. If you know Oracle block internals you can get a

RE: Rebuilding indexes

yup -- that's what I used to try to do >From: "Thater, William" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Rebuilding indexes >Date: Thu, 31 May 2001 12:09:37 -0800 > >On Thu, 31 May 2001,Rachel Carmichael scribble

RE: 4 join methods?

Yes I know it and sometimes I enforce it using index_join hint. Regards Waleed -Original Message- Sent: Thursday, May 31, 2001 5:07 PM To: Multiple recipients of list ORACLE-L No, Oracle 8i will actually merge indexes and perform a pseudo join when possible without going to either tab

Re: Oracle 8.1.7 and Apache

please mail them to me too - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 1:53 AM > Ken, > > (FYI, I used a version of Apache (1.3.12) that came from Apache's web site, > not the version that came with Oracle. And my web s

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.  A

RE: TOAD v/s PL/SQL Developer

Hi Chris, Thank you for your detailed response. I have forwarded it to our Developers. It would be very helpful.. Glad to know that you have contributed to the product's functionality. Thanks. - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Mes

RE: Auto Extend

I personally have 2G files and would never shy away from them. Nothing worse then having a rather huge database with 6 million files when there is really no valid excuse for it. I would have happily gone bigger then 2G as well if it were not for the Sun Omniback agent. I will do it on the HP bo

Re:Rebuilding indexes (simple way)

Raghu, Index rebuilding is one of those maintenance items that needs doing every once in a while. Therefore my take is to have a separate tablespace where I can rebuild the trashed index into, and then rebuild it a second time back into where it originally came from, but with the correct siz

Oracle system sizer

Has somebody practical experience with the Oracle system sizer of Compaq ? Does the suggested configuration comes up to expectations ? Regards, Rene --== Sent via Deja.com ==-- http://www.deja.com/ -- Please see the official ORACL

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

What a hoot! I mean all these wild statements about not needing DBA's anymore (or sometime in the future). Is Oracle actually getting simpler with each new release? With tongue firmly planted in cheek, here is the Oracle 5.1 DBA "OCP" exam. You be the judge... Q1) How do you cold start an ins

RE: TOAD v/s PL/SQL Developer

Mark Qualter who handles support for the product is great. Very responsive to requests reguarding features as well as bugs. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 5/31/01 6:33 PM Hi Chris, Thank you for your detailed response. I have forwarded it to our De

Re: 4 join methods?

I also sent an inquiry to Tim Gorman, who wrote the article on the CBO. He's no novice. He says the fourth join method is 1. nested loops 2. sort merge 3. hash join and 4. cartesian product ! I kid you not. By the way, if you're on 8i and haven't already set init parms OPTIMIZER_

HELP! / RE: OT: Archiving not possible with SQL Server?

are you a complete idiot? On 31 May 2001, at 13:34, Bowes, Chris wrote: > I protest Jared's removal from the list for telling jokes!Henry please > reconsider! :) ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat

Re[2]: Fire your DBA's you don't need them anymore...

Don't hold your breath!! BTW: Do you remember the claim of the nuclear power industry? That by the turn of the century electricity would be so cheap and plentiful we could waste it at will. Tell that to those folks in California!!! Dick Goulet Reply Separator__

RE: Auto Extend

> which > parameter I need to set up to > increase the file size limit? There isn't one. On NT the filesize is limited by the type of filesystem (FAT, FAT32, NTFS, etc...). I suspect the bug in question is bug 711563, and it's fixed in the latest 7.3.4.x and 8.0.x patchsets. Yet another reaso

RE: Snapshot Logs Explanation Needed

OK, checked TFM and there are two type of fast refresh snapshots: primary key (new in 8) and rowid. For a rowid snapshot, when the table (EMP) is updated, a row is added to the snapshot log (MLOG$_EMP) containing mainly the type of action, timestamping info, and the rowid (MLOG$_EMP.M_ROW$$) of t

Standby Databases and DB Links

Has anyone been successful in using their standby database operating in read-only mode through a dblink? I can't find any admonishment in the docs. The dev guys says it will be find for the front-end java code to fail on any updates. Ritchie Lau [EMAIL PROTECTED] _

Re: Re[2]: Fire your DBA's you don't need them anymore...

---excerpt from trivia site--- On the 60s TV show Green Acres, what was Arnold Ziffel's (the pig) favorite TV program? Lost in Space Combat Beverly Hillbillies CBS Evening News with Walter Cronkite [answer:] CBS Evening News with Walter Cronkite --- On 31 May 2001, at 1

Re: About parallel server

Some OPS-capable platforms (Tru64? VAX?) already allow "cooked" files for OPS. Oracle9i will support files for OPS only on certain supported cluster file systems. Veritos has been explicitly mentioned and Veritos people say their cluster file system for parallel server will be available by the

RE: How to encrypt Password in Export script file ?

Hi Gurus, Thanks to those who replied. We feel that Unix account is easily hacked, so we will not implement the method that Rachel mentioned. We will probably "encrypt" the password in another file. Before exporting, we will decrypt the password before passing the password to the export script. T

Re: How do I corrupt a block

Jared, BBED is available on UNIX, you just have to make it with the make command. cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed The bbed command can allow you to soft corrupt a block and you can use the "dd" command to hard corrupt the block. The bbed command doe

RE: TOAD v/s PL/SQL Developer

Take a look at the product Kirti mentioned, PL/SQL Developer, it is a GREAT product. And $1,000 for 20 licenses, But it is $150 for a single. I absolutely love it compared to anything out there. I have converted at least 50 developers to using it. -Original Message- To: Multiple rec

RE: ORACLE NAMES /LDAP

Sorry about asking these question , because currently I'm not in my office so I don't have the document ,Why we need to use Oracles Names /LDAP ?? -Original Message- Sent: Thursday, May 31, 2001 11:51 PM To: Multiple recipients of list ORACLE-L Vikas, I just implemented Oracle Names

RE: problem with trunc()

Here's the query and execution plan. Like I said, it took 6-7 hours just to get that without executing. Any insight appeciated. Remember: I know the workaround (avoid trunc). I'd just like to know *why* it doesn't work. Some of the values were dummied up ('' etc.). The actual query is

Urgent: How to set Oracle block size for various OS

Hello gurus, Could you please advise how to set the block size for various operating systems? eg HP, aix etc. also this is for oracle 8. This is urgent, and you can give me any thing, eg url, white paper, etc. thanks and regards, raja Get 250 color business cards for FREE! http://businessca

Help! ORA-00164 - autonomous trans problem in 8.1.7 NOT in 8.1.5

Recently upgraded a development database from 8.1.5 to 8.1.7 with the u080105 script. There is now a certain type of code that errors out with a ORA-00164 autonomous transaction disallowed within distributed transaction. But the same code works on 8.1.5, as if a piece of functionality was actual

Re: ORACLE NAMES /LDAP

The most simple analogy is would you prefer to manually maintain a "host" file on each client or use a single facility such as a DNS server ot provide the mapping between hostname & IP_number? At some point switching from using TNSNAMES.ORA files on all Oracle servers & client to a single/central

Re: ORACLE NAMES /LDAP

The most simple analogy is would you prefer to manually maintain a "host" file on each client or use a single facility such as a DNS server ot provide the mapping between hostname & IP_number? At some point switching from using TNSNAMES.ORA files on all Oracle servers & client to a single/central

Re: Re[2]: Fire your DBA's you don't need them anymore...

Beverly Hillbilies. At 04:37 PM 5/31/01 -0800, you wrote: >---excerpt from trivia site--- > >On the 60s TV show Green Acres, what was Arnold Ziffel's (the pig) >favorite TV program? > > Lost in Space > Combat > Beverly Hillbillies > CBS Evening News with Walter Cronkite > >[answer

RE: Tablespace Allocation Type & Extent Management

Title: RE: Tablespace Allocation Type & Extent Management > -Original Message- > From: Walter K [mailto:[EMAIL PROTECTED]] > > I seem to be confused about the relationship between > tablespace management and allocation methods. > > What is the USER allocation_type (as reported by >

Re: OFF TOPIC: freeware search

If you know RCS why not just use a DOS port of it...a quick web search found http://www.trumphurst.com/dosrcs.phtml but maybe not what you're looking for... Charlie Mengler wrote: > I'm looking for recommendations for Windows based s/w > that does the equivalent of SCCS/RCS on Unix. A comm

Difference between a couple of v* manuals

Hi I have been sent the following " I keep coming across references (in the other Oracle 8.0.5 documentation) to a document called the "Oracle8 Server SQL Reference", presumably distinct from the "Oracle8 SQL Reference". Any idea whether there really is a separate document with that title? If so

RE: Oracle 8.1.7 and Apache

pl send me the files. TIA -- On Thu, 31 May 2001 12:23:58 Fisher, Julie wrote: >Ken, > >(FYI, I used a version of Apache (1.3.12) that came from Apache's web site, >not the version that came with Oracle. And my web servers and database >servers are on different machines. And my web servers

Import Problem

Hi I saw this over on the Sun System admin list and was interested in the cause of it. My suspicion is that it has something to do with 2GB files limits Oracle data base using the imp command on my Solaris 2.6 server this is the message that I receive Import: Release 8.1.5.0.0 - Production on T

RE: Missing DDL?

Sean, Another option would be: Get yourself a copy of strings from http://www.sysinternals.com/misc.htm#Strings (a very useful site for NT utilities that should have been in NT!). Do the export (someone else suggested a full export is required) Then do a strings -a export_file.dmp | fi

RE: Suggestions on SCSI

Hi, The suggestion given to go for 18Gigs HDD(SCSI) is a good one. I have seen in H/W that what u get today u will not get tomorrow. I mean they become obselete. H/W vendor will say that they nolonger manufacture the same. Ultra fibre scsi is a technology HDD maufactures use for I/o transfer. Y

Re: Difference between a couple of v* manuals

Hi, I have gone thru the manual list. For me Oracle SQL Server ref and Oracle SQL ref sounds the same. There are 2 more manual SQL*Plus quick ref and SQL*Plus user's guide and ref. I have come across these manuals only. HTH Venkat -- On Thu, 31 May 2001 21:05:19 Peter McLarty wrote: >Hi >

Re: 4 join methods?

There are 5 join operations inner join equi-join outer-join anti-join self-join and 3 join methods neted loop sort merge join hash join sam - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 31, 2001 10:55 AM > 1. Equi-join 2.

Re: Re[2]: 4 join methods?

Star join or STAR SCHEMA is used for DSS Systems. It actually uses Cartesian product in its methodology but still employs Oracle join methods to actually do the joins between the tables. So there are still 3 join methods.Cartesian (as somebody mentioned earlier is product rather than a join) Sam

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

hi, the package involved is utl_tcp, i created it under sys. the procedure is also created without any error under sys. do i still need to grant execute privilege on it, when sys itself is the owner. saurabh - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]

RE: how much ram per oracle process?

i guess the SGA size is also included in the SZ > -- > From: Henry Chan[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Friday, June 01, 2001 5:59 AM > To: LazyDBA.com Discussion > Subject: how much ram per oracle process? > > Environment: Sun 2.

RE: 4 join methods?

Hi Greg, I think Tim is right. I've read all the thread and among all other suggestions cluster join might have been the best answer. But if I remember correctly it is a kind of N-L Now going to read the article. Thanks for the link Regards, Ed > > I also sent an inquiry to Tim Gorman, who

How to import data

Hi All, How to import data exported by 8.1.6 into 7.3.4 ? Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--

Re: How to import data

Hi, AFAIK you can't. You should run catexp for version 7.3.4 on your 8.1.6 database and than use 7.3.4 binaries to do the export. jack "Rukmini Devi"

<    1   2   3