SQL> create table tab_testA(id number(10)) tablespace "USERS";Table createdSQL> create table tab_testB(id number(10)) tablespace "SYSTEM";Table createdSQL> CREATE OR REPLACE TRIGGER tri_testA
2 AFTER INSERT ON tab_testa
3 FOR EACH ROW
4 DECLARE
5 BEGIN
6 INSERT INTO tab_testB(id) VALUES(:new.Id);
7 END tri_testA;
8 /触发器已创建SQL>insert into tab_testA(id)values('111');1 row insertedSQL> select * from tab_testB; ID
-----------
111
2 AFTER INSERT ON tab_testa
3 FOR EACH ROW
4 DECLARE
5 BEGIN
6 INSERT INTO tab_testB(id) VALUES(:new.Id);
7 END tri_testA;
8 /触发器已创建SQL>insert into tab_testA(id)values('111');1 row insertedSQL> select * from tab_testB; ID
-----------
111
你这儿的两个table是新建的,我的table是原来就建好的,我按照你的方法在sqlplus中写触发器,错误提示是找不到第二行的另一个表空间的表,请问有什么办法解决这个问题吗?