Oracle Data

[Jayachandra]

Hi to all,

I have data which is available in Oracle. Now I want to take backup. Can anybody help in this concept.

And also

Database is not updating automatically when I delete the records or modified. But if I set the option 'Set Autocommit On' then only it is working.If I close Oracle then it will be Set Off. Is there any alternate way to set it when I logon to oracle to commit it.

Thanks and looking for reply from anybody.

[amitpatel66]

Hi to all,

I have data which is available in Oracle. Now I want to take backup. Can anybody help in this concept.

And also

Database is not updating automatically when I delete the records or modified. But if I set the option 'Set Autocommit On' then only it is working.If I close Oracle then it will be Set Off. Is there any alternate way to set it when I logon to oracle to commit it.

Thanks and looking for reply from anybody.

Every time when you connect to oracle database, the GLOGIN.sql file is executed which is available in the path "\Oracle\ora8i\sqlplus\admin".

Include the line 'SET AUTOCOMMIT ON' in this file and then the AUTOCOMMIT option will be set automatically every time u connect to a database. Then you will not require to manually SET AUTOCOMMIT ON

[debasisdas]

All the transactions are written to the database only when u commit.
Setting the autocommit option to ON ,commits all the transactions as soon as they are executed. This is not a good practise. Because it does nota llow you to rollback any of your transactions if required to do so. U need to commit manually after the the transactions are over. Autocommit is an evvironment variable for SQL* PLUS. it automatically gets reseted to OFF everytime u close the tool . To chang it follow the steps as suggested in the previous post.