Four steps of creating table space and user in Oracle

Time:2021-6-23

/*There are four steps*/

/*Step 1: create a temporary table space (Note: D: project, oracletablespace, fhaddmin, create path manually)  */

create temporary tablespace C##FHADMIN_TEMP  

tempfile 'D:\Project\OracleTableSpace\FHADMIN\C##FHADMIN_TEMP.dbf' 

size 50m  

autoextend on  

next 50m maxsize 20480m  

extent management local;

/*Step 2: create the data table space fhadm.org   */

create tablespace C##FHADMIN_DATA

logging  

datafile 'D:\Project\OracleTableSpace\FHADMIN\C##FHADMIN_DATA.dbf' 

size 50m  

autoextend on  

next 50m maxsize 20480m  

extent management local;

/*Step 3: create a user and specify that the table space password is root*/

create user C##FHADMIN identified by root

default tablespace C##FHADMIN_DATA

temporary tablespace C##FHADMIN_TEMP;

/*Step 4: give the user permission to fhadmin.org  */

grant connect,resource,dba to C##FHADMIN;

 

Official website:www.fhadmin.org

———————–Separation of spring boot framework vue.js————–

 

[framework platform] springboot framework vue.js separates fashion style

 

Instant messaging: support friends, groups, send pictures, files, messages, voice reminders, offline messages, keep chat records

 

(the instant chat function supports the mobile terminal, and the details are shown below)

 

Workflow module———————————————————————————————————-

 

1. Model management     : Web online process designer, preview process XML, export XML, deploy process

 

2. Process management     : Import and export process resource file, view process diagram, reflect process model according to process instance, activate suspend

 

3. Running process: view process information, current task node, current flow chart, void and suspend process, assign to-do person

 

4. Historical process: view process information, process time, process status and task initiator information

 

5. To do tasks    : View my personal tasks and tasks under this role, handle, reject, void, and assign an agent

 

6. Tasks done    : Check the tasks you have handled, process information, flow chart and process status (normal completion)

Note:When the current task is finished, the next task to-do person will receive the new task message reminder through instant messaging, which will be regarded as the end of the task,
The task initiator will receive a message notification from the station

 

 

Recommended Today

Implementation example of go operation etcd

etcdIt is an open-source, distributed key value pair data storage system, which provides shared configuration, service registration and discovery. This paper mainly introduces the installation and use of etcd. Etcdetcd introduction etcdIt is an open source and highly available distributed key value storage system developed with go language, which can be used to configure sharing […]