Re: Snapshot Prob (cont'd) S.O.S., Help!

You are showing privileges at the local side, we need to know whether you have access at the remote side.
What's the definition of your database link? Are you using an username/password combo in it? If you don't do that, Oracle will use the username/password combo for the local database at the remote database.

Hth,

--
Sybrand Bakker, Oracle DBA
NetComrade <andreyNSPAM_at_bookexchange.net> wrote in message news:3835a97c.75663607_at_news.earthlink.net...
> OK....
> This snapshot thing is killing me.
> I am trying to create a snapshot on an 8i DB from a 7.3 DB.
> From what I saw, it creates some TEMP segment in my tablespace (but if
> I use the USING INDEX TABLESPACE it will create some temp think
> there), but I guess once it trasfers the whole table this error
> occurs.
>
>
> SQL>set role none
> 2 ;
>
> Role set.
>
> SQL> CREATE SNAPSHOT user_details
> TABLESPACE swhockeydat
> PCTFREE 30 PCTUSED 50
> STORAGE (INITIAL 100M NEXT 100M)
> REFRESH FAST START WITH sysdate NEXT sysdate+1
> WITH ROWID
> AS
> SELECT * FROM user_details_at_hock.world 2 3 4 5 6 7 8
>
> 9 ;
> SELECT * FROM user_details_at_hock.world
> *
> ERROR at line 8:
> ORA-12018: following error encountered during code generation for
> "SWHOCKEY"."USER_DETAILS"
> ORA-00942: table or view does not exist
> ORA-02063: preceding line from HOCK.WORLD
>
>
> USER PRIVS:
> SQL> select privilege from user_sys_privs;
>
> PRIVILEGE
> ----------------------------------------
> CREATE DATABASE LINK
> CREATE SNAPSHOT
> CREATE TRIGGER
> CREATE VIEW
> CREATE ANY INDEX
> CREATE ANY PROCEDURE
> CREATE ANY SYNONYM
> CREATE ANY TRIGGER
> CREATE SEQUENCE
> CREATE SESSION
> CREATE TABLE
> CREATE VIEW
> DELETE ANY TABLE
> DROP ANY INDEX
> DROP ANY TRIGGER
> INSERT ANY TABLE
> SELECT ANY SEQUENCE
> SELECT ANY TABLE
> UNLIMITED TABLESPACE
> UPDATE ANY TABLE
>
> 20 rows selected.
>
>
> P.S.
> Thanx to everybody who's helping me out.
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>
Received on Fri Nov 19 1999 - 16:29:09 CST