几个ORACLE命令

sqlplus / as sysdba

shutdown immediate

startup

lsnrctl status

lsnrctl start

导出导入表

1、导入（cmd命令行执行）
imp system/password@111.111.111.111/orcl  file=d:\name.dmp fromuser=appname touser=appName  log=d:\logname.log ignore=y
2、导出
exp system/password@111.111.111.111/soc file=d:\name.dmp tables=(appName.tableName) query=\" where ...\"