<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[小旭的技术博客]]></title><description><![CDATA[博观而约取, 厚积而薄发.]]></description><link>https://blog.csdn.net/xiaoxu0123</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; xiaoxu0123]]></copyright><item><title><![CDATA[Oracle 删除表里重复的数据]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/139325228</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/139325228</guid><author>xiaoxu0123</author><pubDate>Thu, 30 May 2024 15:15:11 +0800</pubDate><description><![CDATA[oracle plsql删除表中重复的数据]]></description><category></category></item><item><title><![CDATA[imp导入 替换表空间]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/131604811</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/131604811</guid><author>xiaoxu0123</author><pubDate>Fri, 07 Jul 2023 21:34:42 +0800</pubDate><description><![CDATA[imp导入时,表空间和exp导出时不同的,需要替换]]></description><category></category></item><item><title><![CDATA[Linux批量文件中查找某字符串，以及替换某字符串]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/128063007</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/128063007</guid><author>xiaoxu0123</author><pubDate>Sun, 27 Nov 2022 12:53:33 +0800</pubDate><description><![CDATA[批量文件中查找某字符串，以及替换某字符串 find  xargs  sed ]]></description><category></category></item><item><title><![CDATA[ORACLE 11g ACL 权限处理]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/124840423</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/124840423</guid><author>xiaoxu0123</author><pubDate>Wed, 18 May 2022 13:35:42 +0800</pubDate><description><![CDATA[ora-24247网络访问被网络访问控制列表(ACL)拒绝
ora-06512:在“SYS.UTL_INADDR",line.....]]></description><category></category></item><item><title><![CDATA[Dos 批量复制旧txt为新文件，并替换文件中的字符串]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/122109771</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/122109771</guid><author>xiaoxu0123</author><pubDate>Thu, 23 Dec 2021 15:58:41 +0800</pubDate><description><![CDATA[rem 需要输入参数为当天日期YYYYMMDD
@echo off
mkdir E:\file\input\%1\
cd E:\file\input\%1\
e:

echo ***** 复制老文件到 当天新创建目录下
copy E:\file\input\98_test\*.txt E:\file\input\%1\
set strDate=%1

rem 修改文件名中的日期: OFD_98_001_20201014_C1.txt &amp;&amp; OFX_98_001_20201014.TXT
..]]></description><category></category></item><item><title><![CDATA[Oracle导出用户授权]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/113781722</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/113781722</guid><author>xiaoxu0123</author><pubDate>Wed, 10 Feb 2021 13:47:24 +0800</pubDate><description><![CDATA[select grantee,owner table_owner,table_name,privilege from dba_tab_privs where grantee&lt;&gt; owner
and grantee not in ('SYS','PUBLIC','SYSTEM','WMSYS') and owner='用户名'
order by 1,3,4
]]></description><category></category></item><item><title><![CDATA[oracle删除和拆分表分区]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/111874592</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/111874592</guid><author>xiaoxu0123</author><pubDate>Mon, 28 Dec 2020 20:47:51 +0800</pubDate><description><![CDATA[--删除历史分区

alter table tincome drop partition P_HIS UPDATE GLOBAL INDEXES; 

--拆分当前分区

alter table tincome split partition P_CUR at('20200930') into (partition P_HIS,partition P_CUR) update global indexes;


-- 下面这条”新建表分区“会报错

ORA-14074: partition bound mu.]]></description><category></category></item><item><title><![CDATA[oracle 查看锁表sql语句（导致锁表的sql）、解锁语句]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/108125227</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/108125227</guid><author>xiaoxu0123</author><pubDate>Thu, 20 Aug 2020 15:45:21 +0800</pubDate><description><![CDATA[--查看锁表会话SQL语句1：

--被锁对象表、数据库对象表、数据session表关联来获取被锁对象对应的是那个session；
select sess.sid,
sess.serial#,
lo.oracle_username,
lo.os_user_name,
ao.object_name,
lo.locked_mode
from v$locked_object lo,
dba_objects ao,
v$session sess
where ao.object_id = lo.ob...]]></description><category></category></item><item><title><![CDATA[数据泵使用：expdb和impdb]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/107636838</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/107636838</guid><author>xiaoxu0123</author><pubDate>Tue, 28 Jul 2020 15:36:13 +0800</pubDate><description><![CDATA[expdb导出数据库用户的数据，可以限制含（include), 或排除(exclude)某些表名，或按sql查询表名, 使用时需要用配置文件，如下：

--假设oracle用户为wisg,需排除一些_HIS结尾的表. %U为并行度的多个文件编号

[oracle@redhat-inux1 ~]$ more expdb_cfg_wisg.par
directory=wisgdump
dumpfile=wisg_expdb20200727_%U.dmp
SCHEMAS=wisg
logfile=wisg_ex.]]></description><category></category></item><item><title><![CDATA[Oracle学习目录]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/106739476</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/106739476</guid><author>xiaoxu0123</author><pubDate>Sat, 13 Jun 2020 22:40:56 +0800</pubDate><description><![CDATA[收缩表段(shrink space)

https://blog.csdn.net/leshami/article/details/6630673
]]></description><category></category></item><item><title><![CDATA[收缩表段(shrink space)]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/106739341</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/106739341</guid><author>xiaoxu0123</author><pubDate>Sat, 13 Jun 2020 22:33:22 +0800</pubDate><description><![CDATA[收缩表段(shrink space)

Leshami 2011-07-25 09:22:26 19428 收藏 4
分类专栏： -----Oracle性能优化 文章标签： tableoraclesql数据库loggingexception
版权
--====================
-- 收缩表段(shrink space)
--====================

一、表的增长方式
当表被创建后，随着记录的不断插入，组成表的区间会被填满，如果启用了自动扩展，则当区间填满后，会分...]]></description><category></category></item><item><title><![CDATA[查询ORACLE  DDL语句（创建表，创建索引)]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/106080667</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/106080667</guid><author>xiaoxu0123</author><pubDate>Tue, 12 May 2020 17:17:00 +0800</pubDate><description><![CDATA[SELECT o.OBJECT_NAME, DBMS_METADATA.GET_DDL(O.OBJECT_TYPE, O.object_name, O.OWNER)
 FROM DBA_OBJECTS O where O.OBJECT_TYPE IN( 'INDEX' ,'TABLE') and O.OWNER = '某用户'
]]></description><category></category></item><item><title><![CDATA[Oracle表空间大小查询和清理]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/106080541</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/106080541</guid><author>xiaoxu0123</author><pubDate>Tue, 12 May 2020 17:14:27 +0800</pubDate><description><![CDATA[-- 统计表空间
SELECT TABLESPACE_NAME 表空间,
   TO_CHAR(ROUND(BYTES / 1024, 2), '99990.00') || '' 实有,
   TO_CHAR(ROUND(FREE / 1024, 2), '99990.00') || 'G' 现有,
   TO_CHAR(ROUND((BYTES - FREE) / 1024, 2), '99990.00') || 'G' 使用,
   TO_CHAR(ROUND(1000...]]></description><category></category></item><item><title><![CDATA[Oracle两表关联更新]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/105385593</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/105385593</guid><author>xiaoxu0123</author><pubDate>Wed, 08 Apr 2020 13:17:05 +0800</pubDate><description><![CDATA[方法1： 
UPDATE T1 
SET T1.FMONEY = (select T2.FMONEY from t2 where T2.FNAME = T1.FNAME)
WHERE EXISTS(SELECT 1 FROM T2 WHERE T2.FNAME = T1.FNAME);



方法2：内联视图更新


UPDATE (
select t1.fmoney  fmoney1,t2....]]></description><category></category></item><item><title><![CDATA[Oracle 归档日志管理]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/105114333</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/105114333</guid><author>xiaoxu0123</author><pubDate>Thu, 26 Mar 2020 11:26:32 +0800</pubDate><description><![CDATA[关闭归档日志, 开启归档日志

&gt; su - oracle

&gt; sqlplus / as sysdba
 shutdown immediate;
  startup mount;
 --关闭归档日志 alter database noarchivelog;  —开启归档日志 alter database archivelog;
  alter ...]]></description><category></category></item><item><title><![CDATA[linux tail 命令详解]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/53905838</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/53905838</guid><author>xiaoxu0123</author><pubDate>Wed, 28 Dec 2016 09:51:04 +0800</pubDate><description><![CDATA[linux tail 命令详解




原文链接
linux ---tail命令 


linux中tail命令---用于查看文件内容 

最基本的是cat、more和less。 
1. 如果你只想看文件的前5行，可以使用head命令，如： 
head -5 /etc/passwd 
2. 如果你想查看文件的后10行，可以使用tail命令，如： 
tail -10 /]]></description><category></category></item><item><title><![CDATA[bat批处理（二）：%0 %1——给批处理脚本传递参数]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/53905820</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/53905820</guid><author>xiaoxu0123</author><pubDate>Wed, 28 Dec 2016 09:49:30 +0800</pubDate><description><![CDATA[bat批处理（二）：%0 %1——给批处理脚本传递参数 

标签： 
bat传入参数形参0-9

2016-10-11 15:01 
280人阅读 评论(0)
收藏
举报


本文章已收录于：





分类： 
Dos/bat（4） 



作者同类文章X





前言


初次接触批处理脚本觉得有点意思，所以决定写一个小功能试验一]]></description><category></category></item><item><title><![CDATA[oracle清理oracle空间]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/48343519</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/48343519</guid><author>xiaoxu0123</author><pubDate>Thu, 10 Sep 2015 14:57:39 +0800</pubDate><description><![CDATA[--统计各个用户占用的空间
select owner, round(sum(bytes)/1024/1024,0) "used MB" from dba_segments group by owner order by 2;
--统计某个用户占用各个表空间的情况
select round(sum(bytes)/1024/1024,0) "used MB", TABLESPACE_NAME f]]></description><category></category></item><item><title><![CDATA[ORACLE 收缩表空间的数据文件]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/48343401</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/48343401</guid><author>xiaoxu0123</author><pubDate>Thu, 10 Sep 2015 14:51:59 +0800</pubDate><description><![CDATA[http://blog.chinaunix.net/uid-15108676-id-2749522.html
 
在实际的应用中经常会遇到TRUNCATE或者DELETE表中的数据后发现表空间并没有将空间进行释放，磁盘空间被告占用感觉空间白白被浪费掉了。
提供一个回收表空间的简单方法供参考：
通过下面的SQL语句查看表空间总大小及实用大小，然后拼出来一个SQL语句将表空间的数据文件重新设定]]></description><category></category></item><item><title><![CDATA[[Oracle] v$sqltext, v$sqlare 和v$sql]]></title><link>https://blog.csdn.net/xiaoxu0123/article/details/38846807</link><guid>https://blog.csdn.net/xiaoxu0123/article/details/38846807</guid><author>xiaoxu0123</author><pubDate>Tue, 26 Aug 2014 14:11:53 +0800</pubDate><description><![CDATA[v$sqltext
存储的是完整的SQL,SQL被分割

SQL> desc v$sqltext
Name                                      Null? Type
----------------------------------------- -------- ----------------------------
ADDRESS     ]]></description><category></category></item></channel></rss>