Problem with Oracle Rollback Segment Session
I suspect you're using multiple sessions and the other session cannot "see" the work performed because it is currently uncommitted.

The default Oracle transaction Isolation Level is Read Committed. This means that a  session will not be able to see the work a given session has done until it has explicitly committed the transaction. 

The Oracle Server Concepts Guide explains this in detail.