CSPP's latest report

If you are interested in latest report of CSPP(Computer Systems Policy Project)... http://www.cspp.org/reports/ChooseToCompete.pdf -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcit

RE: Oracle Magazine Awards

Sorry, I don't have that much "pitiful cash" :)      -Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Thursday, November 20, 2003 4:26 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle Magazine Awards YOU may send the winners some cash   Tanel.

RE: Oracle Magazine Awards

Congratulations to all the award winners!   Btw, do they get any cash awards or just a piece of paper? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, November 20, 2003 2:05 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle Magazine

RE: import from 8i to 9i /IMP-00003:ORA-02298

Update...   Oracle filed a bug (#3083916) to resolve this and they suggested a workaround for the time being.. We have function based indexes on the associated PKs and dropping those indexes letting us enable the constraints. -Original Message-From: [EMAIL PROTECTED] [mailto:

RE: import from 8i to 9i /IMP-00003:ORA-02298

Just to update you all... I am not having any problems if I setup a db link from 9i to 8i and get the data then enable the constraints. Oracle asked me to create a test case for them. I have sent them all the information they have asked for.   Thanks, Surendra -Original Message-F

RE: import from 8i to 9i /IMP-00003:ORA-02298

I did that already. Please see below..   ERROR 1: = IMP-00017: following statement failed with ORACLE error 2298: "ALTER TABLE "TWESAU" ENABLE CONSTRAINT "FK_LC_AU_SYSID""IMP-3: ORACLE error 2298 encounteredORA-02298: cannot validate (CMS.FK_LC_AU_SYSID) - parent keys not found    

RE: import from 8i to 9i /IMP-00003:ORA-02298

I have opened TAR this morning. Sure, will let you know. Thank you all for your time. Surendra -Original Message- Sent: Wednesday, July 09, 2003 11:30 AM To: Multiple recipients of list ORACLE-L I suggest calling Oracle Support. Get a test case ready. Please post how the problem gets

RE: import from 8i to 9i /IMP-00003:ORA-02298

I tried it on my sun box, still same problem. Also I tried with no compressing/uncompressing of dmp file, no luck. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 08, 2003 5:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE:

RE: import from 8i to 9i /IMP-00003:ORA-02298

I did that. -Original Message- Sent: Tuesday, July 08, 2003 5:45 PM To: Multiple recipients of list ORACLE-L Run the following command after both tables are loaded and the constraint is not enabled select vs_off_sysid from cms.twesvs where vs_off_sysid not in (select of_off_sysid from c

RE: import from 8i to 9i /IMP-00003:ORA-02298

With all my today's trials(including import into 8i db on Sun) I used different export file than the one I have used other day. I am wondering if the ftp(I did it in bin mode only) from unix box to windows box caused something? Anyway, I got my Sun box ready with 9i and will know soon if the

RE: import from 8i to 9i /IMP-00003:ORA-02298

Sorry..I forgot to write the query... select count(*) from twesvs where VS_OFF_SYSID not in (select OF_OFF_SYSID from TWESOF); -Original Message- [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 5:10 PM To: Multiple recipients of list ORACLE-L Yes, I am sure. Just to make sure, I

RE: import from 8i to 9i /IMP-00003:ORA-02298

Yes, I am sure. Just to make sure, I have compared the counts from export log file and import log file. Also I compared it with import log file I did in to 8i database. What I did with two pass import is..first I have imported with constarints=n then I imported with ROWS=N & CONSTARINTS=Y. So I am

RE: import from 8i to 9i /IMP-00003:ORA-02298

Title: RE: import from 8i to 9i /IMP-3:ORA-02298 Hi Raj,   First I tried doing as a DBA user now I tried using SYSTEM. But still the same problem.   Thanks, Surendra -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 08, 2003 3:34 PMT

RE: import from 8i to 9i /IMP-00003:ORA-02298

I tried importing data first then enabling constraints, same problem. I have disabled(it is not enabled to begin with but reporting 'ENABLED' in USER_CONSTRAINTS) one of those constraints and tried to enable it manually. Same error. And I have checked the data again. It is having parent keys. Than

FW: import from 8i to 9i /IMP-00003:ORA-02298

Hi Kirti, As I have mentioned, my data is clean. I could import this data into an existing 8i database. Do you still think that importing data in two passes would fix it? Anything changed form 8i to 9i regarding iport process? I tried catching the invalid data into excetions and did cross checkin

import from 8i to 9i /IMP-00003:ORA-02298

Hello All, We are working on migrating 8i databases to 9i. As Sun boxes are not available yet, I have decided to do some experiments on my PC. I am trying to import into 9i database using export dump file of 8i database. I have my 8i database created in US7ASCII and I have created 9i database also

RE: CASE in PL/SQL

Thank you. Surendra -Original Message- Sent: Monday, July 07, 2003 10:19 AM To: Multiple recipients of list ORACLE-L The problem was explained clearly but the context in which it had to be used was obscure. Rajendra Jamadagni had suggested a solution using functions which could be calle

RE: CASE in PL/SQL

04 Thu 9/25/2003 1 2004 Fri 10/3/2003 2 2004 Sat 10/11/2003 2 2004 Tue 12/30/2003 2 2004 Wed 1/7/2004 3 2004 Wed 3/3/2004 3 2004 Thu 3/11/2004 3 2004 HTH, T. From: Surendra Tirumala 02-Jul-03 19:44 Subject: Re : CASE in PL/SQL Hi Tebbe, "SELECT (MOD(TO_NUMBER(TO_CHAR(add_months(sysdate,9)

RE: CASE in PL/SQL

on_date,'''')) > > P.S The reason for <3 condition check in CASE Statement is, if a > sysdate+9months falls in next Financial year , I need to  change Year > accordingly. > > But,this works only in SQL, in Procedures, i cannot do this using CASE

RE: CASE in PL/SQL

27;''))+1 > else to_number(to_char(main_rec.termination_date,'''')) > > P.S The reason for <3 condition check in CASE Statement is, if a > sysdate+9months falls in next Financial year , I need to change Year > accordingly. > > B

RE: CASE in PL/SQL

, if a sysdate+9months falls in next Financial year , I need to change Year accordingly. But,this works only in SQL, in Procedures, i cannot do this using CASE Statement Can anybody give some ideas on how to approach this?. I have to use this in a cursor (not in the body of my procedure, so condi

CASE in PL/SQL

ing CASE Statement Can anybody give some ideas on how to approach this?. I have to use this in a cursor (not in the body of my procedure, so condition checking like "If then else " after fetching year is not possible) Any help would be greatly appreciated. Thanks, Surendra Tirumala Databas

RE: Client Distribution

Hi Dave, Thank you very much for your detailed reply. I am looking in to it and will let you know how I am going to handle it in my case. Sorry, it took a while just to say thanks also as things have been hectic on my side. Thanks again. Surendra -Original Message- [mailto:[EMAIL PROTE

Client Distribution

Hello All, We have been exploring different options to distribute the Oracle client to users to deploy an application. Earlier, we used to use Install Anywhere or do it manually. I am thinking there should be a better way folks out there must be using. Our present requirement is to have a mini

RE: [Q] SMON take too much time to clean up?

That was the first check I did. And all my temp tablespaces are of "TEMPORARY" type only. I did lot of reasearch on metalink and I found there are some issues with 8.1.7 in this regard. I got this suggestion from metalink only. -Original Message- Sent: Thursday, January 16, 2003 4:52 PM To

RE: [Q] SMON take too much time to clean up?

I do have my pctfree set to 0 for all my tablespaces. But I observe my temp ts filled up at times and continue to be in that status even if I don't have any active transactions using the temp. I wake up the SMON by issuing the following to do the cleanup. And I have 8.1.7 running. alter tablespa

RE: Rule Vs Cost

ve so many advantages with CBO? I am exploring the option of using PQ with couple of reports but the RBO is forcing me to stop thinking about it. All your suggestion are very much appreciated. Thanks in advance. Surendra Tirumala Oracle DBA Cabinet for Workforce Development Common

RE: Rule Vs Cost

s but the RBO is forcing me to stop thinking about it. All your suggestion are very much appreciated. Thanks in advance. Surendra Tirumala Oracle DBA Cabinet for Workforce Development Commonwealth of Kentucky -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John K

RE: bash: ./genclntsh: bad interpreter: Permission denied

Pl check the execute permission on the script. I remember I had the same error message with my bash shell. -Original Message- Sent: Thursday, June 27, 2002 4:56 PM To: Multiple recipients of list ORACLE-L ltiu wrote: > > Hello, > > Could someone help me decipher the following: > > "s

RE: RMAN[2]

Dennis, Thanks for your detailed reply. Yes, I am working on something to backup catalog as well. Thanks for your suggestion about the book. This is the first time I am seeing a suggestion to look into something other than Rama Velpuri's one, as far as B&R is concerned. Again thanks for everyth

RE: Re[2]: how to you stop an export?

Once I tried CTRL-D, it resulted in core dump. Best way is to kill the process from other session. Thanks, Surendra -Original Message- Sent: Monday, June 10, 2002 10:18 PM To: Multiple recipients of list ORACLE-L You can try to press CTRL-D Hello, Tuesday, June 11, 2002, 1:03:29 AM,

RE: Oracle IAS

I hit the same bug with P4. Refer to Note:131299.1 -Original Message- Sent: Tuesday, June 11, 2002 6:58 AM To: Multiple recipients of list ORACLE-L I know there is a bug with JIT for 8i database. JIT-compiler (which is from symantec I believe) does not recognize P4. I think that should

RE: RMAN[2]

Dennis, How much do you think the network matters in the following scenarios? Case 1: Catalog is on Box A and Target is on Box B and we are invoking RMAN from Box C Case 2: Catalog is on Box A and Target is on Box B and we are invoking RMAN from Box A Case 3: Catalog is on Box A and Target is

RE: RMAN[2]

I have been doing this only. Still it is trying to write on target machine. Thanks, Surendra -Original Message- Sent: Monday, June 10, 2002 2:04 PM To: Multiple recipients of list ORACLE-L sorry ... there is another way install RMAN on the remote machine and connect to the remote

RE: RMAN

Dennis, Thanks for your quick reply. Thanks for your suggestions. Yes, a while ago I am also forced to conclude that properly configured NFS is the only option. But I am not sure when I would be able to do that. For the time being I have decided to use the extra space avaialble on my target ma

RMAN

Hello All, I have been working on a strategy to implement a RMAN based backup and recovery strategy. Can anyone please suggest me if there is a way to force the RMAN to write the backups to a machine other than the one on which target database is present? Thanks for your help. Surendra -- Ple