Wednesday 10 July 2013

ORACLE: finding tables with LOBSEGMENTS in them

I'm prepping to migration a SAP system on an ORACLE database
As part of this I find that some of the biggest segments in the database are LOBSEGMENTs
How do you find what table they are part of?

select table_name from dba_lobs where SEGMENT_NAME=’’;

Hope that comes in handy...

Monday 1 July 2013

SAP Central Process Scheduling (CPS) - Job's in error with no logs

See SCN blog: http://scn.sap.com/people/jamie.neilan/blog/2013/07/01/sap-cps--1-silly-way-to-create-an-abtuse-error