| Difference in exports, due to DIRECT=y [message #483420] |
Mon, 22 November 2010 00:28  |
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
|
Senior Member |
|
|
Dear Friends,
Herewith i'm showing my try of taking backup through different parameter available with export utility of oracle.
[1] Here i'm considering DIRECT=y
[oracle1@WBDevelop odb]$ exp pbl/pbl FILE=pbl_direct.dmp OWNER=pbl GRANTS=y ROWS=y COMPRESS=y DIRECT=y LOG=pbl.log
[oracle1@WBDevelop odb]$ ll -ltrh
-rw-r--r-- 1 oracle1 oinstall 875M Nov 22 11:09 pbl_direct.dmp
[2] Here i'm eliminating DIRECT=y
[oracle1@WBDevelop odb]$ exp pbl/pbl FILE=pbl_conv.dmp OWNER=pbl GRANTS=y ROWS=y COMPRESS=y LOG=pbl.log
[oracle1@WBDevelop odb]$ ll -ltrh
-rw-r--r-- 1 oracle1 oinstall 875M Nov 22 11:09 pbl_direct.dmp
-rw-r--r-- 1 oracle1 oinstall 885M Nov 22 11:12 pbl_conv.dmp
As i understand DIRECT=y will bypass only the conversion and buffer storing procedure during export backup.
There should not be any change in data or compress level of data.
My question is why there is a difference of (885M-875M) 10M between two files?
Regards
Jimit
|
|
|
|
|
|
| Re: Difference in exports, due to DIRECT=y [message #483440 is a reply to message #483428] |
Mon, 22 November 2010 03:16  |
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
|
Senior Member |
|
|
Dear Michel,
As per your requirement i'm giving you the details that
1)Extracting details through export log file
NLS_LANG settings at export time : Export done US71SCII character set and AL16UTF16 NCHAR character set
2) Extracting details through alert.log file
Database character set : WE8ISO8859P1
But my concern is,
In any case i'm not using or mentioning the character set, either via conventional path or using with DIRECT=y option, Is there any connection of character set with DIRECT=y (Direct Path).
Regards
Jimit
|
|
|
|
|
|
| Re: Difference in exports, due to DIRECT=y [message #483464 is a reply to message #483455] |
Mon, 22 November 2010 05:27 |
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
|
Senior Member |
|
|
Dear Michel
What you suggest is right, and i've to go through the documentation about that. But my assumption is there should not be any difference in data. If i import the same in my another database which is identical installation and setup, there should not be affect my data.
Regards
Jimit
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
