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

Tuesday 15 January 2013

SAP SCN Blogging running in parallel

Just a quick first 2013 post to mention that I am now utilising SAP SCN blogging in order to be more closely tied into the SAP professional community - I will post more general thoughts on here and link together for any few who may stumble across my blogs.

http://scn.sap.com/people/jamie.neilan/blog