Script to update the Tablespace for all the records in the Project.

Script to update the Tablespace for all the records in the Project. when we import Project in the client instance, we can use this SQL to change the tablespace for all the records at time, rather changing it one by one.
Update PSRECTBLSPC
SET DDLSPACENAME = {NEW TABLESPACE}<new_name>
WHERE DDLSPACENAME = {OLD TABLESPACE};<old_name>
and RECNAME IN (Select A.OBJECTVALUE1 from PSPROJECTITEM A, PSRECDEFN B
               Where A.PROJECTNAME = {PROJECTNAME} and A.OBJECTTYPE = 0 and A.OBJECTID1 = 1 and A.OBJECTVALUE1 = B.RECNAME and B.RECTYPE =0)

Views: 52

Reply to This

Replies to This Discussion

it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.
Please write me on my email (captkristen899@gmail.com)

RSS

PeopleSoft Jobs in US

Videos

  • Add Videos
  • View All

© 2020   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service