创建索引 有2个用户A、B,现在在用户A下创建一个表: create table test as select * from B.test 如何使A用户下的test表也拥有B用户下的索引 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 create table test as select * from B.test这样只能是把b表中的数据复制过来 连b表的主键都复制不了 你还是给a手动创建索引吧 使用联机重定义的功能SQL> create table r2mp.test(id number primary key);Table createdSQL> select index_name from all_indexes where table_name ='TEST' and owner='R2MP';INDEX_NAME------------------------------SYS_C00182166SQL> create table R2MP.t_test as select * from r2mp.test;Table createdSQL> select index_name from all_indexes where table_name ='T_TEST'and owner='R2MP';INDEX_NAME------------------------------SQL> execute dbms_redefinition.can_redef_table('R2MP','TEST');PL/SQL procedure successfully completedSQL> select * from v$version;BANNER----------------------------------------------------------------Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit ProductionPL/SQL Release 9.2.0.1.0 - ProductionCORE 9.2.0.1.0 ProductionTNS for HPUX: Version 9.2.0.1.0 - ProductionNLSRTL Version 9.2.0.1.0 - ProductionSQL> execute dbms_redefinition.start_redef_table('R2MP','TEST','T_TEST');PL/SQL procedure successfully completedSQL> execute dbms_redefinition.finish_redef_table('R2MP','TEST','T_TEST');PL/SQL procedure successfully completedSQL> select index_name from all_indexes where table_name ='T_TEST'and owner='R2MP';INDEX_NAME------------------------------SYS_C00182166SQL> oracle 并行问题 用SQLPLUS查询中文是乱码!求解! 什么情况下的视图更新数据,不要使用触发器 ORACLE一个存储过程调用另一个存储过程 sql查询 如何远程调用另一个数据库的存储过程 各位帮忙看一下。我的存储过程总是编译不过去,实在找不出哪错了。 对象打叉,但是状态为valid 求SQL语句 在oracle的select语句中能不能用判断语句如:select if .. then ... else ...end if from dual 问个数据库设计的问题 如果把ORACLE和SQL SERVER定时同步起来
这样只能是把b表中的数据复制过来 连b表的主键都复制不了
你还是给a手动创建索引吧
------------------------------
SYS_C00182166SQL> create table R2MP.t_test as select * from r2mp.test;Table createdSQL> select index_name from all_indexes where table_name ='T_TEST'and owner='R2MP';INDEX_NAME
------------------------------SQL> execute dbms_redefinition.can_redef_table('R2MP','TEST');PL/SQL procedure successfully completedSQL> select * from v$version;BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 ProductionTNS for HPUX: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - ProductionSQL> execute dbms_redefinition.start_redef_table('R2MP','TEST','T_TEST');PL/SQL procedure successfully completedSQL> execute dbms_redefinition.finish_redef_table('R2MP','TEST','T_TEST');PL/SQL procedure successfully completedSQL> select index_name from all_indexes where table_name ='T_TEST'and owner='R2MP';INDEX_NAME
------------------------------
SYS_C00182166SQL>