Oracle/Faild transaction issue
I have a question there is a transaction going on in oracle database due to space constraint it got failed. So my question is does the transaction will completely failed or it will partially done? and if it's partially done how can we go back and check data until it has done.
Unless you have auto-commit enabled (e.g. committing after a fixed number of transactions), then the entire transaction would have rolled back and failed in its entirety.
In Oracle's SQL*Plus utility, you can set AUTOCOMMIT (Reference: http://docs.oracle.com/cd/B19306_01/server.102/b14357/ch12040.htm#i2698639
). Outside of the SQLPLUS utility, AUTOCOMMIT is not a database configuration item (refernece: http://docs.oracle.com/cd/B19306_01/server.102/b14357/ch12040.htm#i2698639
The easiest check to see if any of your transactions have been committed is to query the destination table(s) where the insert/update/delete was to have occurred.
I hope this helps.