Search This Blog

Total Pageviews

Saturday, 24 January 2015

Oracle export as sysdba

Oracle export as sysdba


How to use "/ as sysdba" to exp and imp
How to use / as sysdba to exp
exp userid=\'/ as sysdba\'


*************************************************************************************************
-bash-4.1$ !sql
sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Sat Jan 24 17:54:11 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> def
DEFINE _DATE           = "24-JAN-15" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "vihaan" (CHAR)
DEFINE _USER           = "SYS" (CHAR)
DEFINE _PRIVILEGE      = "AS SYSDBA" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1201000100" (CHAR)
DEFINE _EDITOR         = "ed" (CHAR)
DEFINE _O_VERSION      = "Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options" (CHAR)
DEFINE _O_RELEASE      = "1201000100" (CHAR)


***********************************************************************************************************

parafile 

-bash-4.1$ cat exp.par
file=mydump.dmp
userid="/ as sysdba"               <<<<<<<<<<----- with sys user 
compress=n
log=mydump.log
direct=y
full=n
owner=TEST
consistent=y
feedback=10000



-bash-4.1$ exp parfile=exp.par

Export: Release 12.1.0.1.0 - Production on Sat Jan 24 17:51:53 2015

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
EXP-00105: parameter CONSISTENT is not supported for this user
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TEST
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TEST
About to export TEST's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export TEST's tables via Direct Path ...
. . exporting table                           TEST
                                                         2803 rows exported
EXP-00091: Exporting questionable statistics.
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings.


done .....


-bash-4.1$ ls -ltr *.dmp
-rw-r--r-- 1 oracle oinstall 876544 Jan 24 17:52 mydump.dmp

No comments:

Oracle DBA

anuj blog Archive