I didn’t know Oracle systematically. This time, I set up a table for the new project in Oracle and recorded some experience
1. Create a new database instance?? Generally not required
MySQL connects to edu database: jdbc:mysql :// localhost:3306/edu
Oracle connection orcl instance: jdbc:oracle:thin:@localhost :1521:orcl
Looking at these two connection strings, we can see that edu and orcl seem to have the same status. At the beginning, I mistakenly thought that we need to build a new database instance in Oracle,
Let’s take a look at Oracle’s official description:
Oracle database instance is a group of Oracle background process / thread and shared memory area allocated in the server.
In the attempt to create a new instance, the author encountered the error of memory overflow in. It can be seen that the new instance will consume a lot of memory.
Different projects can share one instance, and the default instance orcl can be used directly.
As for how to separate the tables of different items, you can use different users for different items, and the tables belong to users.
As shown in the following figure, the member table belongs to SSM users and is stored in users table space.
2. Create new table space and temporary table space
create tablespace lic_data
logging
datafile 'D:\oracle11g64\oradata\licData.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
create temporary tablespace lic_temp
tempfile 'D:\oracle11g64\oradata\licTemp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
3. Use the new table space and temporary table space created in the previous step to create a new user
create user adminlic identified by adminlic
default tablespace lic_data
temporary tablespace lic_temp;
4. Give users permission
grant connect,resource,dba to adminlic;
Next, after logging in with a new user, you can create a table.