oracle数据库常用

exp           用户名/密码@ip:port/instance_name file=导出路径 full=y
linux:  su - oracle
例子：   exp  root/123456@127.0.0.1:1521/orcl file=/tmp/dc.dmp log=/tmp/dump.log    
doller符

window
exp  username/password@xx.xx.xx.xx:1521/orcl file=D:\bak\hw_monster.dmp

导入(windows cmd命令)：
       imp 用户名/密码@ip:port/instance_name file=导出文件所在路径 full=y
例子： imp root/123456@127.0.0.1:1521/orcl file=d:\dc.dmp full=yowner=ckms_cm

创建一个新用户：create user abc identified by 123456;
授予DBA权限： grant connect,resource,dba to abc;

select count(*) from v$process; --当前的连接数
select value from v$parameter where name = 'processes' --数据库允许的最大连接数
alter system set processes = 300 scope = spfile;   修改最大连接数:

shutdown immediate；
startup；
select value from v$parameter where name = 'processes';
select name from v$datafile;

lsnrctl status

set ORACLE_SID=orcl;

sqlplus username/password@orcl   as sysdba

shutdown immediate
shutdown abort

startup

show parameter dump_dest;