Re: savepoint & rollback problem

Just a guess.

Any DDL sql will do an implicit commit, which removes all previous save points.
Any commit will do the same thing as well.

Save points should only be used in a block of SQL so you there is no chance of DDL creeping in.

Ford Colin wrote in message <87q6mh$gji$1_at_news6.svr.pol.co.uk>...
>I can run the savepoint command in oracle to create a point to rollback to.
>
>e.g
>
>sql>savepoint colin;
>
>however when I need to rollback to this point I am getting
>
>SQL> rollback to colin;
>rollback to colin
>*
>ERROR at line 1:
>ORA-01086: savepoint 'COLIN' never established
>
>Our developers use a lot of savepoints in the code, so it's a real problem.
>we've recently had a major server crash, and the database has had to be
>re-built. I may have missed something in setting it up again, if you know
>of a way to fix this, please help
>
>your thankfully
>
>Colin Ford
>
Received on Wed Feb 09 2000 - 15:01:31 CST