[no subject]

2004-01-21 Thread Ashish Sahasrabudhe
HELP

[no subject]

2004-01-06 Thread Bobak, Mark
Hi, Well, since I can't sleep, I may as well try solving a problem. This is a bit odd, and I'm trying to think of the most efficient way to do it. I've set up some bitmaps in my app. Consider we have documents that we want to sell. In order to be able to sell a given doc, we need to have it

[no subject]

2003-12-11 Thread Kirtish P Gaonkar
Any body having Oracle Dev/2000 6i CBT's . If any Can you please send ? Thanks in Advance ... Kirtish P. Gaonkar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtish P Gaonkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

[no subject]

2003-12-08 Thread Barry Deevey
SET ORACLE-L MAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

[no subject]

2003-11-24 Thread VirVit
Hello! It's me else one :) When I setup Email Notifications to sysman (sender's email, smtp server, etc) it cannon send report to me cause of VD-4280 error: The SMTP Server could not be connected to. Email server is working properly, configured too. Mail client from the same machine works fine.

[no subject]

2003-11-14 Thread FAFERREIRA
HELP Esta mensagem, incluindo seus anexos, pode conter informação confidencial e/ou privilegiada. Se você recebeu este e-mail por engano, não utilize, copie ou divulgue as informações nele contidas. E, por favor, avise imediatamente o remetente, respondendo ao e-mail, e em seguida

[no subject]

2003-10-03 Thread William . Thater
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

[no subject]

2003-10-01 Thread Prem Khanna J
HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

[no subject]

2003-09-30 Thread Frits Hoogland
SET ORACLE-L DIGEST

[no subject]

2003-09-18 Thread Gene Gurevich
__ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services--

Subject: problem with TextArea /JTextArea (JAR File - Simple Archive )

2003-08-30 Thread Mubarik Ali
Hello Experts, I am using Jdeveloper 9i to make a simple Application which reads data from a binary file and displayes it in a TextArea or JTextArea. This application works fine when i run test it through the JDeveloper 9i Environment. But when i deploy this application into a JAR File -

[no subject]

2003-08-19 Thread Benny Pei
help __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Benny Pei INET: [EMAIL PROTECTED] Fat City Network Services--

[no subject]

2003-08-18 Thread Zhou, Tapiwanashe
help -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zhou, Tapiwanashe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

[no subject]

2003-07-18 Thread James PEARSON
SET ORACLE-L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James PEARSON INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

[no subject]

2003-07-16 Thread Tom Pall
help

(no subject)

2003-07-12 Thread pfeffer
help -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: pfeffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

[no subject]

2003-06-11 Thread Joerg Jost
SET ORACLE-L NOMAIL -- - Software Engineering Vattmannstraße 7, 33100 Paderborn Phone: (+49) 52 51 / 30 1 6333 Fax: (+49) 52 51 / 30 16 399 eMail: [EMAIL PROTECTED] http://www.unitrade.com

[no subject]

2003-05-29 Thread antonio . belloni
We have two servers: Server A running iAS ; Server B running IDS 9 and serving files. We map one drive from server B to server A and we are trying to access the forms on the remote driver: http://host:port/forms90/f90servlet?form=f:\form_name.fmx But we receive an error saying that the servlet

(no subject)

2003-05-28 Thread Radu Deliu
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Radu Deliu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

[no subject]

2003-04-03 Thread Madhavan Amruthur
Hi, I have been grappling with this for sometime I have a table a_user_groups USER_ID SECURITY_GROUP_ID GROUP_ID -- - -- 1005 1012 1010 1005 1012 1011 1006 1013 1010 1007

[no subject]

2003-03-19 Thread liujd
My oracle using version is 8.0.0.5. Now , I'm programming proc . When I precompile them and fail. But I cant see what happened .and where the errors are. So I look carefully for errors in large file. Is there some way to show where the error is .and what the error is . Can you give me

[no subject]

2003-03-14 Thread Joseph S Testa
They have been removed due to my rman framework scripts taking the disk space. Sorry. Joe I have found Joe Testa's site has a good set of RMAN scripts (I think they came from Jack van Zanen off this list), quite simple but they give the syntax for most of the commands you will want The link

[no subject]

2003-03-07 Thread Schafer, Connie J
SET ORACLE-L NOMAIL SET RMOUG-L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schafer, Connie J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

[no subject]

2003-03-04 Thread Diego Cutrone
HELP

[no subject]

2003-02-28 Thread Chuck Hamilton
bio oracle-l begin 666 bio.txt [EMAIL PROTECTED]%M:6QT;VX-D]R86-L92!$0D$-E%60R!);F,N#0H-D)OFX@ M,3$M,CM,3DU. T*2EG:!38VAO;VPZ(%-U;[EMAIL PROTECTED],L($%S=]N M(%!!#0I#;VQL96=E.B!-87AW96QL($ENW1I='[EMAIL PROTECTED]FES=]W;B!0 M02P@,3DW. T*#0I)(%M(AA'!I;'D@;6%RFEE9!W:71H(#,@8VAI;1R

[no subject]

2003-02-27 Thread Ferenc Mantfeld
set oracle-l nomail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ferenc Mantfeld INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

[no subject]

2003-02-18 Thread Piet de Visser
SET ORACLE-L DIGEST signature -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Piet de Visser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

[no subject]

2003-02-18 Thread Ken Heng
Hi, I was wondering how DBAs are coping with these new large disks that are availableyou can purchase 36gb, 72gb, etc. You can fit a whole database on one of these. But with all the performance and redundancy considerations, you wouldn'tso what do you do with the free space? Or how do you

[no subject]

2003-02-13 Thread Glenn Stauffer
set oracle-l digest

[no subject]

2003-02-13 Thread Sunil . Kumar . Gompa
hi, can i use a database link inside a procedure to refresh data from a AS/400 system into oracle ?? this is the sample of the code that i am using ... and it hangs endlesly... CREATE OR REPLACE PROCEDURE PRC_TABLE_REFRESH AS BEGIN execute immediate 'alter session set global_names=false';

[no subject]

2003-02-10 Thread Arup Nanda
Raj, Another consideration is a potential for a buffer busy waits. the larger the block size is, the more the number of rows in an average block. Thsi increases the possibility of a buffer busy wait. HTH. Arup An 8.0.6 ops database being migrated to 9i RAC database on Solaris 8. The 8.0

[no subject]

2003-02-04 Thread Sony kristanto
Hi Listers, I'm new in DBA's job. I want to ask what is 'statspack' ? does it a third party program from oracle or a script. Where I can find the information about 'statspack' ? or if it is a script would you please to share with me ? Thank you in advance for your help. Every comments and clues

[no subject]

2003-01-16 Thread Ehresmann, David
List, I have to move data on a regular basis between two instances of 8.1.7 on two different UNIX servers. The schema is exactly the same. There are 543 tables to be refreshed. It is only the new data on one of the servers to move to the other. What is the best and easiest way to do this?

[no subject]

2003-01-16 Thread Kaing, Leng
. -- From: Stephane Faroult[EMAIL PROTECTED] Date: Wed, 15 Jan 2003 09:06:26 UT Subject: RE: Re: Run obsolete Oracle 7 scripts against Oracle 8i databas= e? v$instance changed a lot. Otherwise Jared is right about #, which was mos= tly appended to (number) columns

[no subject]

2002-12-31 Thread Sunil Arora
Hi Anyone has used Oracle under Solaris/Sun C++ compiler . If yes please mail me how and on whichversion. Sunil AroraSunil AroraVichara TechnologiesDo you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now

[no subject]

2002-12-30 Thread sudhakar Reddy
hi, Wish u a very New Year Sudhakar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sudhakar Reddy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

[no subject]

2002-12-18 Thread Edouard Dormidontov
SETORACLE-L DIGEST EDOUARD DORMIDONTOV

[no subject]

2002-12-09 Thread PK_Deepa/VGIL
SET ORACLE-L NOMAIL Regards, Deepa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

[no subject]

2002-12-06 Thread NGUYEN Philippe (Cetelem)
SET ORACLE-L NOMAIL

[no subject]

2002-12-05 Thread PK_Deepa/VGIL
which -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

[no subject]

2002-12-03 Thread Tinu [EMAIL PROTECTED]
HELP

[no subject]

2002-12-03 Thread Scott Stefick
Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase

[no subject]

2002-11-25 Thread Ehresmann, David
List, Is there anyway to know absolutely that a table is not in an export file? My import bought in 6 tables, but not the seventh ( I don't think it is in the export). The import bought in the other 544 tables! I have queried under the schema name, after logging in as that user: select

[no subject]

2002-11-23 Thread Linda . Miller-Coker
set no-mail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

[no subject]

2002-11-18 Thread sultan
Hi, How can I complie PRO*C code.Please Thnks

[no subject]

2002-11-07 Thread oraclegeek
Hello fokls. First, I do not and have never worked for Oracle. I thought I'd show you some funny and interesting comments from the Oracle source tree that I've been made privy to. Here is today's installment. /* retch, gag, choke. If this bit is off, oracle doesn't break/reset

[no subject]

2002-10-29 Thread Levente Bodrogi
Hi, I've installed Application Server Infrastructure 9i Release 2, but i skipped the configuration assistants. The Enterprise Manager Console doesn't discover the Oracle HTTP Server even if was started with the dcmctl utility. Are there configuration tools that configure the HTTP server and

[no subject]

2002-10-25 Thread Todd Carlson
Hey Guys, I used FGAC for a small application a year ago without problems/issues. I have reread the docs and now I would like to know the experiences of those using FGAC for larger systems. I am now working on an OLTP system that will have tables in the 4+ million range with 100+

[no subject]

2002-10-22 Thread Rahul Mehendale
Hi I have unpartitioned table with aroung 2 million rows. When I was creating an index on the table, it failed as it was not able to extend the temp segment. I added a temp segment and recreated the index. But now i see the index is created on some columns which cannot be seen in the DESCRIBE

[no subject]

2002-10-22 Thread Clinton Naude
What is the syntax to delete multiple objects, or more specifically multiple tables from a user in 1 go. I need to delete 50+ tables/objects without deleting them 1 by 1. Thanks Clint

[no subject]

2002-10-14 Thread Bruno Vanters
Hello, Could you explain me how to deal with folowing error: select * from sysaudit@tg.big * ERROR at line 1: ORA-28509: unable to establish a connection to non-Oracle system ORA-02063: preceding line from TG.BIG (HP-UX 11, Oracle 8.1.6, tg4ifmx 8.1.6, Informix 9.2)

[no subject]

2002-10-10 Thread Santosh Varma
Hello all, I have a client who will be doing the data capture and give me the data in a flat file. what i need to do in oracle is load from that flat file to my database. any scripts available ?? please send me across. ASAP Thanks and regards,Santosh

[no subject]

2002-10-04 Thread Tom Pall
set nomail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

[no subject]

2002-10-01 Thread MIvanov

[no subject]

2002-09-30 Thread Santosh Varma
Hello all, I have a query - i have 2 tables - client and project fields in project table - clientid/projectid fields in client table - clientid/name i want to get the maximum orders one client has got. i mean a project having the greatest clients how to write it in single query ??

[no subject]

2002-09-30 Thread beau
HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

[no subject]

2002-09-27 Thread SARKAR, Samir
SET ORACLE-L NOMAIL _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of

Subject: Hash Cluster Statistics

2002-09-25 Thread timboles
List, Does anyone know of some good resources about gathering statistics on Hash Clusters. I am particularly interested in finding out how full our buckets are and any chained links we have currently. Thanks before hand for you help. Tim Boles DBA Lockheed Martin Information Systems [EMAIL

[no subject]

2002-09-25 Thread Rachel Carmichael
NOMAIL ORACLE-L __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services--

[no subject]

2002-09-04 Thread sultan
Hi friends I am using following command to call report from report srw.run_report ('report=d:\test.rdf destype=file desname=try.out desformat=dflt batch=yes'); I have tested this using After Report /Before Report/Action Trigger. But this is not calling the report. Any solution will be

[no subject]

2002-09-02 Thread RO-Hosur
Please don't sent any more mail to this ID Please take it as a request Please ignore my name Mail ID : [EMAIL PROTECTED] Thanks System Admin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: RO-Hosur INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

[no subject]

2002-08-28 Thread P.V.Sankar
Hi, I would like to know which datatype is best to use for storing text data of around 50 lines.The data is basically a variable length user feedback.I am in confusion whether to go for VARCHAR2 or LONG type. Also in CLOB and NCLOB, can somebody clarify me about CLOBS store single-byte

[no subject]

2002-08-28 Thread Jack van Zanen
Oracle 8.0.5 AIX 4.3.3 I Have following statement, which takes forever and does lots of physical reads ** insert into test_table SELECT v1.engagement, v1.YEAR, v1.period, MAX (v2.net_fee_earned_ptd) ,

[no subject]

2002-08-28 Thread Scott Stefick
I just found a Korn shell script on-line to Delete RMAN backupsets older than a specified number of days. It has syntax in it that RMAN doesn't like, and I can't find a reference to what the script is trying to do anywhere. OS: HPUX 11i Production DB: Oracle 8.1.7.4 Recovery Catalog DB:

[no subject]

2002-08-13 Thread Santiago Argibay Molina
Hello All, We are trying to install Oracle9i on RED HAT linux 7.2 and getting following message: THE JAVA RUNTIME ENVIRONMENT WAS NOT FOUND AT TEMP/BIN/JAVA THE ORACLE UNIVERSAL INSTALLER CAN NOT BE RUN. I have looked through metalink but could not find anything satisfying. I would like to

[no subject]

2002-08-12 Thread kommareddy sreenivasa
SET ORACLE-L NOMAIL __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network

[no subject]

2002-08-12 Thread dgoulet
Oracle releasing clustered file system code The move is designed to allow better management of databases on Linux server clusters. http://computerworld.com/newsletter/0%2C4902%2C73404%2C0.html?nlid=AM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL

[no subject]

2002-08-12 Thread viral desai
Hello, I have a question regarding method of index access(full vs. range) that oracle uses when I use different join methods (Hash vs. Nested loop). Here are the some details about the environment. Server : Oracle Server EE ver 8.1.7.2 OS :

Subject: List archives on line?

2002-08-02 Thread Sackwitz, Antje
Hi, there is a Geman server offering a list archive http://www.doag.org/orafaq/afl-oral.htm they have a lot more links on http://www.doag.org/orafaq/faq2.htm Regards, Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje INET: [EMAIL

[no subject]

2002-07-30 Thread oraora oraora
Guys , my insert statement is below . explain shows 828 for redo size . does it mean the no of blocks ? what should be the ideal value for the same ? what does the value for redo size = 828 indicate ? kindly explain me. insert into MSG_History

[no subject]

2002-07-22 Thread Peter R
Hi Guys, I need to put one hour back for my OS(aix) So How will my database(7.3) handle this?? What steps I have to take?? Any light regarding that?? Thanks in advance peter. _ Chat with friends online, try MSN Messenger:

[no subject]

2002-07-18 Thread ismail nural
i have oracle 8i on windows 2000 server. i have installed developer 6 . Now i can not connect database. Now I get the message on startup: Could not start ORACLEORAHOME81AGENT service on local computer error 3221356553. When i want to start svrmgrl i got sp1 lang.msb not found. what can i do to

[no subject]

2002-07-16 Thread RAHUL GAJANAN MEHENDALE
SET ORACLE-L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: RAHUL GAJANAN MEHENDALE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

[no subject]

2002-07-15 Thread Christopher Royce
CONFIRM L-ORACLE Thnx OK Bye Instant gratification takes too long -- Carrie Fisher Chris Royce [EMAIL PROTECTED] [EMAIL PROTECTED] winmail.dat

[no subject]

2002-07-15 Thread Christopher Royce
CONFIRM ORACLE-L Thnx OK Bye Instant gratification takes too long -- Carrie Fisher Chris Royce [EMAIL PROTECTED] [EMAIL PROTECTED] winmail.dat

[no subject]

2002-07-15 Thread Christopher Royce
SET ORACLE-L REPRO END Thnx OK Bye Instant gratification takes too long -- Carrie Fisher Chris Royce [EMAIL PROTECTED] [EMAIL PROTECTED] winmail.dat

Subject: Re: [Fwd: Please Advise--Your Reaction to Ellison Comme

2002-07-11 Thread Sackwitz, Antje
Hi, as you were discussing that the message was sent to recent posters I guess you are right. I am twice assigned to the list, once at home and once with my office mail account. As I did recent postings to the list from my office account I only received the Ellison Comment mail at my office mail

[no subject]

2002-06-07 Thread sam d
no application server involved. thx Sameer -- We can definitely find the user , but considering my scenario 'all the people are logged in with the same oracle user' , I want to know:From what machine the SQL statement was fired. thx Sam name--- Reardon, Bruce

[no subject]

2002-05-06 Thread Shreepad . Vaidya
Hi, I am facing a very strange problem. Oracle 7.3.4.4.1 and HP 10.2 I do an analyze of a huge table (more than 46 million records) . The query which hits this table and 2 other table has an RULE hint . On the day analyze fails on the big table, performance is very very slow . But with

[no subject]

2002-04-30 Thread Rick_Cale
I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. How can I just remove all of Oracle 9i without touching Oracle 8i? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

[no subject]

2002-04-29 Thread Ravindra B
HELP

[no subject]

2002-04-23 Thread Clinton Naude
How much memory is allocated to each login to Oracle? Is it not 20-30mb? I have heard people mention of 300mb? Surely this would bring most servers down if it was true. Clint Currency.gif Description: GIF image

[no subject]

2002-04-22 Thread farkasb
Hi all! I need a solution about calling sql*loader from pl/sql. I have a version now with external dlls, but actually I don't know the platform so it not seems a good choice. I would like something native oracle solution with oracle's packages or something like that. -- Please see the

[no subject]

2002-04-16 Thread VIVEK_SHARMA
Qs Why is elapsed Time so HIGH in the following SELECT ? NOTE - 1) TBA_GENERAL_ACCT_MAST_TBL is a SYNONYM for GENERAL_ACCT_MAST_TABLE Table 2) The Respective Tablespace Contains ONLY ONE (i.e. This) Object (GENERAL_ACCT_MAST_TABLE) 3) There is a UNIQUE Index on the field of the Where

[no subject]

2002-03-30 Thread Rohit
hi there, I want tips regarding 1z0-023 architecture exam.. please help, Thanks Rohit

[no subject]

2002-03-29 Thread Gene Gurevich
Hi A developer is getting a sporadic errors when trying to access ORacle database via a Cold Fusion screen. The messages on the screen are Oracle Error Code = 0 Timeout while obtaining an Oracle statement lock. I turned tracing on in his session and found this in the trace file: update seg$

[no subject]

2002-03-19 Thread Viktor
Hi all, I've got a query that returned more rows than needed. Here is the query: SELECT distinct m.journal_id||m.yr_of_issue||m.ms_sequence_no||m.check_char MSNO, M.RECEIVED_DATE RECEIVED DATE, M.EDITOR_NO EDITOR NUMBER, S.STATHIST_CODE STATUS CODE, ST.STATUS_DESC

[no subject]

2002-03-17 Thread Oswaldo Castro
SET ORACLE_L DIGEST

[no subject]

2002-02-22 Thread Arul kumar
SET ORACLE-L MAIL * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete

(no subject)

2002-02-20 Thread DBAtracker
I'm a student dba'r running 9i on windows xp. I have created a second database (database name=bill, instance name = bill). After I first created it, I tried to mount it after shutting down the installation seed database (database name = orcl, instance name = orcl). I kept getting the message

RE: (no subject)

2002-02-20 Thread JoJo Al-Zawawi
TED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, February 20, 2002 7:54 AMTo: Multiple recipients of list ORACLE-LSubject: (no subject)I'm a student dba'r running 9i on windows xp. I have created a second database (database name=bill, instance name = bill). After I

RE: (no subject)

2002-02-20 Thread JoJo Al-Zawawi
One more thing about the script I sent -- that was for 8i, not 9i, so check it out in that respect, as well. Cheers, JoJo

[no subject]

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

[no subject]

2002-01-17 Thread sunil
hi, Anybodygot some oracle question dumps or resources for oracle certified internet database administrator exam ?? (exam #1Z0 -411). Thanks in advance :) rgds sunil

[no subject]

2002-01-15 Thread Evan Tate
Nah, Zen in the Art of Archery was the real deal - it predates ZATAOMM by quite a few years... Mohan, Ross [EMAIL PROTECTED] wrote: you oughta apologize to Robert Pirsig, the guy who started the whole thing. -Original Message- Sent: Tuesday, January 15, 2002 12:35 PM To: Multiple

[no subject]

2002-01-03 Thread Ruth Gramolini
Good morning everyone, Can anyone give me the command to analyze a partitioned tabled? To analyze this table unpartitioned I use: analyze table schema.table_name compute statistics; I am partitioning it into 6 partitions and want to compute statistics on each partition. Thanks in advance,

[no subject]

2001-12-27 Thread MILLER, DAVID L (CONTRACTOR)
SET ORACLE-L DIGEST -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MILLER, DAVID L (CONTRACTOR) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

[no subject]

2001-12-21 Thread Blum, Marc
SET ORACLE_L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Blum, Marc INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

[no subject]

2001-12-18 Thread James
Hello Gurus, I am working on a little project using the package utl_http, so far I have had limited success using this package. The below http call fails for some reason, it is supposed to download a page of size ~10K, i.e. 5 pieces of data, but instead it fails, I am not sure why... Any

[no subject]

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

  1   2   >