Linux Export database files and several Linux small commands

Cd.. Return to the previous layer;

PWD view current directory;

Ssh-l Oracle oracle_id into the database

Ps-ef|grep Oracle View current Oracle Processes

Sqlplus/nolog into Sqlplus

Use $,sql under Linux! (seems to be so, to be verified later) exp

Exported SQL statement:!exp username/[email protected] file=filename.dmp full=y

The database file, which is placed in the database, needs to be copied out to the application file.

Copy statement in database directory: scp-p 8888/HOME/.../DAOCHU.DMO [Email protected]_id:/home/...remote_file

The beginning of the time always prompted the directory or file does not exist, and then suddenly thought I did not add the port number is this-p, if there must be added, otherwise it will always be reported.

This copy to the application layer, Windows can use WINSCP to download the data, Linux can be used under the command (it seems that I am not Linux, I would like to try)

Linux Export database files and several Linux small commands