EGL: Running cp_crttbl.sql Script to Create TABLE PS_CLO_RE_TAO Errors With ORA-02195 (Doc ID 2088116.1)

Last updated on JUNE 26, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ENVIRONMENT:
-----------------------------
Release 9.2 PUM 13 - upgrade

ISSUE:
----------

while applying PUM 13 and running cp_crttbl.sql script, receive ORA-02195 error.
Same script ran in all non-prod environment without any issue. but failing in production.

ERROR:
-----------------

19:24:04 SQL> CREATE TABLE PS_CLO_RE_TAO (PROCESS_INSTANCE DECIMAL(10) NOT NULL,
19:24:04 2 CLOSING_SET VARCHAR2(20) NOT NULL,
19:24:04 3 CF_GROUP_NBR SMALLINT NOT NULL,
19:24:04 4 ACCOUNT VARCHAR2(10) NOT NULL,
19:24:04 5 ALTACCT VARCHAR2(10) NOT NULL,
19:24:04 6 DEPTID VARCHAR2(10) NOT NULL,
19:24:04 7 OPERATING_UNIT VARCHAR2(8) NOT NULL,
19:24:04 8 PRODUCT VARCHAR2(6) NOT NULL,
19:24:04 9 FUND_CODE VARCHAR2(5) NOT NULL,
19:24:04 10 CLASS_FLD VARCHAR2(5) NOT NULL,
19:24:04 11 PROGRAM_CODE VARCHAR2(5) NOT NULL,
19:24:04 12 BUDGET_REF VARCHAR2(8) NOT NULL,
19:24:04 13 AFFILIATE VARCHAR2(5) NOT NULL,
19:24:04 14 AFFILIATE_INTRA1 VARCHAR2(10) NOT NULL,
19:24:04 15 AFFILIATE_INTRA2 VARCHAR2(10) NOT NULL,
19:24:04 16 CHARTFIELD1 VARCHAR2(10) NOT NULL,
19:24:04 17 CHARTFIELD2 VARCHAR2(10) NOT NULL,
19:24:04 18 CHARTFIELD3 VARCHAR2(10) NOT NULL,
19:24:04 19 PROJECT_ID VARCHAR2(15) NOT NULL,
19:24:04 20 BOOK_CODE VARCHAR2(4) NOT NULL,
19:24:04 21 BAL_SHEET_IND VARCHAR2(2) NOT NULL,
19:24:04 22 GL_ADJUST_TYPE VARCHAR2(4) NOT NULL,
19:24:04 23 DATE_CODE VARCHAR2(1) NOT NULL,
19:24:04 24 BUDGET_PERIOD VARCHAR2(8) NOT NULL,
19:24:04 25 SCENARIO VARCHAR2(10) NOT NULL) TABLESPACE PSGTT01 STORAGE (INITIAL
19:24:04 26 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10
19:24:04 27 PCTUSED 80
19:24:04 28 /
CREATE TABLE PS_CLO_RE_TAO (PROCESS_INSTANCE DECIMAL(10) NOT NULL,
*
ERROR at line 1:
ORA-02195: Attempt to create PERMANENT object in a TEMPORARY tablespace


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms