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:
Post a Comment