-
Data MOver Error while loading Application Data
hi there,
While Loading PEopleSoft HRMS9.o i am having this peculiar problem.
I have done REPLACE_ALL * when this problem arised previously through IMPORT*.
I have run all the scripts:
Importing PSPCMNAME
Creating Table PSPCMNAME
Rows inserted into PSPCMNAME
30000, 60000, 90000, 120000, 150000, 180000, 210000, 240000, 270000,
300000, 330000, 360000, 390000, 420000, 450000, 480000, 510000, 540000,
570000, 600000, 4147
Import PSPCMNAME 604147
Building required indexes for PSPCMNAME
- SQL Error. Error Position: 0 Return: 12801 - ORA-12801: error signaled in parallel query server P002 ORA-01652: unable to extend temp segment by 16 in tablespace PSTEMP
CREATE UNIQUE INDEX PSCPSPCMNAME ON PSPCMNAME (OBJECTVALUE1, OBJECTID1, OBJECTID2, OBJECTVALUE2, OBJECTID3, OBJECTVALUE3, OBJECTID4, OBJECTVALUE4, OBJECTID5, OBJECTVALUE5, OBJECTID6, OBJECTVALUE6, OBJECTID7, OBJECTVALUE7, NAMENUM) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING
Error: Unable to process create statement for PSPCMNAME
SQL Spaces: 0 Tables: 5452 Triggers: 0 Indexes: 6700 Views: 0
Ended: Sun May 25 20:50:00 2008
**** PeopleSoft trace has been turned back on
Unsuccessful completion.
Could you please tellme if i have to increase the Tablespace for temp or increase the datafile Size?
-
increase tablespace pstemp
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|