安装完成执行操作:
1、空表设置
alter system set deferred_segment_creation=false;
2、密码过期
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
3、做好数据备份,另存为bat文件,任务计划每天执行
@echo off
set filename="D:\健康档案备份\%date:~8,2%日"
exp ehr/ehr file=%filename%.dmp owner=ehr rows=y indexes=y grants=y compress=y log=%filename%.log
rar a %filename%.rar %filename%.*
del %filename%.dmp
del %filename%.log
@exit
oracl命令
sqlplus /nolog
链接数据库
conn sys/sys用户的密码@sid as sysdba
conn sys/sys@172.10.0.208/orcl as sysdba
查询用户
select * from all_users;
删除用户
drop user klehr cascade;
查询表空间
select name from v$datafile;
删除表空间
drop tablespace ATMV(表空间名称) INCLUDING CONTENTS;
删除被占用的用户
1、SELECT username,sid,serial# FROM V$SESSION WHERE USERNAME='***';
2、alter system kill session 'sid,serial#';
3、drop user xx cascade;
第一步骤:
SQL> create tablespace ehrdb datafile 'D:\oracle\oradata\orcl\ehrdb.dbf' size 200m autoextend on next 10m maxsize unlimited;
表空间已创建。
第二步骤:
create tablespace ehrdbindex datafile 'D:\oracle\oradata\orcl\ehrdbindex.dbf' size 200m autoextend on next 10m maxsize unlimited;
第三步骤:创建用户
SQL> create user klehr identified by klehr default tablespace EHRDB;
第四步骤:
grant resource,connect,dba to klehr;
exi
第五步:
然后exit;退出
然后运行imp命令,但是命令的参数你
imp user/password@xxx.xxx.xxx.xxx/orcl file='ddddd' full=y
imp hrtl/hrtl@127.0.0.1/orcl file='D:\20170210hr' full=y
imp klehr/klehr@127.0.0.1/orcl file='D:\ehrds2016.dmp' full=y
导出命令:
exp test/test@192.168.20.20/orcl file = d:\test.dmp tables=(t_test) query = \"where oildate like '2016%'\"