You can try some thing like this: DELETE FROM PS_MESSAGE_LOGPARM WHERE process_instance < (SELECT MAX(prcsinstance) FROM psprcsrqst WHERE enddttm < SYSDATE -...
Hi Chow, Thanks a lot for your prompt reply. Sorry for missing out those additional details. Well, the instance name is FSNTRN - less than 8 chars, so doesnt...
Make sure cookies are enabled in your browser - although I believe you get a different error message if cookies are disabled. Did you give an authentication...
Some issues with this... - Anything done to PS_MESSAGE_LOGPARM should probably also be done to PS_MESSAGE_LOG. These tables should be in sync, or close. -...
Not sure what the column DTTM_STAMP_SEC represents in the ps_message_log table I will take it to be a date stamp and eliminate all old entries from the ...
michael.ngong@...
Oct 6, 2004 3:22 pm
738
I agree with you on PS_MESSAGE_LOG part. The MAX(prcsinstance) will only identify the maximum process_instance number 31 days back, so one can delete all the...
Hi, "Receiving ORA-00439 Feature not enabled: Online Index Build" Does anybody know how I can enable this feature in 8.1.7.2.1 Standard Edtion, without having...
Andy I'm afraid you are stuck. Online Index stuff is only in the Enterprise Edition and there is no (post-installation/paying for the correct Oracle ...
... OK, I see what you're doing now. I misunderstood the first time I read it. Sorry about that. :) ... Yeah, I guess it comes down to personal preference....
"Bitmap indexes are available only if you have purchased/Installed the Oracle8i Enterprise Edition." I think / believe you can not mix & match Standard edition...
Online index rebuild is an enterprise edition only feature. You need to deinstall the existing Oracle software, or install Enterprise in a separate home &...
Goulet, Dick
dgoulet@...
Oct 12, 2004 4:59 pm
744
Thanks for the input. Just what I expected. I suppose I was hoping that I could make things easier on myself. Cheers Andy ... From: Goulet, Dick...
It may interest every body to know what are the differences between SE and EE. He is the Oracle Product family paper which explain that (cover 10g and in fact...
Hi, I'm a DBA getting exposed to the PeopleSoft side. My manager has asked me to research what tables should be kept in sycn if we were to purge old records...
Ed.Maynard@...
Nov 3, 2004 7:59 pm
747
Hi The list of tables is in prcsclr.dms Regards Sean Roderick...
... It may depend on your version of PeopleTools. On 8.41, there is a good range of Process Scheduler options you can set to purge the PSPRCSRQST regularly. ...
Can some give me idea about refreshing of Peoplesoft Database instance or what step involve for database refreshing specially for oracle database. Thx in...
Two cases I know of in Unix/Oracle a)Systems with the same layout/configuration backup and restore b)Systems with different physical layouts/configuration...
michael.ngong@...
Nov 4, 2004 7:10 pm
752
... Hi, Forgive my ignorance. What is this file and where can I find it?...
Hi prcsclr.dms is in the scripts directory in your Peopletools environment , eg. c:/PT8.nn/scripts It's a DMS file which can be run in Data Mover. You could...
Hello, I'm running the following sql-statement on a Oracle 9i database, GBL is a database link pointing to an oracle 8i database. INSERT INTO Table8@......
Hi I would like to know oracle database or Peoplesoft Database..... in oracle database ,you can rebuild the table and index then compile the views and trigger....
Hi Stephan, You will probably find that the field OPRID in the table PSOPRDEFN cannot be NULL (see below). That means you will have to supply data for each row...
Hi Andrew, many thanks for the fast answer. That was my first idea, too. To make sure I provide data for each row, I only use rows where a.oprid is not null ...
Hi Stephan, This is correct. The NVL() function replaces all occurances of oprid with 'something', where the oprid is null. Basically the function replace the ...
Hi Andy, sure - however a.oprid is not null according to the where condition. My question is just why is oprid NOT NULL in the where condition but NULL in the...
I can't reproduce this on 8.1.7.4 and 9.2.0.5 on Windows in either direction. It can't be a null being selected from the table because of the IS NOT NULL ...
I have also tried and I canot reproduce this either. I have looked at metalink and the only thing I could find that matched this problem is using Bulk inserts....
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
