怎么查看oracle中的.dmp内容 oracle dmp怎么查看内容
\u600e\u4e48\u67e5\u770boracle\u4e2d\u7684.dmp\u5185\u5bb9\u9996\u5148\u5bfc\u5165DMP\u6570\u636e\u8868
\u5f00\u59cb---\u8fd0\u884c---cmd(\u6253\u5f00DOS)---imp
system/orcl
fromuser="\u539f\u8868\u540d\u7528\u6237"
touser='\u73b0\u8868\u540d\u7528\u6237'
file="dmp\u6587\u4ef6\u8def\u5f84"
---\u901a\u8fc7\u73b0\u8868\u540d\u7528\u6237\u8eab\u4efd\u8fdb\u5165\u6570\u636e\u5e93---select
*
from
tab;\u53ef\u4ee5\u67e5\u770b\u5230\u6240\u6709\u7684\u8868\u540d---select
*
from
\u8868\u540d;\u53ef\u4ee5\u67e5\u770b\u8868\u4e2d\u6240\u6709\u4fe1\u606f
\u770b\u4e0d\u5230\u5185\u5bb9\uff0c\u4f60\u5bfc\u51fadmp\u65f6\uff0c\u540c\u65f6\u4f1a\u5bfc\u51falog\u6587\u4ef6\uff0c\u4f60\u53bb\u770blog\u6587\u4ef6\u5c31\u53ef\u4ee5\u4e86\u3002
如果是datapump导出的dmp文件，可以使用impdp 的sqlfile选项来查看dmp文件中相关的ddl内容。
SQLFILE
将所有的 SQL DDL 写入指定的文件。
首先导入DMP数据表
开始---运行---cmd(打开DOS)---imp system/orcl fromuser="原表名用户" touser='现表名用户' file="dmp文件路径" ---通过现表名用户身份进入数据库---select * from tab;可以查看到所有的表名---select * from 表名;可以查看表中所有信息
需要用到一些工具：例如toad：database export browser 。
看你要查什么？简单的东西你直接拿文本编辑器编打开就能查询，比如表空间等
不能查询，是导出的数据
绛旓細1.杩欓噷娑夊強鍒颁袱涓郴缁熻鍥鐨搴旂敤dba_tab_cols鍜寀ser_tab_cols;2.dba_tab_cols鍖呭惈鎵鏈夌敤鎴蜂笅琛ㄥ瓧娈典俊鎭紱user_tab_cols鍖呭惈褰撳墠鐢ㄦ埛涓嬭〃淇℃伅锛涗娇鐢╰ba_tab_clos鏌ヨ琛ㄥ瓧娈电被鍨嬮渶瑕佹寚瀹歰wner(鐢ㄦ埛)3.涓婅堪涓や釜琛ㄤ腑锛宼able_name,column_name,data_type灏卞彲浠ユ弧瓒抽渶瑕佹煡璇㈣〃瀛楁绫诲瀷浜嗭紝鍏蜂綋绫诲瀷瀵瑰簲鍏朵粬瀛...
绛旓細select * from test1 where rowid in (select rid from (select rowid rid,row_number()over(partition by dm order by rowid) m from test1) where m =1)鐢ㄨ繖涓鏌ヨtest1涓璬m鍞竴鐨锛屽叾涓璷rder by 鍚庨潰鏄帓搴忕殑瀛楁锛屼繚鐣欑涓鏉★紝
绛旓細PROGRAM 鍒楀皢瀵瑰簲璀︽姤鏃ュ織鏂囦欢涓殑鍚嶇О鏄剧ず杩涚▼ DM (涓轰富杩涚▼)鎴 DW (涓哄伐浣滆繘绋) 濡傛灉涓涓伐浣滆繘绋嬩娇鐢ㄤ簡骞惰鏌ヨ 姣斿璇 SID 鎮ㄥ彲浠ュ湪瑙嗗浘 V$PX_SESSION 涓湅鍒板畠 骞舵妸瀹冩壘鍑烘潵 瀹冨皢涓烘偍鏄剧ず浠 SID 浠ｈ〃鐨勫伐浣滆繘绋嬩腑杩愯鐨勬墍鏈夊苟琛屾煡璇細璇 select sid from v$px_session where qcsid = ; 浠庤鍥 V$SES...
绛旓細棣栧厛浣犺鐨鏁版嵁鍦ㄥ涓嬭繖涓寖鍥村唴锛宻elect glm_dm,count(distinct ks_id)from yourtable group by glm_dm having count(distinct ks_id) > 1;鐒跺悗浣犲彲浠ョ敤姝ゅ瓙鏌ヨ缁撴灉鍘籎OIN銆丒XISTS鎴栬匢N灏卞彲浠ヤ簡銆
绛旓細create table NEED --鐢ㄦ枡闇姹傝〃 (goodsno VARCHAR2(100),prono VARCHAR2(100),needqty NUMBER,needbatch NUMBER );create table REQ --澶囨枡鐢宠琛 (goodsno VARCHAR2(100),prono VARCHAR2(100),reqqty NUMBER );with t as (select a.needbatch,a.prono,a.goodsno,a.needqty...
绛旓細centosdm-0濡備綍杩涘叆锛熸垜鐨勶細centos涓璬m-0杩涘叆鏂规硶鏄細cd/ 鎴鐨鍒嗘瀽锛氬彲浠d/dev/mapper鏌ョ湅dm-0鐨勬槧灏勫叧绯伙紝搴旇鏌ョ湅鍒版槸cl-root鏄犲皠鍒颁簡dm-0銆傛垨鑰呮墽琛宒msetupls鍛戒护鍙奷msetupinfo鍛戒护鏌ョ湅鍒癲m-0璁惧鏄犲皠鍒扮殑LV锛歝l-root 閫氳繃lsblk鍛戒护鍙互鏌ョ湅鍒癱l-root鐨勯昏緫鍒嗗尯锛屽搴旂殑鐩樼鏄/銆傛墍浠m-0瀵瑰簲鐨...
绛旓細鍛戒护灏哾mp鏂囦欢涓垱寤鸿〃鐨璇彞瀵煎叆鍒癷ndexfile鏂囦欢涓紝鏌ョ湅indexfile濡備笅锛歊EM CREATE TABLE "TEST"."DM_KJKM_COPY" ("KJZDMB_DM" VARCHAR2(100)REM ENABLE, "KMID" NUMBER(20, 0), "KMBM" VARCHAR2(100), "KMMC"REM VARCHAR2(500), "KMQC" VARCHAR2(1000), "KMLB_DM" VARCHAR2(...
绛旓細---2.鏌ョ湅dba_free_spacedba_free_space 鏄剧ず鐨勬槸鏈塮ree 绌洪棿鐨則ablespace ,濡傛灉涓涓猼ablespace 鐨刦ree 绌洪棿涓嶈繛缁,閭ｆ瘡娈礷ree绌洪棿閮戒細鍦╠ba_free_space涓瓨鍦ㄤ竴鏉¤褰曘傚鏋滀竴涓猼ablespace 鏈夊ソ鍑犳潯璁板綍,璇存槑琛ㄧ┖闂村瓨鍦ㄧ鐗,褰撻噰鐢ㄥ瓧鍏哥鐞嗙殑琛ㄧ┖闂寸鐗囪秴杩500灏遍渶瑕佸琛ㄧ┖闂磋繘琛岀鐗囨暣鐞嗐俿elect a.tablespace_name...
绛旓細Oracle 寤鸿浣跨敤480300鐨則race鍊,璁剧疆璇ュ煎皢浼歵race Master Control process (MCP) 鍜 theWorker process(es)銆2.1.3 TRACE 鏂囦欢鐨刲og 浣嶇疆2涓猼race 鏂囦欢鍦˙ACKGROUND_DUMP_DEST鐩綍涓:Master Process trace file: _dm_.trc Worker Process trace file: _dw_.trc杩樻湁涓涓湪USER_DUMP_DEST鐩綍:Shadow Process...
绛旓細鐢oracle鐨姝ｅ垯琛ㄨ揪寮忓拰length鍑芥暟瀹炵幇銆傛鍒欒〃杈惧紡regexp_like鐢ㄤ簬鍒ゆ柇15浣嶅叏鏄暟瀛 select th.fw_dh,th.fw_address,th.jz_area,tt.fcz_id,ts.syqr,ts.syqr_dm from t_house th,t_fczs tt,t_syqrinfo ts,rt_fczs rf where tt.fcz_nm=ts.fcz_nm and th.fw_nm=rf.fw_nm and rf....
