<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[congjiu9273的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congjiu9273</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congjiu9273]]></copyright><item><title><![CDATA[Windows远程显示Linux图形界面]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364713</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364713</guid><author>congjiu9273</author><pubDate>Tue, 01 Dec 2015 16:50:59 +0800</pubDate><description><![CDATA[CentOS
Linux下XDM远程桌面配置 


	 


	1、检查与X相关的软件组有哪些 


	#yum gouplist 


	#yum groupinstall
"Desktop...]]></description><category></category></item><item><title><![CDATA[ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364710</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364710</guid><author>congjiu9273</author><pubDate>Thu, 06 Aug 2015 11:14:48 +0800</pubDate><description><![CDATA[出现的错误 


	ORA-00279: change 2492710 generated at
08/06/2015 01:04:59 needed for thread 1 


	ORA-00289:...]]></description><category></category></item><item><title><![CDATA[ORA-12523: TNS: 监听程序无法找到适用于客户机连接的例程]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364773</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364773</guid><author>congjiu9273</author><pubDate>Wed, 15 Jul 2015 11:10:38 +0800</pubDate><description><![CDATA[问题如下:


	SQL&gt;
conn hr/hr@oracle9ivm; --在客户端连接


	ERROR:


	ORA-12523: TNS: 监听程序无法找到适用于客户机连接的例程
...]]></description><category></category></item><item><title><![CDATA[Oracle网络配置]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364711</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364711</guid><author>congjiu9273</author><pubDate>Wed, 15 Jul 2015 11:08:50 +0800</pubDate><description><![CDATA[1：oracle服务器端Listener配置: 


	


	静态注册: 


	listener参数文件示例文件可以在官方文档或者在 


	$ORACLE_HOME/network/admi...]]></description><category></category></item><item><title><![CDATA[ORA-12523: TNS: 监听程序无法找到适用于客户机连接的例程]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364709</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364709</guid><author>congjiu9273</author><pubDate>Mon, 29 Jun 2015 15:11:30 +0800</pubDate><description><![CDATA[问题如下:


	SQL&gt;
conn hr/hr@oracle9ivm; --在客户端连接


	ERROR:


	ORA-12523: TNS: 监听程序无法找到适用于客户机连接的例程
...]]></description><category></category></item><item><title><![CDATA[关于sqlldr官方教材上的几个例子ulcase study1-9]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364775</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364775</guid><author>congjiu9273</author><pubDate>Thu, 04 Jun 2015 08:48:54 +0800</pubDate><description><![CDATA[sqlldr的例子： 


	以下例子取自&amp;ORALCE_HOME/rdbms/demo 


	Case Study 1: 


	LOAD DATA 

...]]></description><category></category></item><item><title><![CDATA[关于DEFAULT STORAGE的问题]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364706</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364706</guid><author>congjiu9273</author><pubDate>Fri, 24 Apr 2015 14:33:28 +0800</pubDate><description><![CDATA[sql&gt;CREATE
TABLESPACE userdata 


	DATAFILE
'/u01/oradata/denver/userdata01.dbf' 


	size 50M EXTENT...]]></description><category></category></item><item><title><![CDATA[为什么ALTER DABASE DATAFILE...RESIZE可以大于MAXBYTES]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364705</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364705</guid><author>congjiu9273</author><pubDate>Tue, 21 Apr 2015 09:31:07 +0800</pubDate><description><![CDATA[表空间创建信息如上,但是用ALTER DATABASE DATAFILE…RESIZE语句的时候是可以大于MAXBYTES的(MAXBYTES是在AUTOEXTENT ON MAXSIZE设置的)，为什么? 


	...]]></description><category></category></item><item><title><![CDATA[关于EXTENT MANAGEMENT LOCAL与DICTIONARY的注意点]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364708</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364708</guid><author>congjiu9273</author><pubDate>Thu, 16 Apr 2015 15:44:36 +0800</pubDate><description><![CDATA[CREATE TABLESPACE
userdata 


	DATAFILE
'/u01/oradata/denver/userdata01.dbf' 


	size 500M EXTENT
MANA...]]></description><category></category></item><item><title><![CDATA[INDEX知识点归纳]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364737</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364737</guid><author>congjiu9273</author><pubDate>Sun, 12 Apr 2015 10:43:10 +0800</pubDate><description><![CDATA[一：查看表： 


	sql&gt;desc user_tables; 


	sql&gt;select
table_name,tablespace_name from user_tables; 

...]]></description><category></category></item><item><title><![CDATA[关于on commit preserve rows与on commit delete rows的测试]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364704</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364704</guid><author>congjiu9273</author><pubDate>Mon, 06 Apr 2015 11:53:11 +0800</pubDate><description><![CDATA[1：先分别建立两张表 


	sql&gt; CREATE GLOBAL
TEMPORARY TABLE tmp_session on commit preserve rows as select * from t...]]></description><category></category></item><item><title><![CDATA[移动Online Redo Log Files的方法]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364707</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364707</guid><author>congjiu9273</author><pubDate>Tue, 31 Mar 2015 09:43:53 +0800</pubDate><description><![CDATA[方法1： 


	1).
Shut down the database. 


	sql&gt;shutdown
immediate; 


	2).
Use an operating system...]]></description><category></category></item><item><title><![CDATA[Maintaining Online Redo Log Files-2]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364703</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364703</guid><author>congjiu9273</author><pubDate>Tue, 31 Mar 2015 09:18:10 +0800</pubDate><description><![CDATA[一：Dropping Online Redo Log File Groups 


	语法： 


	ALTER
DATABASE [database] 


	DROP...]]></description><category></category></item><item><title><![CDATA[V$LOG与V$LOGFILE]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364702</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364702</guid><author>congjiu9273</author><pubDate>Tue, 31 Mar 2015 09:01:09 +0800</pubDate><description><![CDATA[V$LOGFILE描述的是组中成员的信息


	Sql&gt;
select * from v$logfile;



	V$LOG描述的是组的信息


	sql&gt;desc v$log;

...]]></description><category></category></item><item><title><![CDATA[Maintaining Online Redo Log Files-1]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364701</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364701</guid><author>congjiu9273</author><pubDate>Tue, 31 Mar 2015 08:49:17 +0800</pubDate><description><![CDATA[一：Forcing Log Switches and
Checkpoints 


	? Forcing a log switch:  


	ALTER SYSTEM SWITCH LOGFILE; 
...]]></description><category></category></item><item><title><![CDATA[获取表空间的各种信息Obtaining Tablespace Information]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364700</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364700</guid><author>congjiu9273</author><pubDate>Fri, 20 Mar 2015 14:56:04 +0800</pubDate><description><![CDATA[Tablespace information:

	


	–
DBA_TABLESPACES
 


	


	–
V$TABLESPACE 


	


	 Data f...]]></description><category></category></item><item><title><![CDATA[drop tablespace]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364698</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364698</guid><author>congjiu9273</author><pubDate>Fri, 20 Mar 2015 14:33:50 +0800</pubDate><description><![CDATA[? You cannot drop a tablespace if it:
– Is the SYSTEM tablespace
– Has active segments
? INCLUDING CONTENTS ...]]></description><category></category></item><item><title><![CDATA[Methods for Moving Data Files移动数据文件的方法]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364699</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364699</guid><author>congjiu9273</author><pubDate>Fri, 20 Mar 2015 14:05:29 +0800</pubDate><description><![CDATA[Methods for Moving Data Files移动数据（只是更改指针）文件方法一


	?
ALTER TABLESPACE


	– Tablespace must be offline. 
...]]></description><category></category></item><item><title><![CDATA[Managing Tablespaces and Data Files -2]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364696</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364696</guid><author>congjiu9273</author><pubDate>Tue, 17 Mar 2015 19:27:19 +0800</pubDate><description><![CDATA[一：Taking
a Tablespace Offline 


	? Not
available for data access  


	?
Tablespaces that cannot be ta...]]></description><category></category></item><item><title><![CDATA[Managing Tablespaces and Data Files-1]]></title><link>https://blog.youkuaiyun.com/congjiu9273/article/details/100364746</link><guid>https://blog.youkuaiyun.com/congjiu9273/article/details/100364746</guid><author>congjiu9273</author><pubDate>Mon, 16 Mar 2015 09:22:04 +0800</pubDate><description><![CDATA[一：CREATE TABLESPACE 


	CREATE TABLESPACE userdata  


	 DATAFILE '/u01/oradata/userdata01.dbf'
SIZE 5M;...]]></description><category></category></item></channel></rss>