Create the table space of the intermediate table

Fund system database operation ： use sys User dba Log in as an identity to operate
function cmd command , Input ：sqlplus / as sysdba

Query tablespace path , The path obtained here is the path required in the next step . Input again select File_Name from dba_data_files;
From the display , There is no intermediate table in this , So create the tablespace of the intermediate table

The path of creating the table space here is the same as the path of the table space you queried above , Everyone's path is different , Note that there can be no spaces between paths

CREATE BIGFILE TABLESPACE "TS_MID" DATAFILE 'D:\app\wen\oradata\atsdb\TS_MID.ora' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

Create intermediate table users

create user impuser identified by test1
  default tablespace TS_MID
  temporary tablespace TEMP
  profile DEFAULT
  quota unlimited on TS_MID;

To intermediate table users (impuser) to grant authorization

grant resource to impuser;
grant connect to impuser;
grant select on V_$session  to impuser;
grant select on V_$sesstat  to impuser;
grant select on V_$statname to impuser;

Create middle table

Batch processing file name

Copy all the intermediate table scripts to a new folder

Create a new text document , Input DIR . /B >LIST.TXT, After saving, change the extension of the text document to .bat, When in charge, the icon will change into a gear shape , Double click this bat file ,, The current directory will generate a LIST Of txt file , This is the file that handles all the intermediate tables of takeout

Click on 【 edit 】 Medium 【 Replace 】, add @ And the path of the intermediate table , Convenient back in plsql The operation
![ Insert picture description here ](https://img-blog.csdnimg.cn/93b3a9a822aa4a27b311569fc28a3010.png

Then change this file to .sql File with extension

After open the plsql, Click on the icon in the upper right corner


@ Then click enter , Select the just created LIST.sql file , Will always jump to the page , Finally, it is successful to show this

webservice The interface test

Enter the test address , And the corresponding sending message , Send successfully , There will be a corresponding return message

At this time, in our multi bank capital system 【 Intermediate table query 】 You can see the data , But pay attention to the time in the message , To correspond to the choice of time

At the same time 【 Quick payment 】 The module will also have data

Then this means that the test is successful