摘要：oracle 提供了wrap工具加密代码语法如下：wrap iname=input_file oname=output_fileSELECT ascii('D') FROM dual;SELECT ascii(' ') FROM dual;-- create as a text file c: emp\unwrapped.sql CREATE OR REPLACE FUNCTION unwrapped (namein VARCHAR2)RETURN NUMBER IS c PLS_INTEGER := 0; j PLS_INTEGER; l PLS_INTEGE 阅读全文

摘要：计算schema在原库的空间大小select SEGMENT_TYPE,sum(a.bytes)/1024/1024/1024 from USER_EXTENTS a group by A.SEGMENT_TYPE;建立表空间或扩张新库的表空间CREATE TABLESPACE orcl_index_o1 DATAFILE SIZE 10240M AUTOEXTEND OFF, SIZE 10240M AUTOEXTEND OFFLOGGINGEXTENT MANAGEMENT LOCAL AUTOALLOCATEBLOCKSIZE 8KSEGMENT SPACE MANAGEME... 阅读全文

摘要：先判断flash_recovery_area的利用率，如果超过10%则自动调度rman对日志进行归档AIX Version 6.1,Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bi#!/bin/shecho "---------------begin date-------------"dateexport ORACLE_HOME=/oracle/product/10.2export ORACLE_SID=orclexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBK 阅读全文

摘要：做imp导入的时候报这个错误提示SQL> SQL> show parameter sga NAME TYPE VALUE------------------------------------ ----------- ------------------------------lock_sga boolean FALSEpre_page_sga boolean FALSEsga_max_size ... 阅读全文

摘要：新建jobdbms_job.submit(JOB OUT BINARY_INTEGER,WHAT IN VARCHAR2, NEXT_DATE IN DATE DEFAULT SYSDATE, INTERVAL IN VARCHAR2 DEFAULT 'NULL',NO_PARSE IN BOOLEAN DEFAULT FALSE,INSTANCE IN BINARY_INTEGER DEFAULT 0,FORCE IN BOOLEAN DEFAULT FALSE);例如：declare... 阅读全文