ORACLE關於如何是exp匯出還是expdp並檢視資訊
這個例子來自網路
DECLARE
t1 ku$_dumpfile_info;
v1 NUMBER;
item_meaning VARCHAR2 (40);
v_file_type VARCHAR2 (20);
BEGIN
DBMS_DATAPUMP.GET_DUMPFILE_INFO ('test.dmp',
'DATA_PUMP_DIR',
t1,
v1);
IF v1 = 1
THEN
v_file_type := 'DATA_PUMP_FILE';
ELSE
v_file_type := 'ORIGINAL_EXPORT_FILE';
END IF;
DBMS_OUTPUT.PUT_LINE ('filetype: ' || v_file_type);
FOR i IN 1 .. t1.COUNT
LOOP
item_meaning :=
CASE t1 (i).item_code
WHEN 1 THEN 'FILE_VERSION'
WHEN 2 THEN 'MASTER_PRESENT'
WHEN 3 THEN 'GUID'
WHEN 4 THEN 'FILE_NUMBER'
WHEN 5 THEN 'CHARSET_ID'
WHEN 6 THEN 'CREATION_DATE'
WHEN 7 THEN 'FLAGS'
WHEN 8 THEN 'JOB_NAME'
WHEN 9 THEN 'PLATFORM'
WHEN 10 THEN 'INSTANCE'
WHEN 11 THEN 'LANGUAGE'
WHEN 12 THEN 'BLOCKSIZE'
WHEN 13 THEN 'DIRPATH'
WHEN 14 THEN 'METADATA_COMPRESSED'
WHEN 15 THEN 'DB_VERSION'
WHEN 16 THEN 'MASTER_PIECE_COUNT'
WHEN 17 THEN 'MASTER_PIECE_NUMBER'
WHEN 18 THEN 'DATA_COMPRESSED'
WHEN 19 THEN 'METADATA_ENCRYPTED'
WHEN 20 THEN 'DATA_ENCRYPTED'
ELSE 'UNKNOWN'
END;
DBMS_OUTPUT.PUT_LINE (
RPAD (item_meaning || ':', 30, ' ') || LPAD (t1 (i).VALUE, 30, ' '));
END LOOP;
END;
/
下面是輸出結果:
filetype: DATA_PUMP_FILE
FILE_VERSION: 3.1
DB_VERSION: 11.02.00.00.00
MASTER_PRESENT: 1
FLAGS: 2
GUID: 72C6699324794336B115F01D234763
CHARSET_ID: 852
FILE_NUMBER: 1
JOB_NAME: "SYSTEM"."SYS_EXPORT_TABLE_01"
PLATFORM: IBMPC/WIN_NT-8.1.0
INSTANCE: ii1
LANGUAGE: ZHS16GBK
CREATION_DATE: Mon Nov 22 16:41:26 2010
BLOCKSIZE: 4096
METADATA_COMPRESSED: 1
DATA_COMPRESSED: 0
METADATA_ENCRYPTED: 0
DATA_ENCRYPTED: 0
UNKNOWN: 0
UNKNOWN: 2
MASTER_PIECE_COUNT: 1
MASTER_PIECE_NUMBER: 1
PL/SQL 過程已成功完成。
但是這個方法受限於一個活躍的ORACLE例項,如果沒有ORACLE例項我只有一個檔案怎麼看呢?
當然可以用二進位制工具開啟檔案檢視。
但是如果檔案很大直接開啟顯然不顯示,那麼我寫了一個小程式非常簡單,用GCC編譯一下隨便就可以了
就是取前1000個位元組。
點選(此處)摺疊或開啟
-
/*************************************************************************
-
> File Name: test.c
-
> Author: gaopeng
-
> Mail: gaopp_200217@163.com
-
> Created Time: Tue 04 Oct 2016 02:06:17 PM CST
-
************************************************************************/
-
-
#include<stdio.h>
-
#include <stdlib.h>
-
-
-
int main(int argc,char* argv[])
-
{
-
FILE *fd1;
-
FILE *fd2;
-
-
char test[1000];
-
printf("info:./truc file1 file2\n");
-
-
if (argc<3)
-
{
-
printf("Usage:./truc file1 file2\n");
-
exit(3);
-
}
-
-
if (!(fd1=fopen(argv[1],"r") ) )
-
{
-
printf("open exp file failed!\n");
-
exit(1);
-
}
-
-
if(!(fd2=fopen(argv[2],"w")))
-
{
-
printf("open write file failed!\n");
-
exit(2);
-
}
-
-
fread(test,1000,1,fd1);
-
fwrite(test,1000,1,fd2);
-
printf("endl\n");
- fclose(fd1);
-
fclose(fd2);
-
- }
我們來用一下:
gaopeng@bogon:~/testoo$ ./truc userlogin.dmp test.dmp
info:./truc file1 file2
endl
我們檢視一下test.dmp檔案
hexdump -Cv test.dmp
擷取有用的資訊
點選(此處)摺疊或開啟
-
00000000 03 01 f0 ec 55 58 00 67 80 bc 00 01 5c c4 01 3a |....UX.g....\..:|
-
00000010 c9 a8 a6 56 7c 10 14 e0 53 14 ef a8 c0 5b a5 00 |...V|...S....[..|
-
00000020 00 00 01 00 00 10 00 03 54 07 e0 08 18 0b 0d 13 |........T.......|
-
00000030 00 00 00 02 02 00 00 00 00 07 00 00 00 00 00 01 |................|
-
00000040 65 38 00 22 55 47 4c 53 48 22 2e 22 53 59 53 5f |e8."UGLSH"."SYS_|
-
00000050 45 58 50 4f 52 54 5f 54 41 42 4c 45 5f 30 31 22 |EXPORT_TABLE_01"|
-
00000060 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
00000070 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
00000080 00 00 00 00 00 78 38 36 5f 36 34 2f 4c 69 6e 75 |.....x86_64/Linu|
-
00000090 78 20 32 2e 34 2e 78 78 00 00 00 00 00 00 00 00 |x 2.4.xx........|
-
000000a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
000000b0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
000000c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
000000d0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
000000e0 00 00 00 00 00 00 00 00 00 00 6c 69 65 62 00 00 |..........lieb..|
-
000000f0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
00000100 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
00000110 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
00000120 00 00 00 00 00 00 00 5a 48 53 31 36 47 42 4b 00 |.......ZHS16GBK.|
-
00000130 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
00000140 00 00 00 00 00 00 20 00 00 00 00 00 00 00 00 00 |...... .........|
-
00000150 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
00000160 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
00000170 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
00000180 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
00000190 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
000001a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
000001b0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
000001c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
000001d0 00 00 00 00 00 00 00 00 00 00 00 00 00 31 31 2e |.............11.|
-
000001e0 30 32 2e 30 30 2e 30 34 2e 30 30 00 00 00 00 00 |02.00.04.00.....|
-
000001f0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
00000200 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
-
00000210 00 00 00 00 00 00 00 00 00 00 30 30 31 3a 30 30 |..........001:00|
- 00000220 31 3a 30 30 30 30 30 31 3a 30 30 30 30 30 31 00 |1:000001:000001.|
再看看看exp檔案
點選(此處)摺疊或開啟
-
00000000 03 00 01 45 58 50 4f 52 54 3a 56 31 31 2e 30 32 |...EXPORT:V11.02|
-
00000010 2e 30 30 0a 44 50 50 5a 48 55 0a 52 55 53 45 52 |.00.DPPZHU.RUSER|
-
00000020 53 0a 38 31 39 32 0a 30 0a 37 32 0a 30 0a 00 01 |S.8192.0.72.0...|
-
00000030 03 69 07 d0 00 01 00 00 00 00 00 00 00 00 00 09 |.i..............|
-
00000040 00 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 |. |
-
00000050 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |
-
00000060 20 20 20 20 20 20 20 20 54 75 65 20 53 65 70 20 | Tue Sep |
-
00000070 31 33 20 32 30 3a 33 31 3a 33 38 20 32 30 31 36 |13 20:31:38 2016|
-
00000080 70 70 7a 68 75 2e 64 6d 70 00 00 00 00 00 00 00 |ppzhu.dmp.......|
- 00000090 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................|
明顯的不同。鬱悶的是沒有字符集,不過版本有。這樣我們也能判斷出事expdp還是exp出來的問題件
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7728585/viewspace-2124879/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 檢視dmp檔案是exp還是expdp匯出來的
- 如何確定一個dmp檔案是exp匯出的還是expdp匯出的?
- 【ASK_ORACLE】一眼判斷出Oracle的dmp檔案是用expdp匯出還是exp匯出Oracle
- 抽取exp/expdp匯出檔案頭的資訊
- 檢視 Oracle 是32位還是64位的方法Oracle
- 如何檢視python是32位還是64位Python
- 如何檢視Linux是32位還是64位Linux
- 檢視安裝的ORACLE是32位還是64位Oracle
- 檢視 Oracle 是用spfile 啟動還是 pfile 啟動Oracle
- 檢視Linux是ubuntu還是centosLinuxUbuntuCentOS
- win10如何檢視電腦是32位還是64位_win10是32位還是64位怎麼檢視Win10
- 檢視ORACLE啟動時使用spfile還是pfileOracle
- WIN10怎麼檢視磁碟是MBR還是GPT win10磁碟初始化mbr還是gpt如何檢視Win10GPT
- 檢視Oracle資料庫是企業版還是標準版Oracle資料庫
- oracle匯入匯出之expdp/impdpOracle
- Oracle匯入(imp )與匯出(exp )Oracle
- 【ORACLE 匯入匯出】exp 錯誤Oracle
- ORACLE匯入匯出命令exp/impOracle
- win10系統如何檢視網路卡是千兆還是百兆Win10
- Linux中如何檢視系統是32位還是64位?Linux
- expdp/impdp來解決exp/imp出現的錯誤並匯入指定表空間
- oracle資料匯出匯入(exp/imp)Oracle
- Oracle 遠端匯出匯入 imp/expOracle
- 檢視oracle鎖相關資訊Oracle
- 如何檢視oracle引數是靜態或者是動態Oracle
- 檢視當前作業系統是ubuntu還是centos作業系統UbuntuCentOS
- liunx下檢視核心是32位還是64位
- Oracle資料泵匯出匯入(expdp/impdp)Oracle
- Oracle exp/imp匯出匯入工具的使用Oracle
- Oracle資料匯入匯出imp/exp命令Oracle
- oracle資料的匯入匯出imp/expOracle
- 怎樣檢視python是64位還是32位Python
- 檢視linux機器是32位還是64位Linux
- 新手指導:教你如何檢視識別hadoop是32位還是64位Hadoop
- Oracle exp只匯出部分資料Oracle
- Oracle資料匯入匯出imp/exp命令(轉)Oracle
- Oracle expdp資料泵遠端匯出Oracle
- Oracle資料庫匯入匯出。imp匯入命令和exp匯出命令Oracle資料庫