Oracle – PeopleSoft Tutorial

Tag Archive

Tag Archives for " Oracle "

ORA-00997: illegal use of LONG datatype

During PeopleTools upgrade or PeopleSoft application upgrade, you may get an Oracle error: ORA-00997: illegal use of LONG datatype. This post will walk you through the steps to workaround and resolve the error. I encountered this error during PTools upgrade and based on the symptoms, it looks like you may face this error in PeopleSoft application […]

Continue reading

ORA-60019: Creating initial extent of size 14 in tablespace of extent size 13

During PeopleTools upgrade, there is a step to convert LONG datatypes to CLOB and BLOB. When using Oracle database, you may get this error: ORA-60019: Creatin g initial extent of size 14 in tablespace of extent size 13 The numbers associated with the extend size may change according to the tablespace involved in the DDL statement […]

Continue reading
5

Get Count of All PeopleSoft Tables with one SQL

While performing upgrades or applying maintenance to your PeopleSoft applications, you might want to get row count of all your PeopleSoft tables. There are few ways of doing it which we will discuss below and finally the one which I think is the easiest and most efficient way. Option 1: Running UPGCOUNT AE UPGCOUNT is […]

Continue reading
1

Oracle PL/SQL Cheat Sheet

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation’s procedural language extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7) and IBM DB2 (since version 9.7). Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. While PL/SQL is easy to learn, it can […]

Continue reading
1 2 3 4
>