How to create oracle table in navicat

1. Oracle installation

https://blog.csdn.net/libingbojava/article/details/ 82025702

After installation, use Navicat to connect to the Oracle database.

#The user name is temporarily used to log in as system, and the password is the password set during the installation process. XE is the folder where CONTROL.DBF is stored.

Related recommendations: "Navicat for mysql graphic tutorial"

2. Create Oracle data table

Create table:

1. Create data table space

2. Create user (specify the default table space currently created)

Delete table:

1. Delete the user

2. Delete the data table space

The order cannot be reversed. If you delete the data table first, the user’s default table space will not be found. Open Do not open the database.

After the deletion is completed, manually delete the table space in the disk.

When creating a table space, the name must be in uppercase letters, otherwise an error will occur when the path is found after creation.

When creating a user, the default table space is the one just created.

Assign permissions

Minimum login permissions

In "Members belong to" we selected "DBA" permissions. In fact, for ordinary users, we only need to grant the permissions of connect, resource, and create view. But here we choose "DBA" for the convenience of demonstration.

Reference https://www.cnblogs.com/franson-2016/p/5925593.html

3. Data transmission

Log in again Create a user to perform data transmission. This user has permission to operate the table.

The above is the detailed content of How to create oracle table in navicat. For more information, please follow other related articles on the PHP Chinese website!