<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[qq_40195263的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/qq_40195263</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; qq_40195263]]></copyright><item><title><![CDATA[Oracle字符集的查看与修改]]></title><link>https://blog.youkuaiyun.com/qq_40195263/article/details/110052797</link><guid>https://blog.youkuaiyun.com/qq_40195263/article/details/110052797</guid><author>qq_40195263</author><pubDate>Tue, 24 Nov 2020 11:05:56 +0800</pubDate><description><![CDATA[查看


select * from nls_database_parameters where parameter ='NLS_CHARACTERSET';

修改


sqlplus / as sysdba

shutdown immediate;

startup mount;

alter system enable restricted session;

alter system set job_queue_processes=0;

alter database open;

alter da]]></description><category></category></item><item><title><![CDATA[Oracle删除物化视图]]></title><link>https://blog.youkuaiyun.com/qq_40195263/article/details/110049339</link><guid>https://blog.youkuaiyun.com/qq_40195263/article/details/110049339</guid><author>qq_40195263</author><pubDate>Tue, 24 Nov 2020 10:53:01 +0800</pubDate><description><![CDATA[1、查询表空间A的所有物化视图：


SELECT TABLE_NAME,TABLESPACE_NAME FROM DBA_TABLES WHERE TABLESPACE_NAME='A' AND TABLESPACE_NAME IN (SELECT MVIEW_NAME FROM DBA_MVIEWS);

2、删除物化视图（假定查询结果为：VIEW_A01）：


DROP MATERIALIZED VIEW VIEW_A;


...]]></description><category></category></item><item><title><![CDATA[Linux下JDK的安装与配置]]></title><link>https://blog.youkuaiyun.com/qq_40195263/article/details/110042613</link><guid>https://blog.youkuaiyun.com/qq_40195263/article/details/110042613</guid><author>qq_40195263</author><pubDate>Tue, 24 Nov 2020 10:32:00 +0800</pubDate><description><![CDATA[ROOT下安装

1、在根目录下建一个空文件夹，名字随意，这里就叫jdk：


mkdir jdk

2、上传jdk安装包至改目录下，解压：


tar -xvf jdk-8u131-linux-x64.tar.gz

3、修改文件名（这一步可省略）：


mv jdk1.8.0_131 jdk8

4、编辑 /etc/profile 文件，在末尾添加以下内容并保存：


export JAVA_HOME=/jdk/jdk8

export CLASSPATH=$:CLASSPATH:$JAVA_HOME/]]></description><category></category></item><item><title><![CDATA[记录一次还原数据库的报错]]></title><link>https://blog.youkuaiyun.com/qq_40195263/article/details/109624613</link><guid>https://blog.youkuaiyun.com/qq_40195263/article/details/109624613</guid><author>qq_40195263</author><pubDate>Wed, 11 Nov 2020 16:02:25 +0800</pubDate><description><![CDATA[报错信息：

ORA-39006: internal error
	ORA-39213: Metadata processing is not available
	ORA-39006：内部错误
	ORA-39213：元数据处理不可用
报错原因：

Cause: The Data Pump could not use the Metadata API. Typically, this is caused by the XSL stylesheets not being set up properly.
	A]]></description><category></category></item><item><title><![CDATA[Oralce数据库的导入导出]]></title><link>https://blog.youkuaiyun.com/qq_40195263/article/details/105272608</link><guid>https://blog.youkuaiyun.com/qq_40195263/article/details/105272608</guid><author>qq_40195263</author><pubDate>Thu, 02 Apr 2020 17:45:20 +0800</pubDate><description><![CDATA[注意！！！

  Oracle 11g 版本的数据库安装时企业版和标准版有天差之别，本人从公司的11g企业版导出的库在本地11g 标准版的数据库还原，错误层出不穷。

  为了更好的导入导出数据库，建议导入导出的数据库版本尽量一致！！！





例如：将A数据库服务器（linux系统）的TEST 数据库 导出后导入到本地的数据库服务器B中



1、首先登陆A数据库（登陆B亦如此）...]]></description><category></category></item></channel></rss>