常用命令

window下命令

停止oracle实例服务

net stop oracleserviceORCl

停止oracle实例服务

net start oracleserviceORCl

启动oracle监听服务

lsnrctl start

停止监听服务

lsnrctl stop

启动oracle控制台服务

emctl start dbconsole

停止oracle控制台服务

emctl stop dbconsole

查看oracle字符集

select * from nls_database_parameters where parameter ='NLS_CHARACTERSET'

导入dmp

imp username/pwd@ORCL file=D:\oracle\backup\file\data_20200812.dmp log=D:\oracle\backup\log\data_20200812.log  full=y ignore=y

导入指定表

imp username/pwd file=E:\ymoracle\data_20200828.dmp log=E:\ymoracle\data_2020082.log  TABLES=(E_PUBINFO)