1.导出数据 exp username/pwd@sid file=c:/temp.dmp tables=table_name;
2.导入数据 imp username/pwd@sid file=c:/temp.dmp tables=table_name;
3.重命名表
alter table old_table_name rename to new_table_name;
4.select ldap('a', 3, 'b') from dual;
5.table to table
CREATE OR REPLACE PROCEDURE P_TEMP_INSERTLOGDATA
AS
CURSOR c_UserActiveLog IS
SELECT * FROM T_VMS_ACTIVE_USEROPERATELOG;
v_UserActiveLog c_UserActiveLog%ROWTYPE;
BEGIN
FOR v_UserActiveLog IN c_UserActiveLog LOOP
INSERT INTO T_VMS_ACTIVE_USEROPTTEMP
(SEQUENCEID, OP_TIME, LOG_LEVEL, MODULE_NAME, USERNO, ACTIVITY, DESCRIPTION, OP_RESULT, PARTCOL_DATE)
VALUES
(v_UserActiveLog.SEQUENCEID,
v_UserActiveLog.OP_TIME,
v_UserActiveLog.LOG_LEVEL,
v_UserActiveLog.MODULE_NAME,
v_UserActiveLog.USERNO,
v_UserActiveLog.ACTIVITY,
v_UserActiveLog.DESCRIPTION,
v_UserActiveLog.OP_RESULT,
SUBSTR(v_UserActiveLog.USERNO, -3, 2));
END LOOP;
COMMIT;
END P_TEMP_INSERTLOGDATA;