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....
Hi Stephan, Try looking at this article and set a trace on before you run the sql. This might let you see what is being passed through the link........ PURPOSE...
Is the not null constraint on the table "differed"? If the constraint was applied after an initial data load and deferred there is the possibility that you...
Goulet, Dick
dgoulet@...
Nov 5, 2004 3:15 pm
764
I've had a similar issue in SQL-Server. It wouldn't detect that the field was null, so instead, I used the length of the field to restrict the WHERE clause. ...
What happens if you run the insert into a table without the null constraint. How many rows have NULL operator IDs? regards _________________________ David...
This is a corker! It reminds me of that email "101 things you hope your DBA doesn't say" - e.g.: "Hmmm that's interesting" "It shouldn't do that" Another...
Graham Bowden
grahambowden@...
Nov 6, 2004 10:38 am
767
Hi All, I'm giving this package a go on free trial on our Solaris 8 server. It's asking me for the "Port number the Administration Server is listening on", the...
Hi, This is my first post, just joined. :-) I noticed your error text: ORA-01400: cannot insert NULL into ("SYSADM"."Table8"."USER_OPRID") Does this table...
Hello All For Oracle DBAs in Europe (and especially the Netherlands) on this list, I'd like to tell you about a rare oppotunity: Tom Kyte is one of the most...
David Kurtz
info@...
Nov 26, 2004 5:13 pm
770
I wonder if you have an OPRID value of a space ' ' and the space is trimmed. Try this: insert into table@dblinkd (..) select ..... from PSOPRDEFN where OPRID...
Hello All, We are currently running our database, app server and web server (Oracle 8.1.7.2, Tuxedo, WebLogic) system on a Sun V880 server on Solaris 9 with ...
PeopleSoft doesn't (or at least shouldn't) care what kind of storage system you use as long as you are running a supported Operating System and Architecture....
Based on David's excellent book I understand there is a more robust performance monitor for version 8.44 and later. Does anyone have any experience with...
Hello All This is slightly off topic, but here goes. I am trying to configure a PT8.45.10 process scheduler to post to the report reposity via HTTP (no...
Hi David, We run posting via HTTP/HTTPS here at Cambridge Uni. We noticed that the error messages are not very informative, but only a few problems seem to...
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.
