https://blog.csdn.net/MythColorzh-cnhttps://blog.csdn.net/https://blog.csdn.net/MythColor/article/details/7702802https://blog.csdn.net/MythColor/article/details/7702802MythColorFri, 29 Jun 2012 15:52:48 +0800 @d:\oracle\ora10]]>https://blog.csdn.net/MythColor/article/details/6336125https://blog.csdn.net/MythColor/article/details/6336125MythColorWed, 20 Apr 2011 14:57:00 +0800https://blog.csdn.net/MythColor/article/details/6163526https://blog.csdn.net/MythColor/article/details/6163526MythColorTue, 25 Jan 2011 17:34:00 +0800https://blog.csdn.net/MythColor/article/details/6163457https://blog.csdn.net/MythColor/article/details/6163457MythColorTue, 25 Jan 2011 17:06:00 +0800https://blog.csdn.net/MythColor/article/details/6153185https://blog.csdn.net/MythColor/article/details/6153185MythColorWed, 19 Jan 2011 17:28:00 +0800https://blog.csdn.net/MythColor/article/details/6119504https://blog.csdn.net/MythColor/article/details/6119504MythColorThu, 06 Jan 2011 10:02:00 +0800
In this Document
  Purpose
  Scope and Application
  Export/Import DataPump Parameter TRACE - How to Diagnose Oracle Data Pump
     1. Introduction.
     2. How to create a Data Pump trace file ?  Parameter: TRACE
]]>https://blog.csdn.net/MythColor/article/details/6093683https://blog.csdn.net/MythColor/article/details/6093683MythColorThu, 23 Dec 2010 11:22:00 +0800select tc.column_id, cc.column_name, cc.comments
from dba_col_comments cc, dba_tab_columns tc
where cc.table_name = 'TMPLOGLIST_INFO'
and tc.table_name = 'TMPLOGLIST_INFO'
and cc.column_name = tc.column_name
order by tc.colum]]>https://blog.csdn.net/MythColor/article/details/6091216https://blog.csdn.net/MythColor/article/details/6091216MythColorWed, 22 Dec 2010 11:06:00 +08001. 查看参数，除了用sqlplus的 show parameter 命令之外，还可以查询 v$parameter，一样的。这个视图包括了很多重要参数，例如db_block_size, sga_max_size, shared_pool_size 等。
2. 字符集：
   服务器字符集：nls_database_parameter
   客户端字符集：nls_instance_parameter
   会话字符集：   nls_session_param]]>https://blog.csdn.net/MythColor/article/details/6090145https://blog.csdn.net/MythColor/article/details/6090145MythColorTue, 21 Dec 2010 17:59:00 +0800ddddd]]>https://blog.csdn.net/MythColor/article/details/6086855https://blog.csdn.net/MythColor/article/details/6086855MythColorMon, 20 Dec 2010 14:35:00 +0800不添加 tnsnames.ora 项，直接建 DBLink：
 
CREATE DATABASE LINK "TEST_TRS.WORLD"
 CONNECT TO TRSDATA
 IDENTIFIED BY paic1234
 USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.21.100.90)(PORT = 1595)))
(CON]]>https://blog.csdn.net/MythColor/article/details/6086258https://blog.csdn.net/MythColor/article/details/6086258MythColorMon, 20 Dec 2010 10:06:00 +0800
Export/Import DataPump Parameter ACCESS_METHOD - How to Enforce a Method of Loading and Unloading Data ? [ID 552424.1]  
--------------------------------------------------------------------------------
 
  修改时间 06-APR-2009     类型]]>https://blog.csdn.net/MythColor/article/details/6082883https://blog.csdn.net/MythColor/article/details/6082883MythColorFri, 17 Dec 2010 18:23:00 +0800
在expdp help=y中给的例子是有错误的.下面是该参数的详细用法，找不到原出处
The examples below are based on:
- the demo schema SCOTT that is created with script: $ORACLE_HOME/rdbms/admin/scott.sql
- the directory object my_dir that refers to an existing director]]>https://blog.csdn.net/MythColor/article/details/6081736https://blog.csdn.net/MythColor/article/details/6081736MythColorFri, 17 Dec 2010 11:14:00 +0800https://blog.csdn.net/MythColor/article/details/6060170https://blog.csdn.net/MythColor/article/details/6060170MythColorTue, 07 Dec 2010 11:27:00 +0800https://blog.csdn.net/MythColor/article/details/6052876https://blog.csdn.net/MythColor/article/details/6052876MythColorFri, 03 Dec 2010 14:24:00 +0800https://blog.csdn.net/MythColor/article/details/6041615https://blog.csdn.net/MythColor/article/details/6041615MythColorSun, 28 Nov 2010 22:25:00 +0800zip -r xxx.zip xxx (xxx是文件夹)
linux解压命令大全
解压命令大全
gz
解压1：gunzip FileName.gz
解压2：gzip -d FileName.gz
压缩：gzip FileName
.tar.gz
解压：tar zxvf FileName.tar.gz
压缩：tar zcvf FileName.tar.gz DirName
不写 v 就]]>https://blog.csdn.net/MythColor/article/details/6030990https://blog.csdn.net/MythColor/article/details/6030990MythColorTue, 23 Nov 2010 23:47:00 +0800https://blog.csdn.net/MythColor/article/details/6030078https://blog.csdn.net/MythColor/article/details/6030078MythColorTue, 23 Nov 2010 16:24:00 +0800select uc.constraint_name, uc.owner child_owner, uc.table_name child_table, ucc.column_name child_column
,ucp.owner parent_owner, ucp.table_name parent_table, ucp.column_name parent_column
from dba_constraints uc, dba_cons_columns ucc, dba_]]>https://blog.csdn.net/MythColor/article/details/6020372https://blog.csdn.net/MythColor/article/details/6020372MythColorThu, 18 Nov 2010 23:36:00 +0800
#!/usr/bin/ksh
################################################################################
#
# @PRODUCT@ update scripts for Single or RAC database V1.0 
#
# Upgrade Oracle from 10.1.0.4.0 to 10.1.0.5.0
# Upgra]]>https://blog.csdn.net/MythColor/article/details/6020371https://blog.csdn.net/MythColor/article/details/6020371MythColorThu, 18 Nov 2010 23:35:00 +0800
#!/bin/bash
if [ $1 = "-help" ]; then
more <<@EOF
**********************************************
DESCRIPTION
This script is for NPS 6.1 ED2 Database Backup. 
It generates backup scripts to the specified backup dire]]>