windows下安装数据库

# 一、windows下安装数据库
## 1、安装包
- 下载WINDOWS.X64_193000_db_home
- 解压文件到D:\apporacle
- 点击setup.exe
- 按照步骤按照，注意选择单例模式
- 注意：密码统一用jiahemk

![](/media/202402/2024-02-02_112322_0045600.808379811203966.png)
## 2、创建表空间
【注意】：研发测试的话为了节省电脑硬盘空间故初始化大小为100M，如果正式库需要加大。

````sql
--创建JHEMR表空间
    create tablespace TSP_JHEMR
     datafile 'D:\apporacle\oradata\JHEMR\jhemr.dbf'
     size 100M
     autoextend on;

--创建report表空间
 create tablespace TSP_REPORT
     datafile 'D:\apporacle\oradata\JHEMR\report.dbf'
     size 100M
     autoextend on;

--创建JHFILE表空间
  create tablespace TSP_JH_FILE
     datafile 'D:\apporacle\oradata\JHEMR\jhfile.dbf'
     size 100M
     autoextend on;

--创建JHCDR表空间
create tablespace TSP_JH_CDR
     datafile 'D:\apporacle\oradata\JHEMR\jhcdr.DBF'
     size 100M
     autoextend on;

--创建JHNIS表空间
 create tablespace TSP_JHNIS
     datafile 'D:\apporacle\oradata\JHEMR\jhnis.dbf'
     size 100M
     autoextend on;

--创建JHUPLOADDATACENTER表空间
    create tablespace TSP_JH_UPLOADDATACENTER
     datafile 'D:\apporacle\oradata\JHEMR\UPLOADDATACENTER.DBF'
     size 100M
     autoextend on;
````

## 3、创建用户
```sql
--创建jhemr用户
create user jhemr
  identified by "jiahemk"
  default tablespace TSP_JHEMR
  temporary tablespace temp;
grant connect to jhemr;
grant resource to jhemr;
grant dba to jhemr;

--创建report用户
create user report identified by "jiahemk"
default tablespace TSP_REPORT;
GRANT UNLIMITED TABLESPACE TO REPORT;
GRANT CONNECT TO REPORT;
GRANT RESOURCE TO REPORT;

--创建jhfile用户
create user jhfile identified by "jiahemk"
default tablespace TSP_JH_FILE;
GRANT UNLIMITED TABLESPACE TO jhfile;
GRANT CONNECT TO jhfile;
GRANT RESOURCE TO jhfile;

--创建jhcdr用户
create user jhcdr identified by "jiahemk"
default tablespace TSP_JH_CDR;
GRANT UNLIMITED TABLESPACE TO jhcdr;
GRANT CONNECT TO jhcdr;
GRANT RESOURCE TO jhcdr;

--创建jhnis用户
create user jhnis identified by "jiahemk"
default tablespace TSP_JHNIS;
GRANT UNLIMITED TABLESPACE TO jhnis;
GRANT CONNECT TO jhnis;
GRANT RESOURCE TO jhnis;
GRANT DBA TO jhnis;
GRANT SELECT ANY TABLE TO jhnis;
GRANT CREATE VIEW TO jhnis;

--创建uploaddatacenter用户
create user uploaddatacenter identified by "jiahemk"
default tablespace TSP_JH_UPLOADDATACENTER;
GRANT UNLIMITED TABLESPACE TO uploaddatacenter;
GRANT CONNECT TO uploaddatacenter;
GRANT RESOURCE TO uploaddatacenter;
```
## 4、本机服务器创建DBLINK到47服务器
右键新建DBLINK，名字为JHEMR47

## 5、从47服务器导出数据,并导入到本机
- 【注意】：exp/imp 无法导出空表，故必须用expdp/impdp

```sql
expdp jhemr/jiahemk@JHEMR schemas=JHEMR dumpfile=jhemr47.dmp logfile=expdpjhemr47.log directory=DATA_PUMP_DIR network_link='JHEMR47'

impdp jhemr/jiahemk@JHEMR schemas=JHEMR dumpfile=jhemr47.dmp logfile=impdpjhemr47.log directory=DATA_PUMP_DIR
```

# 二、删除表空间（注意不要执行，存在问题时执行）

- 删除非空表空间，包含物理文件。
如果其他表空间中的表有外键等约束关联到了本表空间中的表的字段，就要加上 CASCADE CONSTRAINTS

```sql
drop tablespace TSP_JHEMR including contents and datafiles;
drop tablespace TSP_REPORT including contents and datafiles;
drop tablespace TSP_JH_FILE including contents and datafiles;
drop tablespace TSP_JH_CDR including contents and datafiles;
drop tablespace TSP_JHNIS including contents and datafiles;
drop tablespace TSP_JH_UPLOADDATACENTER including contents and datafiles;
```

# 三、卸载数据库
## 1）关闭服务
- CMD键入services.msc，然后关闭Oracle的全部服务

## 2）删除注册表
- 1、选择HKEY_LOCAL_MACHINE->SOFTWARE->ORACLE，删除这个文件夹
- 2、选择HKEY_LOCAL_MACHINE->SYSTEM->CurrentControlSet->Services，删除所有关于Oracle的注册信息
- 3、选择HKEY_LOCAL_MACHINE->SYSTEM->CurrentControlSet->Services->Eventlog->Application，删除所有Oracle信息

## 3） 删除环境变量
## 4） 删除数据库
- 删除你安装的Oracle了，比如你安装在了E:\Oracle19c文件夹下，就把这个文件夹全部删掉！！不要留！

## 5）删除数据库log
- 删除C:\Program Files\Oracle\Inventory文件夹下所有文件

## 6）删除快捷方式