PeopleSoft Wiki

Or you can navigate to the content reference and delete it by pressing delete option

I need to delete around 1500 content. Its very difficult to navigate and delete.
Can any one suggest me some other way to done the task.

In Application Designer, put them into a project (this will take the most time), then set their upgrade status to delete, upgrade. Export the project to file. Reimport the project from file and treat the file project as the source. This will reimport them and cause all of the ones in the project to be deleted.

You could alternatively figure out the relevant PeopleTools tables and delete from them, but this is quite dangerous and easy to leave a few out and may mess up your entire portal registry.

I have a question, I want to change the "Sequence Number", and copy to other Data Base.
I tried these steps:
1. Change this field in PIA, and add this content ref into project.
2. Copy to file.
3. In another Data Base, Copy from file.
But in this step, I got a error "Duplicated Key …".

Any body knows how to do this?
Thanks.

If you try to copy from file you will get this error because the CREF already exists. Are you able to simply update the sequence number in the PSPRSMDEFN database table instead of copying-and-replacing the CREF?