How to take a dump by excluding the grants in Oracle SQL Query :
expdp system/password@DB_NAME directory=data_pump_dir schemas=SCHEMA_NAME dumpfile=DUMPFILE_NAME.dmp logfile=LOGFILE_NAME.log exclude=grant
expdp system/password@DB_NAME directory=data_pump_dir schemas=SCHEMA_NAME dumpfile=DUMPFILE_NAME.dmp logfile=LOGFILE_NAME.log exclude=grant
No comments:
Post a Comment