update

baoguoding · baoguoding · commit 5ae6030910c4 · 2024-01-11T10:56:01.000+08:00
diff --git a/_posts/2023-12-18-633-db.md b/_posts/2023-12-18-633-db.md
@@ -1,10 +1,12 @@
 ---
 layout: post
-title: oracle-ORA-01653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
+title: oracle-ORA-01653
 pid: 633
 tags: [db]
 ---
 
+
+```sql
 SELECT a.tablespace_name "&#34920;&#31354;&#38388;&#21517;",
 a.bytes / 1024 / 1024 "&#34920;&#31354;&#38388;&#22823;&#23567;(M)",
 (a.bytes - b.bytes) / 1024 / 1024 "&#24050;&#20351;&#29992;&#31354;&#38388;(M)",
@@ -19,17 +21,13 @@ GROUP BY tablespace_name) b
 WHERE a.tablespace_name = b.tablespace_name
 ORDER BY ((a.bytes - b.bytes) / a.bytes) DESC
 
-
-
 alter tablespace  SYSAUX  add datafile  'SYSAUX02.dbf'  size 5G ;
 alter tablespace  SYSTEM  add datafile  'SYSTEM02.dbf'  size 10G ;
 
 
-
-
 select distinct dfs.tablespace_name, df.name  from dba_free_space dfs left join v$datafile df on dfs.file_id = df.FILE# order by dfs.tablespace_name;
 
-
+```
 
 
 
diff --git a/contact.html b/contact.html
@@ -31,8 +31,8 @@ <h3>Paul Ding</h3>
 
 <p>or follow</p>
 
-<blockquote><p><i class="fa fa-twitter"></i> <a href="https://twitter.com/baoguoding">@Paul Ding</a></p>
+<blockquote><p><i class="fa fa-twitter"></i> <a href="https://twitter.com/baoguoding">@baoguoding</a></p>
 
-<p><i class="fa fa-weibo"></i> <a href="http://weibo.com/baoguoding">@&#19969;&#24069;&#29240;&#29240;</a></p></blockquote>
+<p><i class="fa fa-weibo"></i> <a href="http://weibo.com/baoguoding">@baoguoding</a></p></blockquote>
 
 <p>to reach me</p>
