chichuduxing的博客

启停Oracle服务登录Oracle服务所在的服务器[root@localhost ~]# su  oracle[oracle@localhost ~]$ sqlplus /nologSQL> connect /as sysdbaSQL> shutdown immediate（关闭数据库实例）SQL> startup (起动数据库实例，一般不需要加参数，只要设置好环境变

恢复被delete的数据假设表名称为:table_delete 查看系统当前时间--获得系统当前时间select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')from dual;查看删除数据之前的某个时间点该表里面的数据select * from table_dele

单字段去重查看重复数据select * from testrepeat t where t.id in (select id from testrepeat group by id having count(id) > 1);删除重复记录，保留rowid最小的行delete from testrepeat t where t.id in (select id from testrep

1 建分区表-- Create tablecreate table PARTITION_TABLE( field1 INTEGER, field2 VARCHAR2(32), field3 INTEGER,)partition by range(field3)interval (86400)(partition p1 values less than (14

导出exp1 将数据库完全导出,用户名system 密码manager 导出到D:\daochu.dmp中exp system/manager@hostname:1521/ora11g file=exp_export.dmp full=y log=exp_export.log2 将数据库中system用户与sys用户的表导出exp system/manager@hostna

1 创建临时表空间CREATE TEMPORARY TABLESPACE user_tmpTEMPFILE '/oradataa/user_tmp.dbf 'SIZE 32MAUTOEXTEND ONNEXT 32M MAXSIZE 2048MEXTENT MANAGEMENT LOCAL;2 创建用户表空间CREATE TABLESPACE xxuserLOGGING

#!/bin/bash###################@author: chichuduxing#@date: 20160913###################加载环境变量(需要加载oracle的环境变量,根据安装情况自己调整)if [ -f /etc/profile.d/oraenv.sh ];then source /etc/profile.d/or