Oracle: Create Snapshot fails with ORA-01031

Linux howto's, compile information, information on whatever we learned on working with linux, MACOs and - of course - Products of the big evil....
Post Reply
User avatar
^rooker
Site Admin
Posts: 1483
Joined: Fri Aug 29, 2003 8:39 pm

Oracle: Create Snapshot fails with ORA-01031

Post by ^rooker »

[PROBLEM]
The command "CREATE SNAPSHOT myuser.table1 as ...."
gives the error "ORA-01031".

[NOTES]
First of all:
Oracle usually shows you "where" the error happened by placing a "*" below the problematic part.
In this case, the position of the "*" will not make sense. It's the "CREATE SNAPSHOT" which is failing.

[SOLUTION]
I haven't verified a solution, yet - but I'm working on it. See posts below!
User avatar
^rooker
Site Admin
Posts: 1483
Joined: Fri Aug 29, 2003 8:39 pm

this is tricky...

Post by ^rooker »

OK, now here's a possible solution:

If you are trying to create snapshots as the Replication-admin (e.g. repadmin) and if the to-be-created snapshots are in the tablespace of some other user (e.g. hans) then make sure that hans has sufficient rights to create stuff in his own tablespace!!

-------------------------------------------
grant alter any snapshot to HANS;
grant alter session to HANS;
grant create any snapshot to HANS;
grant create cluster to HANS;
grant create database link to HANS;
grant create procedure to HANS;
grant create sequence to HANS;
grant create session to HANS;
grant create synonym to HANS;
grant create table to HANS;
grant create trigger to HANS;
grant create type to HANS;
grant create view to HANS;
grant unlimited tablespace to HANS;
Post Reply