<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[biubiubiupa_的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/biubiubiupa_</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; biubiubiupa_]]></copyright><item><title><![CDATA[备份数据库表]]></title><link>https://blog.youkuaiyun.com/biubiubiupa_/article/details/129439098</link><guid>https://blog.youkuaiyun.com/biubiubiupa_/article/details/129439098</guid><author>biubiubiupa_</author><pubDate>Fri, 10 Mar 2023 11:18:21 +0800</pubDate><description><![CDATA[CREATE TABLE 备份表名 as SELECT * FROM 旧表名。INSERT INTO 旧表名 SELECT * FROM 备份表名。1.创建一个备份表并包含原始数据。]]></description><category></category></item><item><title><![CDATA[Oracle死锁解决方法]]></title><link>https://blog.youkuaiyun.com/biubiubiupa_/article/details/125142494</link><guid>https://blog.youkuaiyun.com/biubiubiupa_/article/details/125142494</guid><author>biubiubiupa_</author><pubDate>Mon, 06 Jun 2022 10:47:50 +0800</pubDate><description><![CDATA[Oracle死锁解决方法]]></description><category></category></item><item><title><![CDATA[视图的创建及创建新用户]]></title><link>https://blog.youkuaiyun.com/biubiubiupa_/article/details/120997771</link><guid>https://blog.youkuaiyun.com/biubiubiupa_/article/details/120997771</guid><author>biubiubiupa_</author><pubDate>Wed, 27 Oct 2021 17:29:13 +0800</pubDate><description><![CDATA[CREATE VIEW 视图名 AS
SELECT *
FROM Emp(表名)
WHERE name in ('张三','李四','王五')
]]></description><category></category></item><item><title><![CDATA[Linux基础命令]]></title><link>https://blog.youkuaiyun.com/biubiubiupa_/article/details/116121730</link><guid>https://blog.youkuaiyun.com/biubiubiupa_/article/details/116121730</guid><author>biubiubiupa_</author><pubDate>Sun, 25 Apr 2021 11:41:02 +0800</pubDate><description><![CDATA[重启：reboot

查询ip：ifconfig

切换目录：cd /...。cd ~或者cd :回到自己家目录。cd .. 回到当前目录的上一级目录。前面的/是根目录。如果在home文件里，想直接进入下级wh文件。可以直接输入指令 cd wh/(这就是相对地址)。不然就只能用绝对地址，慢慢往下进

显示当前目录：ll

ls指令（查看目录所有信息）：ls 。可在ls后面加上-a或者-l。-a表示：显示当前目录所有文件和目录，包括隐藏的。-l表示：以列的方式显示信息。（ls -al就表示以列的方式显示当前目]]></description><category></category></item><item><title><![CDATA[表空间使用情况及扩容]]></title><link>https://blog.youkuaiyun.com/biubiubiupa_/article/details/116121285</link><guid>https://blog.youkuaiyun.com/biubiubiupa_/article/details/116121285</guid><author>biubiubiupa_</author><pubDate>Sun, 25 Apr 2021 11:33:19 +0800</pubDate><description><![CDATA[--查询表空间使用情况

SELECT a.tablespace_name "表空间名",
   total / (1024 * 1024 * 1024) "表空间大小(G)",
   free / (1024 * 1024 * 1024) "表空间剩余大小(G)",
   (total - free) / (1024 * 1024 * 1024) "表空间使用大小(G)",
   round((total - free) / total, 4) * 100 "使用率 %"
...]]></description><category></category></item></channel></rss>