PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

We are converting our database from non-unicode to unicode and while importing the table structures

edited Oct 27, 2017 2:43PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 9 commentsAnswered

Importing  PSOPTIONS

Creating Table  PSOPTIONS

Import  PSOPTIONS  0

Error: Import Record name PSOPTIONS

SQL Spaces: 0  Tables: 12569  Triggers: 0 Indexes: 0  Views: 0

Not sure what the error is exactly but Here's the content from the trace log:

1-50285  11.04.07    0.024000 Cur#1.5552.HRSIT01 RC=942 Dur=0.001000 COM Stmt=SELECT 'PS_DOES_TABLE_EXIST' FROM PSOPTIONS

1-50286  11.04.07    0.002000 Cur#2.5552.HRSIT01 RC=942 Dur=0.001000 COM Stmt=SELECT 'PS_DOES_TABLE_EXIST' FROM PSSTATUS

1-50287  11.04.07    0.003000 Cur#1.5552.HRSIT01 RC=942 Dur=0.001000 COM Stmt=SELECT 'PS_DOES_TABLE_EXIST' FROM PSOPTIONS

1-50288  11.04.07    0.001000 Cur#1.5552.HRSIT01 RC=0 Dur=0.000000 COM Stmt=CREATE TABLE PSOPTIONS (MULTIJOB VARCHAR2(1) NOT NULL,    SYSTEMTYPE VARCHAR2(3) NOT NULL,    SHORTNAME VARCHAR2(15) NOT NULL,    LONGNAME VARCHAR2(30) NOT NULL,    MULTICOMPANY VARCHAR2(1) NOT NULL,    LANGUAGE_CD VARCHAR2(3) NOT NULL,    HELP_CONTEXT_LAST INTEGER NOT NULL,    MULTICURRENCY VARCHAR2(1) NOT NULL,    GRANT_ACCESS VARCHAR2(1) NOT NULL,    STATS_GATHER VARCHAR2(1) NOT NULL,    STATS_TABLE VARCHAR2(1) NOT NULL,    STATS_TIMER INTEGER NOT NULL,    STATS_START tIMESTAMP NOT NULL,    STATS_STOP tIMESTAMP NOT NULL,    NVSUSEBUSUNIT VARCHAR2(1) NOT NULL,    BACKGRNDDISCINT INTEGER NOT NULL,    CHGCTL_USE_HISTORY VARCHAR2(1) NOT NULL,    CHGCTL_USE_LOCKING VARCHAR2(1) NOT NULL,    TRANS_CHG_LASTUPD VARCHAR2(1) NOT NULL,    DBLENGTHTYPE VARCHAR2(1) NOT NULL,    TEMPTBLINSTANCES SMALLINT NOT NULL,    TEMPINSTANCEBATCH SMALLINT NOT NULL,    TEMPINSTANCEONLINE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center