RE: Data pump run as sysdba
- From: "Yong Huang" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "yong321" for DMARC)
- To: Oracle-l Digest Users <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 12 Jun 2017 21:25:34 +0000 (UTC)
Jeff Smith says:
Try to run as SYS and see what happens.
SQLDev will prevent you from doing so b/c of ‘unexpected’ behavior.
The data dictionary perspective changes drastically when going in as SYSDBA.
Jeff,
We sometimes run data pump export and import as sys and never have issues. Do
you know what the different changes in data dictionary or unexpected behaviors
are? That's the very reason I'm posting a question here. For example, my old
note has this:"exp [with consistent=y option] runs set transaction read only at
the beginning of the session, which is silently ignored if the login user is
SYS or any user with sysdba privilege." That's the kind of details I'd like to
have. Thanks to Hemant Chitale who also pointed that out. I'm interested in
more of such details.
Yong Huang
--
//www.freelists.org/webpage/oracle-l
Other related posts:
