sqlplus connect oracle

为什么80%的码农都做不了架构师？>>>   

lsnrctl status

find the sid: lsnrctl service 

sqlplus apps/apps@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.5)(PORT=1521))(CONNECT_DATA=(SID=OAPROD)))"

运行本地命令 SQL> host dir 

export prd

exp user/password tables=task, payment file=payment_task.dmp INDEXES=N CONSTRAINTS=N GRANTS=N ROWS=Y

bakcup uat

exp user/password tables=lic_app, company_cop , company , task, payment  file=cop.dmp INDEXES=N CONSTRAINTS=N GRANTS=N ROWS=Y

import uat

imp user/password tables=case_legal_advice file=case_legal_advice.dmp IGNORE=Y  
imp user/ password full=y file=payment_task.dmp IGNORE=Y

nohup java MyProg > /dev/null 2>&1 &

转载于:https://my.oschina.net/l1z2g9/blog/36348