re Export/Import SYS -- was sRe: import from Oracle 9 to 10 hanging
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 29 Jun 2007 20:05:31 +0800
LSC is right .
1. SYS is not to be used for Exports. Note#277237.1 explains why
one should not
connect as SYS when running an Export. Essentially, since SYS does
not follow the
transaction level read-consistency rules, an Export as SYS does not
provide data
consistency (even if CONSISTENT=Y is used).
[The only reasons to use SYS would be when specifically requested by
Oracle Support
or for Transportable Tablespaces]
2. SYS is excluded when running a EXP with FULL=Y.
I did a quick scan of catexp.sql and found the exclusions for ORDSYS,
MDSYS, CTXSYS etc
but couldn't find explicit code which shows how SYS is excluded.
[Probably the exclusion
is not in catexp.sql but in the oracle (exp) binary ?]
At 04:48 PM Friday, LS Cheng wrote:
export full does not export sys (and several), may be that sounds better ;-)
Thanks
--
LSC
On 6/29/07, Stefan Knecht <<mailto:knecht.stefan@xxxxxxxxx>
knecht.stefan@xxxxxxxxx> wrote:
Of course you can export sys:
Hemant K Chitale
http://web.singnet.com.sg/~hkchital
and
http://hemantscribbles.blogspot.com
and
http://hemantoracledba.blogspot.com
"First they ignore you, then they laugh at you, then they fight you,
then you win" !"
Mohandas Gandhi Quotes
: http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » re Export/Import SYS -- was sRe: import from Oracle 9 to 10 hanging
