专注于数据库技术研究和实践，目前就职于互联网金融企业，提供Oracle数据库技术支持和维护。 联系电话：18616803656
发布时间：2019-01-15 17:35:17
CREATE OR REPLACE PACKAGE TPS_CASH_DB_MNTASPROCEDURE DB_STATS(V_DEGREE IN VARCHAR2 DEFAULT 8);PROCEDURE REBUILD_INDEX(V_ONLINE IN VARCHAR2 DEFAULT NULL);PROCEDURE REBUILD_INDEX(V_TAB_NAME IN VARCHAR2, .........【阅读全文】
发布时间：2018-06-13 10:27:48
有时候需要禁用表之间的外键约束，然后重建表或者导入数据，下面share一下两个procedure用来做外键禁用。-- 禁用schema下面所有外键create or replace procedure p_fk_status( an_status number)as cur_handle number;cur_result number;s_sql varchar2(4000);s_error varchar2(4000);s_ip varchar2(20);/*C.........【阅读全文】
发布时间：2017-04-13 11:58:53
The parallel_clause lets you parallelize creation of the table and set the default degree of parallelism for queries and the DML INSERT, UPDATE, DELETE,and MERGE after table creation.
NOPARALLEL: Specify NOPARALLEL for serial execution. This is the default，即并行度为1.
PARALLEL: Specify PARALLEL if you want Oracle to select a degree of parallelism equal to the number of CPUs available on all participating instances times the value of the PARALLEL_THREADS_PER_CPU initialization parameter.......【阅读全文】
