[no subject]

2001-11-28 Thread Michael Netrusov
Hi, Wendy 1. Note the timestamp for each of those files on server. 2. Perform a periodic check on timestamp. 3. Whenever you will get a datetime on a file greater than noted previously, copy the file to the clients. 4. Note the new timestamp. 5. Goto 2. HTH, Yours, "Gugu" - Original Message

[no subject]

2001-11-28 Thread Michael Netrusov
Yes, it is possible. Look for "Graceful Switchover and Switchback" Oracle Standby Database Versions 7.3, 8.0, 8.1 by Lawrence To. The main point is to substitute the online redo logs, never activating the standby database. HTH, Michael www.atelo.com - Original Message - From: "Ed" <[E

[no subject]

2001-11-27 Thread Michael Netrusov
Yes, I've seen it. Oracle Installation, sqlplus, svrmgrl through Terminal Server Client do not work. I used PC Anywhere, everything went fine. HTH, Michael >From: Koivu, Lisa <[EMAIL PROTECTED]> >Subject: svrmgrl and W2k >Date: 27 Nov 01, 03:25 PM >To: Multiple recipients of list O

[no subject]

2001-11-21 Thread Moučka Otakar
Hello I need a help with one problem. In the Oracle version 8.1.7 I´ve deleted a "tablespace" in the Linux, but before this I did´t use a function " Drop". After reboot a database, there was a error: ERROR at line 1: ORA-01116: error in opening database file 7 ORA-01110: data file 7: '/data/db/d

[no subject]

2001-11-21 Thread Moučka Otakar
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?= 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-11-20 Thread Kim_Thompson
-- 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 San Diego, California-- Public Internet access / Mailing Lists ---

[no subject]

2001-11-15 Thread SARKAR, Samir
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

[no subject]

2001-11-14 Thread grace
hi gurus, wat's the difference of 8i ias standard and enterprise? 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: (858) 538-5051 San

[no subject]

2001-11-09 Thread BINAY . KUMAR
SET ORACLE-L NOMAIL --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not c

[no subject]

2001-11-09 Thread Prasad BAV
__ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prasad BAV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

[no subject]

2001-11-09 Thread Prasad BAV
__ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prasad BAV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

No Subject

2001-11-01 Thread linsonpaul/VGIL
hai list, my system (compaq deskpro under os- windows nt)is connected to a printer -HP deeskjet 870cxi professional series.. i want to print one file through the text_io utility of D2k . .i called the printer through a trigger on pressing a button win_api_dialog.select_printer(printername,

No Subject

2001-10-29 Thread Alon Ben-Zvi
Hi List, I have a question regarding server requirements(computer) If any of you have any Idea or experience It would be nice to respond, Thanks in advance all of you. My question is, I have a very large database that have more than 300 tables part of them have more than 50,000,000 records. Can

No Subject

2001-10-29 Thread Saravana Kumar
Hi friends,    Can anyone help me in giving me a checklist to design a database.   Thank U in advance   regards Saravana.  

No Subject

2001-10-19 Thread Paula Wachtmeister
INFO ORACLE-L

[no subject]

2001-10-04 Thread Diego Pessotto
HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Pessotto 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-10-02 Thread Grabowy, Chris
SELECT s.study_id, s.status, sp.status FROM s, sp WHERE s.study_id = 5014 AND s.study_id = sp.study_id(+) AND s.status = 'A' AND sp.status = 'A' I'm stuck trying to figure out how to make this SQL work, and am starting to wonder if it's even possible. I'm trying to get this SQL to retur

[no subject]

2001-10-01 Thread Denmark Weatherburne
Hi DBA's Our production database has a tablespace with the following schema: CREATE TABLESPACE IRD_DATA_LARGE DATAFILE 'E:\ORANT\DATABASE\USR1PROD.ORA' SIZE 128472K AUTOEXTEND ON NEXT 2K MAXSIZE UNLIMITED LOGGING DEFAULT STORAGE(INITIAL 100K NEXT 100K

[no subject]

2001-10-01 Thread rick_stephenson
SET ORACLE-L NODIGEST -- 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 San Diego, California-- Public Internet access / Mailing Lists

[no subject]

2001-10-01 Thread AshishK
I am working on oracle as a developer and have done some primary level DBA activities and want to go for Oracle DBA certification .Can anyone please suggest som ways how to go about. Thakyou Bye

No Subject

2001-09-24 Thread Sinard Xing
test -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing 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-09-22 Thread Soman Manoj
Hi Gurus, I am facing problem while comminting the transaction through OLEDB. Whenever i begin transaction thru ADO(OLEDB For ORACLE) it doesn't return any error,but whenever i try to either commit/rollback the transaction ,it returns error saying "No transaction is active". But the same code wor

No Subject

2001-09-20 Thread Raymond Lee Meng Hong
Yes..it is ok also on both machinese sqlplus . But I found out something that I run my packages in Oracle 8.1.5 and Oracle .7.3.2 , that is no problem on that because the result is quiet fast compare with this oracle 8.1.6 ? Is there any bug fix on this , in the mean time I contact Quest Softwar

No Subject

2001-09-19 Thread Joe LaCascio
Any idea's folks? I'm running a DEC Alpha 4100, DEC Unix 4.0d. I've just installed 8.1.6 with patch 8.1.6.2 and the sqlnet patch 1399208. When I try to start the listener I get the following errors: Script started on Wed Sep 19 12:04:14 2001 % ln^H ^Hsnrctl LSNRCTL for DEC OSF/1 AXP: Versio

No Subject

2001-09-11 Thread Berna UNAL
IT WAS SUCH AN AWFUL ATTACK...SO SORRY FOR AMERICAN PEOPLE.  

No Subject

2001-09-07 Thread Silvina Botindari
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Silvina Botindari 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-09-07 Thread Oberkofler, Dieter
Title: set oracle-l nodigest

No Subject

2001-09-06 Thread Hamid Alavi
SET ORACLE-L DIGEST Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from

No Subject

2001-09-06 Thread Urban . Svanberg
SET ORACLE-L DIGEST -- 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 San Diego, California-- Public Internet access / Mailing Lists --

No Subject

2001-08-31 Thread Stuart Graham
SET ORACLE-L CONCEAL END

No Subject

2001-08-27 Thread Satar Naghshineh
Title: Hello Ladies and Gentlemen, I need to present a proposal to management on Upgrading our database from Oracle 7 to 8i (don't laugh, we know we're behind the times!). I was wondering if anyone out there already has done this. If so, can you please e- mail me a copy of this proposal or

No Subject

2001-08-27 Thread Cherie_Machler
I am running tkprof and explain plan on the following SQL statement: SELECT DISTINCT CNFR_NO, SPLT_PAY_TYPE, ACH_AMT FROM whse_dbo.ACH_TRAN WHERE ACCT_NO = '46807' AND TRUNC(TRAN_DT) = TRUNC(TO_DATE('20-JUL-01','DD-MON-YY')) AND STATUS = '2' AND CNFR_NO >0 AND (SPL

No Subject

2001-08-27 Thread GL2Z/ INF DBA BENLATRECHE
ORACLE-L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE 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-08-23 Thread Denmark Weatherburne
Hi Again DBA's We are running Oracle 8.0.5 on NT 4. I read that Oracle is implemented as one multi-threaded process on NT. I observe two ORACLE80.EXE proceses running in the Task Manager. There are also two STRTDB80.EXE processes running as well. Does the number of ORACLE.EXE processes represent

No Subject

2001-08-14 Thread Tatireddy, Shrinivas (MED, Keane)
UNCUT ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) 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-08-07 Thread Ingrid Diefenbach
SET ORACLE-L MAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ingrid Diefenbach INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailin

No Subject

2001-08-01 Thread Leslie Lu
Hi all, Thank you all those answered my question! I got a compressed file Amin.dmp.Z of 1.28G. After uncompress, the Amin.dmp file is 9.7G. Can someone show me how to import using pipe? The pipe works on Z file or dmp file? (Oracle815 for both export, import db, Sun 5.6). Thank you. Leslie

No Subject

2001-07-24 Thread Raymond Lee Meng Hong
SET ORACLE-L DIGEST Raymond fall asleep in waiting for the Q. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public I

No Subject

2001-07-19 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-07-18 Thread Raymond Lee Meng Hong
SET ORACLE-L DIGEST -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong 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-07-16 Thread Libal, Ivo
Hello I would like to start tracing for different session than my one. How it is possible in 8.1.7 EE? I want to start tracing for different sessions with different levels (not necessary diff. levels). I found that it should be possible with dbms_support package, but i didnt find this package and

No Subject

2001-07-16 Thread Eca Eca
Hi friends : How to calculate the parameters : Shared_pool_size, db_block_buffer, sort_area_size of Database for : 50 session simultaneous 512 MB ram Linux Regards. _ Get Your Private, Free E-mail from MSN Hotmail at http

No Subject

2001-07-10 Thread Joseph Testa
Registry, services? OH wait must be an NT thing, sorry, i was having an acid flashback that unix was going down the tubes. Sorry, joe Coed-naked Database Administration Find 'em fragmented, leave 'em coalesced. >>>[EMAIL PROTECTED] 07/10/01 01:26PM >>> Hello, I need to recreate a database,

No Subject

2001-07-05 Thread ssskrun ssskrun
Hello guys, can anyone tell me how can i have two versions of oracle on the same machine. Is it possible. I have to put together 8.1.6 and 8.1.7 on the same machine. I'm using Windows NT. Thanks in advance Tom Pilfer _ G

No Subject

2001-07-04 Thread Pulikkol Kumar
Hi lists Any one can help me aboutdbms_alert(package)/how can i use in data base triggers

No Subject

2001-07-03 Thread lhoska
test Lyuda Hoska -- 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 San Diego, California-- Public Internet access / Mailing Lists -

No Subject

2001-07-02 Thread Deewaker G.V.
Title: Hi Can any one tell me What is the Expansion of ORACLE... I have never ever come across it. with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. Ph: 4611323 Extn: 216 Fax: 4611324 <> Deewaker G.V..vcf

RE: (No Subject)

2001-06-29 Thread Anand
If you are using Oracle Forms then you can insert it with giving values in single quotes(for ex. 'value'). If your are using SQL*PLUS as your application then insert values using follwing format.(ex. '''value'''). Regards Anand. -Original Message- Subramanian Sent: Friday, June 29, 2001

Re: (No Subject)

2001-06-29 Thread C.S.Venkata Subramanian
[EMAIL PROTECTED]> >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Friday, June 29, 2001 1:30 PM >Subject: (No Subject) > > >> HI Gurus, >> I want to insert single quotes with my data from my application. >> Some data will co

Re: (No Subject)

2001-06-29 Thread chao_ping
- i love oracle's money SQL> drop table testtb; Table dropped. - Original Message - From: "C.S.Venkata Subramanian" <[EMAIL PROTECTED]> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 29, 20

(No Subject)

2001-06-28 Thread C.S.Venkata Subramanian
HI Gurus, I want to insert single quotes with my data from my application. Some data will contain quotes and some may not. How can this be achieved? Kindly help TIA Regards C.S.Venkat Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the offic

No Subject

2001-06-28 Thread Sinardy Xing
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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-06-28 Thread novicedba
Hi Rachel, read your paper 'exploding the myths' , but felt that explanation was necessary atleast for some of them if not all. All along I felt the first few slides were introduction and you will discuss each of the points in detail, and was totally fooled when in the last slide you said "

No Subject

2001-06-27 Thread novicedba
LISTS

No Subject

2001-06-26 Thread Raj
test

No Subject

2001-06-25 Thread Bond Mike A Contr OC-ALC/TILC
Hi, I currently have OWS 3.0.4 and RDBMS 8.0.5 running on the same NT 4.0 machine. I need to upgrade the DB to 8.1.6. Has anyone experienced any problems running that version of OWS (we will upgrade that later) with RDBMS 8.1.6 (on the same machine)?? Thanks, Mike -- Please see the official

No Subject

2001-06-24 Thread Amar Kumar Padhi
db: 8i front-end: forms 6i server: sun os 5.7   We have a requirement to store and display images in forms 6i. We are in the process of evaluating the use of bfile datatype, do let me know about the limitations if any.   1. Is it mandatory to have the image files on the same server as th

No Subject

2001-06-24 Thread Amar Kumar Padhi
db: 8i front-end: forms 6i server: sun os 5.7   We have a requirement to store and display images in forms 6i. We are in the process of evaluating the use of bfile datatype, do let me know about the limitations if any.   1. Is it mandatory to have the image files on the same server as th

No Subject

2001-06-22 Thread Tulika Samrendra
how can i read the alert file of my oracle 8i database insttalled on hp-ux system _ Buy Lagaan & Yaadein music for 30% less. Avail this special offer at http://shopping.rediff.com/shopping/music/offerrediffmailer.htm -- Please see the off

No Subject

2001-06-22 Thread Krishnan, Manjula R.
Dear DBA's: Have any of you come across this bizzare behavior? We have an application that was written using Forms 6i. It runs on the web (using OAS 4.0.8.2) on an 8i database. A user has been granted access through a role. This role APP_READ only has select privileges on all the tables for the

No Subject

2001-06-21 Thread Saravana Kumar
Hai Friends,     I have a small query.                                 I need formulae for calculating the   SGA. TABLESPACE SIZE TABLE SIZE INDEX SIZE ROLLBACK SEGMENT SIZE. It would be really kind enough to help me on this issue.   Thanks Regards Saravana.  

No Subject

2001-06-21 Thread Saravana Kumar
Hai friends,   Here is a interesting question.     My database is behind a firewall,the user access the db thru a web logic server residing  in a different m/c in the same domain where the db resides.I would like to get hold of the

No Subject

2001-06-21 Thread Lakshminarasimhan Santhanam
hi dba's i want to see the underscore parameters such as _db_block_max_dirty_target etc which view should i use for it S.Lakshmi Narasimhan Technology Infrastructure Services WIPRO TECHNOLOGIES 044-4500200 extn 2059 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: L

No Subject

2001-06-20 Thread Narender Akula
SET ORACLE-L DIGEST INDEX ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula 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-06-19 Thread Prashant S. Bhangale
[EMAIL PROTECTED]

No Subject

2001-06-18 Thread Hermanto P
Dear Subscribers, I have a broken database that I wish to recover. The old database come from other SID Could you please help me how to recover ? m-t-x "Our greatest glory is not in never falling but in rising every time we fall" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -

No Subject

2001-06-18 Thread novicedba
LIST

No Subject

2001-06-14 Thread Libal, Ivo
Hello I have a problem with the reserved size of shared pool. It does not seam to be used for packages even if I have big packages (200K). Do you have an idea where the problem can be? Do I have to move the packages somehow (like pin to shared pool)? Regards Ivo Libal FREE_SPACE AVG_FREE_SIZE FRE

No Subject

2001-06-13 Thread Belov Igor
HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Belov Igor 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-06-06 Thread Ron Perrie
--Boundary-00=_G0RI6RO0 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable SET ORACLE-L DIGEST --Boundary-00=_G0RI6RO0 Content-Type: Text/HTML; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printa

No Subject

2001-06-03 Thread Walter K
I have the following in a blob column: 18 21:20:48 CDT 2001: Customer notified of: Order Accepted Wed Apr 18 22:11:09 CDT 2001: Order cancelled: demo Wed Apr 18 22:11:09 CDT 2001: Flagged for Review. When I run the following via SQL*Plus: select dbms_lob.instr(order_text,utl_raw.cast_to_raw

(no subject)

2001-06-03 Thread Sllewnerak
I am having a problem with a form I have developed. I am just learning forms so I don't know what to do about it. I have one form with several blocks in it. When i first run the form I can go on any of the blocks and go through the records one at a time. Then all of the sudden it won't fetch any

No Subject

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

No Subject

2001-05-31 Thread hamid alavi
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

No Subject

2001-05-31 Thread \"Himanshu H Shekhar\"
SET ORACLE-L NOMAIL --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy,

No Subject

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

No Subject

2001-05-29 Thread Glenn Travis
I am migrating data from one database[database1] to another[database2]. I have a link[dblink] between the two and one of the tables[CLOB_TABLE] have CLOB datatype for one of their attributes[CLOB_BODY]. I need to cursor through this CLOB_TABLE and then insert the cursor variable values into datab

No Subject

2001-05-29 Thread Quaglio Andrea
who -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea 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-05-29 Thread Senthil Ganapathi
Hi Everybody, In D2k Report2.5 in the parameter form two user parameters are there with list of values, based on the first parameter value, we need to generate 2nd parameter's list of value. For example First Parameter field for Company code (it will give all list company code) 1- 100 In the 2nd

No Subject

2001-05-15 Thread Smith Goad
set oracle-l digest -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith Goad 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-05-10 Thread Raj Gopalan
DBAs, I have two of my tables and index in nologging mode as I am loading data using SQL*Loader direct path mode. I have scheduled RMAN hot backup everday. When I issue REPORT UNRECOVERABLE, I am getting both the Data and Index datafiles are unrecoverable. I know that I wont be able to recover

No Subject

2001-05-07 Thread lando
help

No Subject

2001-05-07 Thread lando
help

No Subject

2001-05-03 Thread zabair ahmed
Hello Does anybody know what the following ora 600 relates to, ORA-00600: internal error code, arguments: [15212], [1], [], [], [], [], [], [] Wed May 2 20:51:16 2001 Errors in file /opt/oracle/CRMVAN01/admin/udump/crmvan01_ora_29802.trc: ORA-00600: internal error code, arguments: [17090], [],

No Subject

2001-04-26 Thread ARUN K C
Hi, I am trying to take a buffer dump thro the following command alter session set events 'immediate trace name buffer level 10'; but all i am getting is a dump file which does not have any information on it can somebody let me know what i am missing here. the below said information is what there

No Subject

2001-04-25 Thread alessandro
Hi List, How cleanup temporary segment temporary locally managed tablespace ? Thanks Alessandro -- 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 San Diego, California

No Subject

2001-04-11 Thread ludivine . alligier
For the ones who didn't followed the story, I sent a 1Go file. Ok. I did it. But be sure I haven't seen it was so big...Big mistake, I'm sorry everybody, I'll be careful now... I try another time to explain my problem with just a big MAIL !! So sorry So : AIX Version : 4.3.2.

No Subject

2001-04-09 Thread Brijesh Lal
__ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services--

No Subject

2001-04-04 Thread Halil KAYA
Hi, On system such as NT,Win200, AIX, and Linux, you have no control over memory and semaphore parameters as they are automatically set for you. Sample Changes on UNIX System Shared Memory and Semaphore Parameters               HP-UX Release 10.0    DYNIX /AT&T UNIX sys V    SUN 4 SHM

No Subject

2001-04-02 Thread Danisment Gazi Unal
Hello, when is WAIT information written to event10046 raw trace file ? after each WAIT or another mechanism such as cummulative writes after a specified count ? if it's after each WAIT, I will be able to calculate some statistics not given in P1,P2,P3. thanks in advance... = -

No Subject

2001-04-02 Thread aheda
SET ORACLE-L MAIL -- 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 San Diego, California-- Public Internet access

No Subject

2001-03-30 Thread Nancy McCormick
LISTS -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nancy McCormick 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-03-27 Thread Chesebro, Eric
When I create a function in a package and declare it in the specification section it works fine. When I try and make it private by removing the declaration in the spec section I get the following error trying to compile: PLS-00306: Wrong number or types of arguments in the call to functi

No Subject

2001-03-26 Thread Nihar
hi ppl can any body help in changing internal pwd on solaris system. i couldn't find oradim on sun. Is there any similar tools like oradim on solaris.. thanks - NIHAR SANGHVI NetMagic Solutions Pvt. Ltd. 22,Nirlon Complex,Western Express Highway, Goregaon (E), Mumabai 400 063 Phone: 8723003

No Subject

2001-03-23 Thread Jentzig Sven
SET ORACLE-L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jentzig Sven 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-03-22 Thread Chesebro, Eric
Any one know where to find good documentation on sqlloader? Thanks, Eric -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chesebro, Eric INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

No Subject

2001-03-21 Thread Sinardy Xing
Hi, Can I perform a full export without using System account If I have to create a new user to perform a full export what are the roles that need to be granted ? Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED]

No Subject

2001-03-20 Thread Ginger Mejia
IS IT POSSIBLE TO LIST JOB OPPORTUNITIES TO THIS LIST IF ONE BECOMES AVAILABLE? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ginger Mejia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- P

No Subject

2001-03-14 Thread Leslie Lu
__ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ ÞÑÐÄ×ÔÎÊ ¡¡ÉúËÀÖ®¼äµÄ¾ñÔñ ×òÌìÎÒÔÚ¹úÄÚµÄлªÍøÉÏ¿´µ½Ò»¶Î¹ØÓÚ±¬Õ¨°

No Subject

2001-03-13 Thread Muhammed Adnan Ansari
Do any one tried oracle parallel server without using a hardware cluster.infact i am interested in its software demonstration on Win2000 Adv Server. Adnan __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://au

<    1   2   3   >