ITPub博客

SQL> host timeSQL> delete from emp where deptno=30;已删除6行。SQL> select empno from emp where deptno=30;未选定行SQL> commit;提交完成。SQL> select empno from emp as timestamp to_timestamp('2008...

注意:此文档是本人写的create or replace package test_pack astype ref_cursor is ref cursor;end;/create or replace procedure get_rest(n in number,rst out test_pack.ref_cursor)as beginopen rst for select ...

这几天的学习内容数据库的数据文件和临时文件最好不要设置成自动扩展.select file_name,autoextensible from dba_data_files or dba_temp_filesalter database datafile ' .....dbf' autoextend off;当临时文件...

要改变表空间倒入数据时,如要把数据改变表空间:1)把要倒入用户的unlimited tablespace权限收回2)设置这个用户在改变后的表空间的quota 数量

注意:此文档是本人结合网上资料整理而成的．ORACLE 10.2.0.1在Red Hat Linux AS4U4 i386上安装文档确认Linux包以下操作都是用root用户执行。确认以下Linux包存在：make-3.79binutils-2.11openmotif-2.2.2-16setarch...

注意:此文档是本人结合网上资料整理而成本次安装需要的软件：1、10201_database_linux_x86_64.cpio.gz2、10201_clusterware_linux_x86_64.cpio.gz3、oracleasm-support-2.0.3-1.x86_64.rpm4、oracleasmlib-2.0.2-1.x...

run { set newname for datafile 7 to 'd:\oradata\test.dbf'';restore datafile 7;switch datafile 7;recover datafile 7;}

此命令可以用于删除过期日志.RMAN>crosscheck archivelog all;RMAN>delete noprompt expired archivelog all;

注意:此文档是本人写的create or replace procedure proc_drop_all_tablesascursor view_cur is select view_name from user_views ;cursor tab_cur is select table_name from user_tables;v_sql varchar2(200);cur...

forall 和bulk collect的用法create table test_table (id int,c2 varchar2(20),c3 varchar2(20),c4 varchar2(20) );declarebegin for i in 1..10000 loop insert into test_table values(i,lpad(i,20,'x'),lpad(i,...

限制用户对自己对象的DDL权限 (触发器实现)create or replace trigger ddl_refuse_trigbefore ddl on schemadeclarev_ipaddress varchar2(20);beginselect sys_context('userenv','ip_address') into v_ipaddress f...

性能优化大致步骤,本人根据学习资料整理而成1) vmstat 3 10查看CPU,MEMORY的使用情况2)top查看哪个进程对CPU,MEMORY使用比较严重3)如果是某一两个比较严重,那跟踪这个这两个系统进程4)如果没有突出使用CPU,MEMORY的...

注意:此文档是本人由学习资料整理而成comment on table test is 'this is a test table';comment on column p.id is 'This is a id';select * from user_tab_comments;select * from user_col_comments where commen...

关于表和索引的分析命令analyze table tn compute statisticsanalyze table tn compute statistics for all indexesanalyze table tn compute statistics for all indexed columns;analyze table tn delete statisti...

select dbms_flashback.get_system_change_number,current_scn from v$database;

select ss.sid,se.command,ss.value cpu ,se.machine,se.username,se.program from v$session se,v$sesstat ss where ss.statistic# in (    select statistic#  from v$statname where name='CPU ...

注意:此文档是本人写的--级联删除表中的记录create or replace procedure proc_delete_data(p_tname varchar2)as--定义一个游标,此游标返回指定表的子表cursor cur_constraint is select b.table_name from user_con...