Enable/Disable constraints, Linux copy

--Disable

select 'alter table '||table_name||' disable constraint '||constraint_name||' ;' from user_constraints where constraint_type = 'R';

--Enable

select 'alter table '||table_name||' enable constraint '||constraint_name||' ;' from user_constraints where constraint_type = 'R';

 

scp %file% username@host:remote directory

e.g. upload conf file to directory my

scp /etc/lilo.conf my@www.***.com:/home/my

 

scp username@host:remotedirectory localdirectory

e.g. download abc.conf to local maxrocray

scp k@www.****.com:/etc/abc.conf /maxrocray