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

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Fri, 19 Nov 1999 20:10:53 GMT
Message-ID: <3835a97c.75663607@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 - 14:10:53 CST