Wednesday, April 4, 2018

Unix for DBA's - Series 2

--list of clients connected to NFS FS

/usr/sbin/showmount -e servername

Tuesday, February 27, 2018

expdp exclude table example

Syntax is handy for expdp exclude tables list


expdp system directory=DBA_DP dumpfile=xOLLER_27Feb.dmp logfile=xOLLER_27Feb.log schemas=xOLLER  exclude=TABLE:\""IN \(\'xOPACKET\',\'xOPCKTDATA\',\'ExxCKTHIST\',\'EOCxxIPKT\',\'EOCxxPKTDATA\',\'EOOUTGxxxFREDREPORT\',\'EOFRExxxTDATA\',\'EOFxxCLIPKT\')\""