Not enough privileges when user SYS?

[efrijters]

Hello,

I'm building a replication db. One life db and one replication db on the same server. Oracle version 8.1.7.4.9.

I created the Master Site and I am trying to create a SNAPSHOT LOG on a random table. I created a special TS for the snapshot logs.

When I try to create the snapshot log as user SYS, I recieve the following message:


SQL> SHOW USER
USER is "SYS"
SQL> CREATE SNAPSHOT LOG ON [schema.table] TABLESPACE MVIEWLOG
2 /
CREATE SNAPSHOT LOG ON [schema.table] TABLESPACE MVIEWLOG
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'MVIEWLOG'


When I ommit the 'TABLESPACE MVIEWLOG'-clause, it creates the log succesfully in the SYSTEM-ts, but I don't want that offcourse. I can also create tables in TS 'MVIEWLOG'. The user SYS hasn't been altered since I created the db.

Can someone help me?

Thanks in advance!

Erik

[gbrabham]

Sounds like you don't have quotas on the tablespace in question
for SYS.

Shouldn't you be creating the snapshot logs with the REPADMIN
or SCHEMA OWNER account ??? Why SYS???

Gregg

[efrijters]

Uhmmm maybe THAT'S the problem...
I'll try REPaDMIN and schema owner instead...
I'll post the outcome asap.

Thanks sofar!

[efrijters]

Well... I tried the schema owner AND repadmin, but the same error keeps coming back...

[thomasp]

You could try

ALTER USER REPADMIN QUOTA UNLIMITED ON MVIEWLOG;

and then try creating the snapshot log.