PL/SQL导入数据

妖狐艹你老母 2023-01-18 04:04 150阅读 0赞

PL/SQL 登录  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDAxMzgxNw_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDAxMzgxNw_size_16_color_FFFFFF_t_70 1]  
![在这里插入图片描述][20210430145331458.png]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDAxMzgxNw_size_16_color_FFFFFF_t_70 2]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDAxMzgxNw_size_16_color_FFFFFF_t_70 3]  
![在这里插入图片描述][20210430145344157.png]

create tablespace yycg
    logging
    datafile 'E:\oracle\product\10.2.0\oradata\orcl\yycg.dbf'   --表空间数据文件位置在oracle服务器（如果是虚拟机，位置在虚拟机上）
    size 32m
    autoextend on
    next 32m maxsize 2048m
    extent management local;

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDAxMzgxNw_size_16_color_FFFFFF_t_70 4]  
![在这里插入图片描述][2021043014540330.png]

使用sys创建oracle用户mio账号fly密码（业务系统连接oracle使用的用户）
     
    创建的用户默认的表空间是yycg0730
     
    create user yycg identified by mio
    default tablespace yycg
    temporary tablespace temp;

![在这里插入图片描述][20210430145413889.png]  
给用户授权：

grant connect,resource,dba to yycg;

![在这里插入图片描述][20210430145436375.png]  
第四步：退出sys，使用新创建用户登陆pl/sql  
mio/fly

在pl/sql命令窗口，执行如下脚本 ：
    @F:/oracle_sql/yycg_table.sql
    @F:/oracle_sql/yycg_data.sql

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDAxMzgxNw_size_16_color_FFFFFF_t_70]: /images/20221021/38b3c5c84ed94881b1e58c1149b83909.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDAxMzgxNw_size_16_color_FFFFFF_t_70 1]: /images/20221021/53f2c8458766475a88ba2195edda14d0.png
[20210430145331458.png]: /images/20221021/e9011408325c4422a3499bc0a47afd28.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDAxMzgxNw_size_16_color_FFFFFF_t_70 2]: /images/20221021/073b06fd08394810ab18f1deca8aa6ac.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDAxMzgxNw_size_16_color_FFFFFF_t_70 3]: /images/20221021/ee233be82b6f43d5ba066fb97e927156.png
[20210430145344157.png]: /images/20221021/6a5d1032054c4dd38e619a0c7d017a24.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDAxMzgxNw_size_16_color_FFFFFF_t_70 4]: /images/20221021/e0520430f0764b4cab663af90ecbf941.png
[2021043014540330.png]: /images/20221021/d66fd7f8ca4c44aa9c95729ecd6f0b86.png
[20210430145413889.png]: /images/20221021/e9c1d3808aea45049d0124c73347df6a.png
[20210430145436375.png]: /images/20221021/809fe2e673d644299f8fe1e6e2e12de8.png