Disclaimer

Friday, 10 December 2021

Extract Index DDL from database export dump

PAR file for index ddl extract from dump using traditional import utility
===================================================================

userid= '/ as sysdba '
statistics=none
buffer=9999999
log=/oracle/export/IND/dump/imp_index_full_10122019.log
constraints=n
grants=n
rows=n
FROMUSER=HR
indexfile=/oracle/export/IND/dump/index3.sql
Tables=(EMPLOYEES)
file=(/oracle/export/IND//exp_full_IND.dmp)


To execute the command in background 
===========================================

nohup imp parfile=file_name.par &

No comments:

Post a Comment

Data Guard Standby Resynchronization Using RMAN RECOVER FROM SERVICE (300+ Archive Lag)

Since your standby was lagging by 300+ archive logs, the purpose of this activity was to resynchronize the standby database quickly using in...