Month: July 2009

Export Problems in 10g OEM

I was working with one of our Oracle 10g databases the other day when I tried to do an data pump export using the OEM. It seemed to be doing it, but then spat out this error: ORA-20204: User does not exist: EXP ORA-06512: at “SYSMAN.MGMT_USER”, line 122 ORA-06512: at “SYSMAN.MGMT_JOBS”, line 139 ORA-06512: at […]

XP to Windows7 networking

I had to rebuild my Windows7 Media Center PC a little while ago, that all went OK and its working fine now. I can watch all the media OK and add new media to it from me Windows Vista PC OK. So I thought everything was OK with. However, I built and XP laptop over […]

SQL to show code of stored procedure

I was doing some system checking the other day and I needed to find out what a certain stored procedure did. But I couldn’t readly see how to view the code of the stored procedure. After some digging of google I found how to use SQL command to show code of stored procedure in Oracle […]

Auditing Oracle Database Logons

I’m running a project at work at the moment to clean up some of our old version 8 and 9 databases. To do this I had to somehow track if anyone was logging into them and who. Luckly the team at Burleson consulting had some good information about Auditing and reporting Oracle user activity. It […]