expdp/impdp '/ as sysdba'

Aê galera,

Hoje vai a dica...

Realizar um export/import no Oracle usando '/ as sysdba'

[oracle@servidor scripts]$ expdp \"/ as sysdba\" DIRECTORY=backup DUMPFILE=$bkp.dmp FULL=y LOGFILE=$bkp.log
Export: Release 10.2.0.5.0 - Production on Thursday, 15 September, 2011 13:47:27
Copyright (c) 2003, 2007, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_FULL_01":  "/******** AS SYSDBA" DIRECTORY=backup DUMPFILE=bkp_export_ctbc_qui.dmp FULL=y LOGFILE=bkp_export_ctbc_qui.log
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 1.168 GB
Processing object type DATABASE_EXPORT/TABLESPACE
. . exported "DOT_ASSOC"."EXP_GIFE_VW_EQUIPAMENTO"       99.27 MB  335122 rows
. . exported "DOT_ASSOC"."MIG_CONEXAO_VIRTUAIS"          424.7 MB 2919286 rows
. . exported "DOT_ASSOC"."RESULT_LOCALIDADE"             69.25 MB  320145 rows
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER