Month: February 2008

Application Designer Automation

In going through the registry, I found a reference to “PeopleSoft.ApplicationDesigner”.  But, I cannot find any documention on how to use it.

I was able to create an object in WScript:

var obj = new ActiveXObject("PeopleSoft.ApplicationDesigner");

But, I cannot figure out what methods to use with the obj variable.

I posted a question on Oracle Mix, but no one has answered, yet.  Jim Marion has pointed out Grey Sparling Solutions, but I haven’t found any information there.  I really like some of the solutions they have created — they are very innovative.

Please let me know if you have any ideas on how to get more information.

ORA-01502: Indexes in unusable state

I kept getting error messages like this:

ORA-01502: index 'SYSADM.PS_PSAESTMTDEFN' or partition of such index is in unusable state

I found the answer to the problem here:

ORA-01502 Oracle Index in Unusable State

As Katie mentioned in the comments, the status in 10g is UNUSABLE instead of INVALID.

Here is a quick script to rebuild all of the problem indexes:

declare
begin
   for index_rec in (select owner, index_name
                     from dba_INDEXES
                     where status = 'UNUSABLE')
   loop
      execute immediate 'alter index ' || index_rec.owner || '.' ||
          index_rec.index_name || ' rebuild';
   end loop;
end;