Re: select from dual?

Did you mean somethink like this: select 30,'where name in (''NAME1'',''NAME2'')' || ' ;' from dual; Tatireddy, Shrinivas (MED, Keane) pe: Hi lists Whats wrong with the following statement:- select 30,'where name in ('NAME1','NAME2')' || ' ;' from dual; where as the following is

Re: Sql question - please reply fast

create table AAA (NAME varchar2(30)); insert into AAA values ('Pelle T'); insert into AAA values ('Kalle S1000'); insert into AAA values ('Info missing'); insert into AAA values ('Pelle Svensson T3'); insert into AAA values ('Bad info'); select decode(name, 'Info missing',NAME,'Bad

is there an archive for this mailing list...

hi gurus is there an archive for this mailing list? if yes , how can i access them Best regards, Grace Lim Suy Sing Comm'l Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

Re: DBA CHECKLIST

Hi, O'Reilly has a pocket size reference book about it, I believe Jack grace [EMAIL PROTECTED]@fatcity.com on 15-11-2001 05:30:17 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van

RE: select from dual?

i think the following code should work - select 30,'where name in (''NAME1'',''NAME2'')' || ' ;' from dual; the character fields should be seperated by double quotes instead of single. santosh Hi lists Whats wrong with the following statement:- select 30,'where name in

RE: Sql question - please reply fast

For the final time Roland. SQL select * from mytable; FIELD1 Pelle T No Info Pelle Svensson T Missing Info Kalle S1000 SQL get lee.sql 1 SELECT field1, DECODE(field1,'No Info','No Info','Missing Info','Missing Info',ltrim(substr(field1,1,instr(field1,' ')-1)))

RE: DBA CHECKLIST

OCP exam guide of oracle may be usefull -Original Message- [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 9:40 AM To: Multiple recipients of list ORACLE-L Hi, O'Reilly has a pocket size reference book about it, I believe Jack grace [EMAIL PROTECTED]@fatcity.com on

Move data from Oracle into Access

Title: Move data from Oracle into Access Hi! What would be the easiest way to dump out an Oracle table and move it into Access? (approx. 100,000 rows) No flaming, please... ;) I assume that there is no tool for Access to read Oracle dmp-files, right? Is spooling it out into

RE: is there an archive for this mailing list...

I have for few weeks -Original Message- Sent: Thursday, 15 November 2001 4:25 PM To: Multiple recipients of list ORACLE-L hi gurus is there an archive for this mailing list? if yes , how can i access them Best regards, Grace Lim Suy Sing Comm'l Corp. -- Please see the official

Re: DBA CHECKLIST

Hi List, Check this out, http://www.geocities.com/tbcox23/dba_checklist15.doc It is really gd. Venkat -- On Wed, 14 Nov 2001 23:40:19 nlzanen1 wrote: Hi, O'Reilly has a pocket size reference book about it, I believe Jack grace [EMAIL PROTECTED]@fatcity.com on

Re: is there an archive for this mailing list...

Goto the following link and sign in and select Oracle-L list and you have an option called Archives. http://www.fatcity.com/ HTH Venkat -- On Thu, 15 Nov 2001 00:25:19 grace wrote: hi gurus is there an archive for this mailing list? if yes , how can i access them Best regards, Grace Lim

Re: Configuring for Online Redo Logfiles

An unmirrored disk will run faster (with respect to writes) than a mirrored one (not twice as fast since writes on a mirror are typically done in parallel). Then again - now you've got an unmirrored redo log...not a good idea. To get around this, you'd need to duplex it through Oracle - which

RE: Sql question - please reply fast

Can you tell us what the last word in the field value mean (except 'Info missing' and 'Bad info') I mean is there a rule that those T, S1 does respect? Something like this: - first character is a letter and in this set of values ('S', 'T' etc) - the rest are digits etc. Try to find out a

ORAxxxx trace files.

Hi list, Does anybody have a good list of all the ORA errors that will cause a trace file to be generated? We have a user of our tools that wants to monitor for any trace files/dumps being generated. I can think of two ways: 1) monitor the alert log as above for specific errors 2) monitor the

RE: DBA CHECKLIST

Also you can check this pdf document out: http://www.geocities.com/tbcox23/dba_checklist13.doc HTH Mark -Original Message- [EMAIL PROTECTED] Sent: 15 November 2001 07:40 To: Multiple recipients of list ORACLE-L Hi, O'Reilly has a pocket size reference book about it, I believe

RE: Operating Systems

-And maybe (gods help me! gulp) NT? Get a rope! :O) -Original Message- Sent: Wednesday, November 14, 2001 12:13 PM To: Multiple recipients of list ORACLE-L Linux or Solaris Intel. And maybe (gods help me! gulp) NT? Scott Shafer San Antonio, TX Regina Harter wrote: Hi Guys,

RE: DBA CHECKLIST

Grace, Free sources: = www.orapub.com Technical Papers section #115 Oracle DBA Checklist Thomas B. Cox wrote a paper called Database Administration Mautrity Model. This is IMHO rleated to DBA checklists. I have version 1.1 but only as hardcopy. It does not appear to be

RE: is there an archive for this mailing list...

Grace, Go here: http://www.fatcity.com/ListGuru/login.php and click on the sign up here link to create a new online account.. HTH Mark -Original Message- Sent: 15 November 2001 08:25 To: Multiple recipients of list ORACLE-L hi gurus is there an archive for this mailing list? if yes

SQL Query OutPut

Hi, I need the Query for the following result. If any body help it will be very great. Its very urgent. the output needed is DeptNoEmpNo 101 2 3

Connecting 8.0 to 8.1

Forgive me if this is a RTFM question - I have not been able to find the right bit of the FM. Can someone please tell me how to Net8 connect an 8.0 NT client to an 8.1 Linux server. Everything was working fine until a second Oracle instance was installed on the server. I now get ERROR:

Ang: RE: Sql question - please reply fast

Thanks for all your repliesReally appreciate this.. next time I willtake more time to check the errors myself Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: Configuring for Online Redo Logfiles

Ed/List Would NOT reads be Faster with RAID 1 than NO-Raid for the online redo logfile ? Thanks -Original Message- From: Edward Shevtsov [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 12:50 PM To: Multiple recipients of list ORACLE-L Subject: Re: Configuring for

RE: OT_salary

Title: RE: OT_salary Well, what better could it be when I get a bus every 5 minutes during peak hours and every 10 minutes during off-peak ?? I have visited New Jersy and Richmond in the US and I have seen that it is very difficult to commute there if u dont have a car which is the

Tricky Query

Hi All, I am working on a application in which I have to find the Min and Max time of the user session. Since there will be multiple records for a single session with the overlapping time. the example data is as foll. MMCR_APPNO MMCR_START_TIME MMCR_END_TIME --

Re: Move data from Oracle into Access

Instal ODBC for Oracle on your Access machine and open oratable from Access. It's somewhere in menu (something like import data or ..) JP On Thu 15. November 2001 10:05, you wrote: Hi! What would be the easiest way to dump out an Oracle table and move it into Access? (approx. 100,000 rows)

Re: Operating Systems

From our root: Don't use Solaris on Intel. It's very very unstable and doesn't support too much HW. JP On Thu 15. November 2001 11:00, you wrote: -And maybe (gods help me! gulp) NT? Get a rope! :O) -Original Message- Sent: Wednesday, November 14, 2001 12:13 PM To: Multiple

RE: SQL Query OutPut

Look up group by clause in the SQL Reference Manual. Regards Lee -Original Message- Sent: 15 November 2001 10:05 To: Multiple recipients of list ORACLE-L Hi, I need the Query for the following result. If any body help it will be very great. Its very urgent. the output needed is

RE: SQL Query OutPut

In sqlplus BREAK ON deptno skip 1 SELECT deptno,empno FROM your_table ORDER BY deptno,empno; You may want to set pagesize,spool etc. Rick -Original Message- Sent: Thursday, November 15, 2001 5:05 AM To: Multiple recipients of list ORACLE-L Hi, I need the Query for the following

Re: Move data from Oracle into Access

Hi, why don't you connect via ODBC or OO4O and insert into ... select from ... the data into your access tables. cheers, Stefan Daiminger, Helmut schrieb: Hi! What would be the easiest way to dump out an Oracle table and move it into Access? (approx. 100,000 rows) No flaming, please...

RE: Move data from Oracle into Access

Title: Move data from Oracle into Access Helmut, You can "import" the table via an ODBC link. Make sure that you have an ODBC datasource set up with Micro$ofts ODBC driver for Oracle for the Oracle instance, open up your Access "database window" then from your File menu choose "Get

RE: Sql question - please reply fast

select field1, decode(field1, 'Info missing', 'Info missing', 'Bad info', 'Bad info', substr(field1, 1, instr(translate(field1, '0123456789', '@@'), '@')-3)) from your_table HTH Iulian -Original Message- Sent: Thursday, November 15, 2001 8:56 AM To: Multiple recipients

RE: Connecting 8.0 to 8.1

There is something wrong with your host address.. If I were you I would check the HOST value in your TNSNAMES.ora, and make sure the IP is correct. Then, change the HOST values in your LISTENER.ora to use the IP address as well instead of the host names. Also, do you have the GLOBAL_NAMES

Command line utility to show installed Oracle software

Hi All, I have forgotten the command line utility to show installed Oracle software. Oracle 8.0.5/NT 4. Can someone tell me? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services--

RE: Operating Systems

Time to get the leeches. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Scott Shafer [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 6:56 PM To: Multiple recipients of list ORACLE-L

RE: SQL Query OutPut

Whoops - misunderstood the question. BREAK Lee -Original Message- Sent: 15 November 2001 12:00 To: Multiple recipients of list ORACLE-L Look up group by clause in the SQL Reference Manual. Regards Lee -Original Message- Sent: 15 November 2001 10:05 To: Multiple

Re: SQL Query OutPut

SQL break on DeptNo Robertson Lee - lerobe wrote: Look up group by clause in the SQL Reference Manual. Regards Lee -Original Message- Sent: 15 November 2001 10:05 To: Multiple recipients of list ORACLE-L Hi, I need the Query for the following result. If any body help it

RE: Operating Systems

That leaves NT for shops that require customer support... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Jan Pruner [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 7:55 AM To: Multiple recipients

Re: SQL Query OutPut

SQL Break on DeptNo SQL Select ... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 5:05 PM Hi, I need the Query for the following result. If any body help it will be very great. Its very urgent. the output

RE: Connecting 8.0 to 8.1

You might have install the 8.1 client. I may be wrong but I think with the 8.1 client you can connect to 8.1 and any version lower but with the 8.0 client you cannot connect to a higher version. If you don't have the 8.1 client CD you can download the client at Oracle's site. Dave

RE: ORAxxxx trace files.

Title: RE: ORA trace files. Hi Mark, I wrote the following bit of code (not good enough to call a script!) to check our alert log for deadlock trace files awk -f j.awk -v DateStr=Nov -v SearchStr=info alert.log a.lis numberOfLines=`grep info a.lis |wc -l` if [ $numberOfLines -gt 0

RE: Configuring for Online Redo Logfiles

Conor,List 1) Mirrored Redo Logs WRITES may have an Overhead of 15-20 % EXCERPT from Gaja's Doc One of the common myths with mirroring, is that it takes twice as long to write.But in many performance measurements and benchmarks, the overhead has been observed to be around 15-20%. 2) Mirrored

ORA 600 error can't find reference on Metalink

Hi all, I recently found following errors in alert log, but couldn't locate any information on Metalink, does anyone know what these errors are? I will be opening a TAR with OWS this AM. ORA-00600: internal error code, arguments: [4427], [], [], [], [], [], [], [] ORA-00600: internal error

hide password

Hi lists, We can see users password using ps -ef |grep sqlplus (if we run a job using sqlplus scott/tiger @${runfile} ). To prevent this we can run our code sqlplus -s EOF scott/tiger @${runfile} EOF Is there a similar way in export hiding the password (preventing users to see the

OT: Sybase

Question for dual - dbms dba people. Beside Oracle, I have some Sybase stuff to do. And I'm sure that there are some of you that do know something about Sybase. Do you have any documents that deal with: - tricks'n'tips - do's and dont's - introductions - backups - best practices - worst

RE: Enterprise Versus Standard

I received the attachment from my Oracle License Manager when we were moving toward purchasing Oracle Standard Edition. It compares SqlServer2000, Oracle9i and DB2. It's very handy if your in a heterogeneous environment. After reviewing the document it was clear to us Enterprise Edition was

Re: hide password

Hi, Use a controlfile. Jack Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] @fatcity.com on 15-11-2001 14:10:26 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van

RE: CLOB datatype

Rick, CLOBs been bery bery good to me. ;-)(8.1.6 on Win2k) We collect 50,000 - 200,000 documents per day and store them in out-of-line CLOBs in a partitioned table. The CLOB column has an interMedia Text index on it, which allows us to query up to about 12 million documents with great

Re: Configuring for Online Redo Logfiles

Hi Vivek, If I didn't worry about data safety I would choose redo logs on dedicated single disks. The reason is that usually the speed of LGWR's writes is more important for performance compared with speed of ARCH's reads. Regards, Ed Conor,List 1) Mirrored Redo Logs WRITES may have an

Re: Operating Systems

I guess that on Intel platform you don't have other choice than Linux and Oracle fo Linux. Database on NT = highway to hell and you cruise at high speed JP On Thu 15. November 2001 13:40, you wrote: That leaves NT for shops that require customer support... Regards, Patrice Boivin Systems

RE: Enterprise Versus Standard

I didn't relize we couldn't send binary attachments. If anyone else needs the document, let me know and I'll send it to you directly. Ashley -Original Message- Sent: Thursday, November 15, 2001 8:25 AM To: Multiple recipients of list ORACLE-L I received the attachment from my Oracle

Re:Mass Storage/Network Stuff

Ed, The answer is yes and no, or more accurately it depends. First off there are only two storage vendors, to my knowledge, certified by Oracle for this. They are Net Appliance and EMC. The reason is that they have software and hardware that 'guarantees' to get the data from the buffers

RE: Mass Storage/Network Stuff

Ed, I am running NT with EMC storage arrays over dedicated fiber connections. Very good, very fast, very stable (and very happy). Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, November 15, 2001 8:58 AM To: Multiple recipients of list ORACLE-L Ed,

RE: Operating Systems

All, Interesting comments regarding OS selection. Of course, this has been covered in the past at great length. Let me add my 2 cents. NT is a very viable option if it is being administered by a competent NT Admin who does not treat the box like a home desktop. I have been working on NT

RE: hide password

Can you explain in detail how to use a controlfile in exports? thnx and regards, Srinvias -Original Message- Sent: Thursday, November 15, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Hi, Use a controlfile. Jack Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED]

RE: Operating Systems

At last! Somebody who speaks my language! The biggest problem I have found with NT is when people insist on adding this and that and that over there, add this piece of software that overwrites this .dll but hasn't been properly tested.. Poor drivers etc.. Grab an Intel system, fresh off the

RE: Failures in creating Oracle database file.

In one of my previous assignments, even if my ulimit was unlimited, I could not create datafiles bigger than 2 GB, The OS was Sun Solaris 2.6. So best thing is to test what Kirti suggested. Thanks, Suren -Original Message- Sent: Wednesday, November 14, 2001 12:25 AM To: Multiple

Oracle express errors

Hi All, I have a customer that is getting the following errors when attempting to connect to a Folder in Oracle Express Server. Error #7219 in XPCUBE: Informational (0100): Reset to default CAUSESB selection Error #7218 in XPCUBE: informational (0100): No CAUSESB values in

hide password

Jack, I think you are referring to PARFILE... Suren -Original Message- Sent: Thursday, November 15, 2001 8:36 AM To: Multiple recipients of list ORACLE-L Hi, Use a controlfile. Jack Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] @fatcity.com on 15-11-2001 14:10:26

Re: Operating Systems

Hmm, I'm not trying to start flamewar! I was hired 3 years ago and the company has 3 databases on MS SQL (every about 1GB). Today we have * in 1 Oracle db running on Linux. And now. I have done an import daemon from pure text files (replication between servers) in C++. On NTFS import into MS

select and rollback

Dear All, I have a select statement that when runs it complains about limited rollback segment extents. Do selects use rollback? Regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hatzistavrou Giannis INET: [EMAIL PROTECTED] Fat City Network Services--

RE: hide password

Use parfile option. - Kirti -Original Message- From: Tatireddy, Shrinivas (MED, Keane) [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 7:10 AM To: Multiple recipients of list ORACLE-L Subject: hide password Hi lists, We can see users password using ps

Migration from Oracle 7.3.4 to Oracle 8.1.7 on IBM Cluster

On an IBM AIX 4.3.3 Having HSEMP Cluster Allowing to Machines to Share the SAME Storage Box ( But Different respective Partitons though ) STEPS :- - From ORACLE_HOME of 8i mig $ORACLE_HOME of 8i $ORACLE_HOME of 7.3.4 RESULT Creates conv$SID.dbf in ORACLE_HOME of 7.3.4 - mv conv$SID.dbf from

RE: Configuring for Online Redo Logfiles

Ed,List Since we Enable log_checkpoint_interval to a Very High Value , Qs Would READs for Data of Tables Also NOT Occur from the Online Redo Logfiles ? NOTE Oracle version 8.1.7.2 Thanks -Original Message- From: Edward Shevtsov [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November

Re: select and rollback

The timing of this question is amazing. Just yesterday I was reading in Tom Kyte's book Expert One-on-One ISBN 1-861004-82-6 about this specific topic. The short answer is YES! For a more complete answer RTFB. Hatzistavrou Giannis wrote: Dear All, I have a select statement that when runs

Need help rewriting SQL with TRUNC function

I think that the following statement is keeping this application from using an index in my cost-based execution plan. This is an 8.0.4 database so I don't have the option of creating a function-based index. I'm not that great with SQL. Can anyone help me rewrite this statement so that I don't

RE: select and rollback

They can, most notably for read consistency. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Hatzistavrou Giannis Sent: Thursday, November 15, 2001 8:41 AM To: Multiple recipients of list

Re: ORA 600 error can't find reference on Metalink

Raj, You didn't tell me the Oracle Version. So I would assume this is most current version. Your error OERI:4427 is a transaction layer component internal error. By any chance you are using 2 phase commits (or ditributed transactions) in thiese databases? or database resource manager ? ---

Re: Mass Storage/Network Stuff

To those who answered: thanks! This mailing list is a wonderful resource. Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: is there an archive for this mailing list...

www,fatcity.com you will need to sign up for it but you can then access old messages from this list --- grace [EMAIL PROTECTED] wrote: hi gurus is there an archive for this mailing list? if yes , how can i access them Best regards, Grace Lim Suy Sing Comm'l Corp. -- Please see

Re: Need help rewriting SQL with TRUNC function

Hmm, my_limit_date DATE:= trunc(sysdate) - 6; -- !!! only 6 erh.arrival_dt my_limit_date JP On Thu 15. November 2001 16:00, you wrote: I think that the following statement is keeping this application from using an index in my cost-based execution plan. This is an 8.0.4 database so

Oracle Expert and FK indexes

Does someone know why the Oracle Expert would recommend dropping indexes on FK columns? Maybe it calculates there is a low likelihood of the table being locked during referential integrity checks ? I thought it was a good idea to have indexes on FK columns... this is an old 7.3.4.5. database.

RE: Import Help

And if you are importing into a database on the same machine, make sure you set destroy=n --- John Kanagaraj [EMAIL PROTECTED] wrote: Sujatha, I have an export file from an 8.0.6 database which I need to import into an 8.1.7 db. However, the locations of the tablespaces are

RE: Disk Layout Document

Every time they ask for a new database I try that 22 disk thing also. I also settle for 6 mount points (not 6 disks). Its still fun to try though. Especially when we hire new people. -Original Message- Sent: Wednesday, November 14, 2001 6:45 PM To: Multiple recipients of list ORACLE-L

Re: hide password

Hi, you should use os_authent_prefix = some prefix in your init file and some other parameters that i don't remember but you can find it in the reference, that allow you to make a connect like sqlplus / or exp / By :-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

RE: Import Help

Sujatha, Yes it will try to create them, but John's point is that if you create the database/tablespaces before you import then the tablespaces will already exist. The import will generate errors on the tablespace create steps then move on to schema object import steps. Mike Hand

Re: Need help rewriting SQL with TRUNC function

Jan, Thanks for this reply. What I forgot to mention is that this 7 is a literal that I substituted for a bind variable :b2. Sorry about leaving out that critical piece of information. Cherie

[no subject]

So which was the book u co-authored with Kevin Loney, Rachel ?? Can't wait to get my hands on it :) Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44

9i new features series: yea i'm late with this weeks 9i feature on datatypes

But it will be worthwhile since i'm learning ALOT about the new datatypes for dealign with dates/time/timezone/fractional seconds, etc. anyways in the meantime, i had quite a few people ask about back issues :) they are up on my website http://www.oracle-dba.com/9i that will take you to the

RE: Operating Systems

I can't argue with that one. NT does have its place. If its not a critical application and you only need a predetermined amount of users to access it, its a pretty cheap way to get a very expensive database up. Its all a matter of economics. However, then you have 6 million NT servers cause

RE: Mass Storage/Network Stuff

Ed... Make sure you read the last couple lines of Dick's email carefully... He is absolutely correct... There is a big difference between being certified by Oracle and being certified by Oracle USING THE SUPPORTED CONFIGURATION... This is a bit of a touchy subject for me since I had several

Parsing free-form text for InterMedia indexing

Hi all, I've been struggling with trying to provide our users with a quick text search. InterMedia's doing OK, but I'm having trouble setting it up because the text I'm searching is free-form data entered by several users over the span of years. In other words, it's a word-jumble. For

Re: Need help rewriting SQL with TRUNC function

The same song my_interval VARCHAR(1) := 7; my_limit_dateDATE; begin ... select (TRUNC(sysdate)-TO_NUMBER(my_interval)+1) into my_limit_date from dual; ... sql_stmt := 'SELECT * FROM my_table WHERE :1 AND erh.arrival_dt :2 AND... '; EXECUTE IMMEDIATE sql_stmt USING my_first,

how know solaris bit

Hi How we know the OS is 32 bit or 64 bit on SOlaris? Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema

Re: hide password

#!/bin/ksh print the_password | exp userid=blah hth connor --- Tirumala, Surendra [EMAIL PROTECTED] wrote: Jack, I think you are referring to PARFILE... Suren -Original Message- Sent: Thursday, November 15, 2001 8:36 AM To: Multiple recipients of list ORACLE-L

Re: Need help rewriting SQL with TRUNC function

I think that the following statement is keeping this application from using an index in my cost-based execution plan. This is an 8.0.4 database so I don't have the option of creating a function-based index. I'm not that great with SQL. Can anyone help me rewrite this statement so that I don't

Re: Move data from Oracle into Access

do you have an odbc connection? you can select directly from oracle into the ms access table. --- Daiminger, Helmut [EMAIL PROTECTED] wrote: Hi! What would be the easiest way to dump out an Oracle table and move it into Access? (approx. 100,000 rows) No flaming, please... ;) I assume

RE: Operating Systems

Well... I figured I'd put my $0.02 in... I have had some exposure to NT... As a matter of fact, I did Oracle on NT at a dot com for about a year... And to tell you the truth, I hated it... But, I really gave it a honest chance... The first couple of places where I had NT exposure were Unix

test

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeffrey Beckstrom INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: ORAxxxx trace files.

not that I know of... we have a script that runs in cron every 15 minutes and looks for certain words, it's unix, is that usable? --- Mark Leith [EMAIL PROTECTED] wrote: Hi list, Does anybody have a good list of all the ORA errors that will cause a trace file to be generated? We have a

RE: DBA CHECKLIST

Openworld 2000, Greg Loughmiller and I did a presentation Congratulations, You're the New DBA, Don't Panic, it's out on the NYOUG website under the December 2000 presentations -- paper and slides, there's a section on daily/weekly/etc procedures --- O'Neill, Sean [EMAIL PROTECTED] wrote:

Re: Oracle Expert and FK indexes

If you are not making changes to the parent in the relationship, then the indexes are not needed (at least for locking concerns). hth connor --- Boivin, Patrice J [EMAIL PROTECTED] wrote: Does someone know why the Oracle Expert would recommend dropping indexes on FK columns? Maybe it

Re: Need help rewriting SQL with TRUNC function

(trunc(sysdate) - trunc(erh.arrival_dt)) = 7 becomes - trunc(erh.arrival_dt) = 7 - trunc(sysdate) becomes by negating trunc(erh.arrival_dt) = trunc(sysdate) - 7 becomes erh.arrival_dt = trunc(sysdate) - 7 + 0.9 hth connor --- [EMAIL PROTECTED] wrote: I think that the following

Re: Move data from Oracle into Access

The simplified version: Connect access to oracle using ODBC and select from the oracle tables into access tables. --Scott Daiminger, Helmut wrote: Hi! What would be the easiest way to dump out an Oracle table and move it into Access? (approx. 100,000 rows) No flaming, please... ;) I

RE: hide password

exp parfile=parfile.par Example of parfile parfile.par userid=user/password tables=(STL_T_TICKET_HIST_199906) log=/u8/oracle/dba/fullexp/log/STL_T_MTL_TRANS_ACCTS_199906 file=/u227t/oracle/OPRO4/exp/STL_T_TICKET_HIST_199906 #file=/u227t/oracle/OPRO4/exp/exp.dmp #recordlength=65536 direct=y

Re: Mass Storage/Network Stuff

Tim, Definitely. We're just researching options right now. I was certain we'd end up with something working over a fiber card or 1000 Megabit NIC of some kind. Thanks, Ed - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 15,

Re: Failures in creating Oracle database file.

Thanks for all the replies - I'm not ignoring them. I'm doing some testing now to see what is going on. I'm trying out Oracle 9i since it appears that this may be related to how Oracle was compiled and an innate limitation to Oracle in this case. I should know today if this is the case

Re: is there an archive for this mailing list...

Yes, you will have to register for it at: http://www.fatcity.com/ListGuru/login.php Jared grace

accessing reports processed by the reports server

We are a two node install of Oracle Apps 11i all on NT. The question though is really with the reports server and the web server being on separate nodes. We are an apps 11i two node install. From the apps, we are able to submit a business intelligence report to the report server. However,

RE: Disk Layout Document

After many DB copies, loads, reloads, upgrades, etc., I've decided that the 22-disk layout just doesn't work for us. With only two 4-way stripe sets, we get vastly superior I/O thruput that more than compensates for any contention on any of the stripes. Yes, yes, I understand that with

Re: Move data from Oracle into Access

As long as you're planning to keep it in Oracle, the ODBC method is the way to go. If you're trying to do something else where you need to physically move the data easily, then you can use a select statement to create a comma delimited file (quoted or not quoted). You can then easily use the

  1   2   >