Oracle | PeopleSoft Tutorial

Tag Archive

Tag Archives for " Oracle "

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
2

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 5
>