创建快照为何不能生成数据??急急急
nlzjy 2004-11-24 06:54:56 有一个远程ORACLE数据库中的表DM_ORG,在本地创建一个数据链路SOURCE_DATA,
运行SELECT * FROM DM_ORG@SOURCE_DATA能显示远程数据库表中的数据.
在本地数据库中JK_DATA,JK_IDX表空间创建如下快照:
CREATE SNAPSHOT DM_ORG
PCTFREE 30 PCTUSED 70 MAXTRANS 255 STORAGE ( INITIAL 120K NEXT 0K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
TABLESPACE JK_DATA
BUILD DEFERRED
USING INDEX TABLESPACE JK_IDX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE( INITIAL 80K NEXT 0K MINEXTENTS 1 MAXEXTENTS 2147483645 FREELISTS 1 FREELIST GROUPS 1 )
REFRESH FORCE
ON DEMAND
AS
SELECT * FROM SOURCE.DM_SWJG@SOURCE_DATA DM_ORG
提示创建成功后,但用select * from dm_org却显示没有数据. 只创建了一个空表,为什么??
用如下命令刷新快照,却出现下列错误提示,为什么? 请高手救我,万分感谢!!!
SQL> exec dbms_snapshot.refresh('DM_ORG', 'C');
BEGIN dbms_snapshot.refresh('DM_ORG', 'C'); END;
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_UTILITY
ORA-03212: Temporary Segment cannot be created in locally-managed tablespace
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 653
ORA-06512: at line 1